logo       

Several instances of pgpool simultaneously: msg#00004

db.postgresql.pgpool.general

Subject: Several instances of pgpool simultaneously

I am planning to use pgpool for load-balancing and fail-over in
multi-master db cluster, but one thing thing stops me from doing
that. I can't find a way to launch several pgpools. In order to avoid
single point of failure and to reduce network lattency, I want to give
each node its own pgpool instance.

The documention says that several instances of pgpool can't work
together in replication mode, because one instace of pgpool will
continue to send queries when other one is replicating. Is there a way
to tell other instances of pgpool to suspend their activity, while
replicating? Possibly to send STOP and CONTINUE signals using some
shell script? Can I use PCP for that task?

Or I can use some other replication facility not the one that pgpool
has. Is there other replicators available that can work in sync
multi-master environment?


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise