<div dir="ltr"><div>Dear Mr. Ishii Sir ... and All<br></div>I Really appreciate your response<br><div><div><br><div class="gmail_quote"><div dir="ltr">On Sun, Nov 18, 2018 at 7:11 AM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi bino,<br>
<br>
My guess is,<br>
<br>
- Load balancing will work. DNS round robin will assign 10.10.10.1 or<br>
10.10.10.2 to Pgpool-II but it should work.<br>
<br>
- Health checking will not work. After health checking detects a fault<br>
of standby, it notices the Pgpool-II main process that<br>
replica.pgcluster.service.bino.inc' is down, then it detach standby<br>
1, even if remaining standby is healthy.<br>
<br>
- Streaming replication delay checking will not work. I will report<br>
the delay for 10.10.10.1 or 10.10.10.2 depending on the DNS round<br>
robin. So the result will not consistent.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br><br><br></blockquote><div>well , Actualy health check and replication things I think will handled by patroni.<br></div><div>In this scenario, I positioned pgpool-II only to split request Between SELECT and WRITE..<br></div><div>Is that make sense ?<br><br></div><div>Patroni will decide which one is Master and Replicas.<br><br></div><div>BTW, is there any documentation in using 3 PG-POOL with 3 Postgres host ?<br></div><div>I just want that my user only see single hostname, but don't want 'single point of failure'.<br><br></div><div>Sincerely<br></div><div>-bino-<br></div><div><br></div></div></div></div></div>