Cluster of 3 instances in distinct datacenters
Cluster of 3 instances in distinct datacenters
От:
Michael Grimm <trashcan@ellael.org>
Дата:
Hi, I do currently run a postgres cluster spread over two datacenters about 200km apart. One primary, two secondaries and a master for pg_auto_failover (PAF). This cluster has to deal with a data volume of 8 GB and read-write operations with numbers of the very low end. This setup runs perfectly well for the last month. Now, I intend to move the server -running the PAF master and a secondary without quorum- to a datacenter about 1600km distant to the primary and other secondary with quorum. Ping between datacenters 200km apart are ~3ms, ping to the datacenter 1600km apart is ~24ms Given the low traffic this cluster has to deal with: can a PAF master running at such a distant datacenter control the cluster? Thanks and regards, Michael