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.
It looks like RelStorage already keeps seperate connections for read and
write (even though they are not exposed through configuration), so it is
probably easy to set up.
Would it work or is there a risk of getting inconsistent data? Or is that
entirely up to the ability of doing synchronous replication of the
For more information about ZODB, see the ZODB Wiki:
ZODB-Dev mailing list - ZODB-Dev@zope.org