[pgpool-committers: 6545] pgpool: Disallowing the quorum aware failover option for the native rep

Muhammad Usama m.usama at gmail.com
Tue Feb 18 23:23:08 JST 2020


Disallowing the quorum aware failover option for the native replication mode.

In native replication mode, Pgpool-II is responsible for replicating the data
on all backend nodes, and if a node becomes quarantined then Pgpool-II stops
sending the writes to that node and when that quarantined node becomes available
again there is no way to figure out which portion of data was not replicated
during the quarantine period. This is dangerous since it can cause
data inconsistency.

So as per the discussion, we reached the conclusion to disallow failover require
consensus and quorum existence with the native replication mode so that backend
node should never get into quarantine when Pgpool-II is configured in the
replication mode.

Branch
------
V3_7_STABLE

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=49ece420a005ff8395c0dc33d5e7de0772230d07

Modified Files
--------------
doc/src/sgml/watchdog.sgml                | 13 ++++++++++++-
src/config/pool_config_variables.c        | 14 ++++++++++++++
src/sample/pgpool.conf.sample-replication | 10 ++++++----
3 files changed, 32 insertions(+), 5 deletions(-)



More information about the pgpool-committers mailing list