[ZODB-Dev] RelStorage: Write on master, read from slave(s)?
Chris Withers
chris at simplistix.co.uk
Mon Nov 29 14:17:13 EST 2010
On 26/10/2010 11:27, Shane Hathaway wrote:
> On 10/26/2010 04:04 AM, Anton Stonor wrote:
>> 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.
Wouldn't this require zero replication lag?
Even if the read replicas had only a second or two delay (or spike
delays caused by large writes?), would there not potentially be quite
serious problems?
cheers,
Chris
--
Simplistix - Content Management, Batch Processing & Python Consulting
- http://www.simplistix.co.uk
More information about the ZODB-Dev
mailing list