[pgpool-general: 5188] Re: Architecture Questions

Tatsuo Ishii ishii at sraoss.co.jp
Wed Dec 21 09:46:34 JST 2016

> So, application servers in the West and East regions will talk to a DB primary in the East region thru a WAN?  That's prob not going to work all that well, unless that's an awefully fast/low latency WAN.  You'd be better off in all likelihood to route app traffic to app servers in East, vs routing db protocol traffic across regions, I'd think.
> I would see Postgres-BDR (Bi-Directional Replication) + HAProxy as a much better solution in this kind of scenario...little or no worries over a split-brain.  (Unless there's something the app does that BDR does not support...possible, but not all that likely.) Reach out to me if you want details.

Before jumping into BDR, I recommend to read this carefully:


Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list