[Pgpool-general] more than one pgpool in replication?

[Tatsuo Ishii]

> Hello,
> Is it possible to have something 2 replicators over the same backends (defining
> the same starting master backendA), like
> 
>   phpweb1                       phpweb2
>    |                                |
>   poolreplicator1            poolreplicator2
>      |                                  | 
>      |         -------------------------|
>      |         |                        |
>      |-----------------------------     |
>      |         |                  |     |
>       backendA                     backendB

Yes possible.

> Or even more, could it have a hw load balancer between the phpwebs and the
> replicators, balancing over them (removing the spof and spreading load)?

Sure.

> Maybe, using a stonith approach for failover events, could avoid split brain.
> Are these ideas viable with pgpool2?

Thanks for the idea. I'm not familiar with stonith but it will be
possible if it could detect the case where phpweb1 and phpweb2 do not
agree with which backend is the master.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp