[pgpool-general: 1417] Is it possible to cluster pgpool?

[Michael]

I am looking at doing cross datacenter replication. My servers are on
separate subnets so I cannot use the same ip address between datacenters. I
was thinking of using a global (dns) load balancer and configuring pgpool
to use a different "vip" on each instance.

I also want to know if it is possible to run more than two instances of
pgpool (i know it currently uses watchdog).

What I would like is to be able to tell each pgpool server about all the
other ones. then they elect a failover monitor. If failover
monitor fails they elect a new one, but all servers can pool/loadbalance.

The failover monitor would be responsible for promoting one of the slaves
to master and informing all the other pgpool servers of the change.


Is there anything like this?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130220/4d7f94fc/attachment.html>