On 10/21/2010 09:44 AM, Andreas Jung wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> Hi there,
> we are currently investigating options for a large-scale solution
> where the machines (ZEO clients and ZEO server) should be separated
> across two data centers. Incoming traffic should be balanced between
> both data centers. Automatic failover and online-replication are
> desirable - "high-performance" is a must.
> The well-known options are:
> Relstorage on top of some RDBMS-related clustering/replication mechanism
Six Feet Up is running RelStorage + MySQL + async replication for one of
their customers. AFAIK, it works well. Also, I expect the new
replication features in Postgres 9 to work well with RelStorage.
Depending on what you're doing, balancing between data centers could be
very complicated. You might start simple by directing traffic to only
one data center at a time.
For more information about ZODB, see the ZODB Wiki:
ZODB-Dev mailing list - ZODB-Dev@zope.org