From: stevenchang1213 <stevenchang1213@gmail.com>
To: Robin LUCBERNET <rlucbernet@maltem.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: How do you manage cluster replication and failover ?
Date: Fri, 07 Apr 2017 20:36:40 +0800
Message-ID: <58e787dd.8995620a.866c2.6c67@mx.google.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
hi robin,
All ur words is just one thing - pgpool II. The project also contains Admin UI. U can download and try it.
steven
-------- 原始訊息 --------自： Robin LUCBERNET <rlucbernet@maltem.com> 日期： 2017/4/6 17:17 (GMT+08:00) 至： pgsql-admin@postgresql.org 主旨： [ADMIN] How do you manage cluster replication and failover ?
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stevenchang1213@gmail.com, rlucbernet@maltem.com
Subject: Re: How do you manage cluster replication and failover ?
In-Reply-To: <58e787dd.8995620a.866c2.6c67@mx.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox