[Pgpool-general] Several instances of pgpool simultaneously
ariabushenko at eerc.kiev.ua
ariabushenko at eerc.kiev.ua
Mon Feb 11 13:30:44 UTC 2008
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?
More information about the Pgpool-general
mailing list