Re: [ADMIN] How do you manage cluster replication and failover ? - Mailing list pgsql-admin

From bricklen
Subject Re: [ADMIN] How do you manage cluster replication and failover ?
Date
Msg-id CAGrpgQ81GJy2znnyFJsGavJ=ppRWNUCWUW7gCfW=9bFM7MsCGA@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] How do you manage cluster replication and failover ?  (Robin LUCBERNET <rlucbernet@maltem.com>)
List pgsql-admin

On Fri, Apr 7, 2017 at 5:12 AM, Robin LUCBERNET <rlucbernet@maltem.com> 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
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).

pgsql-admin by date:

Previous
From: Poul Kristensen
Date:
Subject: Re: [ADMIN] How do you manage cluster replication and failover ?
Next
From: "Lazaro Garcia"
Date:
Subject: Re: [ADMIN] How do you manage cluster replication and failover ?