[pgpool-general: 5188] Re: Architecture Questions

[Tatsuo Ishii]

> 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:

http://bdr-project.org/docs/next/conflicts.html

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