| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | Robin LUCBERNET <rlucbernet(at)maltem(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How do you manage cluster replication and failover ? |
| Date: | 2017-04-07 13:13:40 |
| Message-ID: | CAGrpgQ81GJy2znnyFJsGavJ=ppRWNUCWUW7gCfW=9bFM7MsCGA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, Apr 7, 2017 at 5:12 AM, Robin LUCBERNET <rlucbernet(at)maltem(dot)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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lazaro Garcia | 2017-04-07 13:26:41 | Re: How do you manage cluster replication and failover ? |
| Previous Message | Poul Kristensen | 2017-04-07 12:50:59 | Re: How do you manage cluster replication and failover ? |