[pgpool-general: 5195] Re: Architecture Questions

Christophe Pettus xof at thebuild.com
Thu Dec 22 07:41:29 JST 2016

> On Dec 21, 2016, at 14:25, Yates, James C. -ND <James.C.Yates.-ND at disney.com> wrote:
> I’m depending on PgPool for automated failover.

There are some complexities here.

To answer your original question, there's really no way of preventing the split-brain problem except to just not promote 1 East when there's a network partition, and wait for it t come back up.  This means that East region customers won't be able to write to the database until that's restored.

Without trying to redesign the whole architecture, I think you may be fighting pgpool rather than benefitting from it in this particular architecture, at least where the WAN link and promotion across it is concerned.  You might take a look at some kind of multi-master between 1 East and 1 West, so that each side can keep going in the event of a network partition (and so that East customers don't have to go across the WAN in order to write to the database), and use pgpool (or, if you don't need the single IP that pgpool gets you, something like Patroni) to handle failover within the East and West regions.

-- Christophe Pettus
   xof at thebuild.com

More information about the pgpool-general mailing list