[pgpool-general: 8405] Re: failover

[Bo Peng]

Hello,

> In a properly configured pgpool cluster should one be able to failover a 2nd time in a 3 node cluster?  To be clear, systemA is primary and fails, leaving systemB (new primary) and systemC (standby) up and running.  Shortly after, SystemB fails.  Should the VIP move to systemC and continue to allow RW access to the Data?

No.
If only SystemB and SystemC are running and SystemB fails,
VIP will not be assigned to any node, because quorum doesn't exist.
It is the safest way to avoid split brain.

Regards,
-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/