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

Athanasios | ZenGuard athanasios at zenguard.org
Thu Jan 30 20:18:25 JST 2014


Hi,
for point 1) you can use keepalived and two pgpool machines


On Thu, Jan 30, 2014 at 12:00 PM, Gintautas Sulskus <gingaz at gmail.com>wrote:

> 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?
> 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?
>
> Thanks!
>
> Best Regards,
> Gintautas
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140130/66b5cd88/attachment.html>


More information about the pgpool-general mailing list