[ZODB-Dev] ZODB replication and high-availability across data centers

[Shane Hathaway]

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:
>
> ZRS
> (ZEO)
> 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.

Shane