[pgpool-general: 2506] Re: Common practices for pgpool availability and data replication

Tatsuo Ishii 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
standby.

> 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.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the pgpool-general mailing list