[ZODB-Dev] RelStorage: Write on master, read from slave(s)?

[Anton Stonor]

Hi Shane,



In order to scale an application using RelStorage I was thinking about
>> seperating reads and writes accross databases. Writes would go to a
>> Mysql master and the app would read from one or more Mysql slaves.
>>
>
> If you mean that you intend to set up some clients to write to a master
> database, while other clients only read from asynchronous replicas, then
> yes, you'll be in good shape.  You should be able to get amazing scalability
> that way.


That is what I want. Sounds great.

My assumption was that if a client was reading from a relica before fresh
data was replicated I would get old data. That was why I was talking about
synchronous replication.

/Anton
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zodb-dev/attachments/20101026/dd640408/attachment.html