[pgpool-committers: 6547] 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
------
V4_0_STABLE

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

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