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.
Why do you need 3 pg-pool instances? 2 instances uses watchdog should be sufficient? And if you plan to use sync replication you need to plan for 3 PostgreSQL Servers (a 3rd one that the sync replication can fail-over to).
Regards, Jan -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
