|
Several instances of pgpool simultaneously: msg#00004db.postgresql.pgpool.general
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> |
|---|---|---|
| Previous by Date: | Re: PGpool-HA: 00004, y.tanida |
|---|---|
| Next by Date: | Re: Several instances of pgpool simultaneously: 00004, Yoshiyuki Asaba |
| Previous by Thread: | PGpool-HAi: 00004, "Stéphane A. Schildknecht" |
| Next by Thread: | Re: Several instances of pgpool simultaneously: 00004, Yoshiyuki Asaba |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |