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

[Jonathan Eastgate]

Hi there.

For the multi-clusters - not that I am aware of - although would be
interested to see if anyone else has managed to get this configured.

As for watchdog implementation -
http://www.pgpool.net/docs/pgpool-II-3.2.0/wd-en.html

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:44 PM, Darwin Wirawan <coooldrw at gmail.com> wrote:

> 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/9507e837/attachment-0001.html>