[pgpool-general: 4111] Re: Pgpool cluster for several postgres clusters

[Darwin Wirawan]

Hi Jonathan,

Thanks for the reply! About the SPoF, I think we could reduce it with
deploying several pgpools with watchdog. But, is there anyway to make
pgpool cluster to handle all of database clusters? I think it'll be great
since we do not have to manage many pgpool clusters for each database
cluster.

Any idea?

Thanks,
Darwin

On Tue, Oct 13, 2015 at 11:28 AM, Jonathan Eastgate <
jonathan.eastgate at simpro.co> wrote:

> Hi Darwin.
>
> As far as I know you'll need a separate PGPool server for each cluster.
> This is also good from a distribution point of view - as having one PGPool
> server handling all your clusters could become a very single point of
> failure for all your dbs's.
>
> Cheers!
>
>
> *Jonathan J. Eastgate*
> Chief Technology Officer | simPRO Software Group
> Ph: 1300 139 467    +61 7 3147 8777
>
>
>
> Keep up to date with simPRO at: simpro.co/blog
> The contents of this email are subject to our email disclaimer
> <http://simpro.com.au/legal/email-confidentiality-notice/>.
>
>
> On Tue, Oct 13, 2015 at 2:20 PM, Darwin Wirawan <coooldrw at gmail.com>
> wrote:
>
>> Hey pgpool team,
>>
>> Do we have to use one pgpool cluster for one database cluster? Or could
>> we just use one pgpool cluster for several clusters? So we can have
>> centralized pgpool cluster. Does pgpool have that feature?
>>
>> Thanks,
>> Darwin
>>
>> _______________________________________________
>> 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/20151013/f4c8aa67/attachment.html>