[pgpool-committers: 6548] 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_1_STABLE

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

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