On Fri, Apr 7, 2017 at 5:12 AM, Robin LUCBERNET <rlucbernet@xxxxxxxxxx> wrote:
How do you manage the failover with your virtual servers ?
Do you handle it manually or use another system to automate it ?
At work we use Patroni with Zookeeper to handle detecting if the master has failed then initiating the failover to a replica.
https://github.com/zalando/patroni
https://github.com/zalando/patroni
However, we are running with asynchronous replication, and in our current setup we only have a single replica to fail over to (in the same data centre), the disaster recovery replicas in other data centres are failed over to manually (it was easier to set it up that way to prevent any unwanted cross-DC failovers).
