Am 2015-04-08 10:22, schrieb Wei Shan:
In the PostgreSQL world, what do you guys think would be the
equivalent?
Attached is a diagram I have thought of. Clusters of pg-pool2 used to
load balance the connection in and for connection failover when a DB
crashes. Between master and slave, sync replication is being used for
zero-data-loss.
If you haven't already, You probably should take a look at BDR: https://wiki.postgresql.org/wiki/BDR_Quick_Start
-Mark