[pgpool-general: 2506] Re: Common practices for pgpool availability and data replication
ishii at postgresql.org
Thu Jan 30 22:08:20 JST 2014
> Dear All,
> I have a few questions regarding practices with pgpool:
> 1. Typically pgpool is a single point of failure. What is the common
> practice to solve this?
Pgpool-II has its own HA solution called "watchdog". You need to
install two pgpool-II servers, one is master and the other is
> 2. Some of our data (e.g. 10% tables) must be consistent across the cluster
> for every transaction. The rest may differ. Is it possible to have a
> fine-grained replication, where some DMLs would be replicated synchronously
> and the rest would use asynchronous replication?
There's no such a solution with pgpool-II. Sorry.
SRA OSS, Inc. Japan
More information about the pgpool-general