How do you manage cluster replication and failover ?

From: Robin LUCBERNET <rlucbernet(at)maltem(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: How do you manage cluster replication and failover ?
Date: 2017-04-06 09:17:53
Message-ID: AMXPR05MB216411C9A2BEE861B13C856AB0D0@AMXPR05MB216.eurprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

We are currently trying to setup a multi hosts databases cluster with goals:
* replication (no data-loss is "required", replication timing do not needs to be instant)
* failover
* load-balancing (bonus)

We tried:
* synchronious replication (pgpool replication mode) + load-balancing (pgpool) : very interesing as we can theorically failover on any node at any moment. But even after several configuraation tweeks, we never succeed getting good write performance.
* asynchronious replication (postgres 9.6 streaming replication) : good write performance, good replication timings (< 1 second for small transactions). We could loadbalance select requests using pgpool.

How do you manage your postgresql clusters ? Do you use pgpool ? pgbouncer ? other ?
How do you manage to single access point ? usign pgpool ? pgbouncer ?
Do you use streaming replication ? WAL archiving ? How do you handle to automatic failover ?

Robin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Poul Kristensen 2017-04-06 16:16:42 Re: How do you manage cluster replication and failover ?
Previous Message Devrim Gündüz 2017-04-06 08:11:08 Re: psqlODBC version 09.06.0200 for Red Hat 6.8.