[Pgpool-hackers] proposal for new feature

[mitani at sraw.co.jp]

Hi Guillaume,
Thank you for quick comments.

I think some informations are required for redundancy as follows,
(1) the basic information of each pgpool like a port and IP address etc.
(2) the basic information of DB servers like a port, IP address etc.
(3) the status of each pgpool like a master/slave and running/standby/stop etc.
(4) the status of DB servers like a master/slave and running/standby/stop etc.

I think that the redundant process might be work based on these informations.

Regards,
--
At.Mitani

 -- original message --
From: Guillaume Lelarge<guillaume at lelarge.info>
To: <mitani at sraw.co.jp>
Cc: Tatsuo Ishii<ishii at sraoss.co.jp>;<pgpool-hackers at pgfoundry.org>
Sent: Fri, 18 Nov 2011 13:57:12 +0100
Subject: Re: [Pgpool-hackers] proposal for new feature

>On Fri, 2011-11-18 at 21:15 +0900, mitani at sraw.co.jp wrote:
>> Hi Ishii-San,
>> 
>> Thank you for quick response.
>> 
>> In order to implement of redundancy for pgpoll, 
>> I think three functions are required as follows,
>> Observation, Take over and Recovery.
>> 
>> How to share the information, 
>>  that's a key point of this solution.
>> There are two methods to share the information.
>>  (1) servers use a data at same data location,
>>  (2) servers use same contents of data in own storage.
>> In either case have some pros and cons.
>> 
>> I'm planing to use the (1) method cause it can make simple.
>> And I'm going to use database as a shared data repository for pgpools.
>> In that case, the communication protocol also might be based on the libpq.
>> 
>> Anyway, this is still just an idea.
>> I'd like to have any comments for it.
>> 
>
>Indeed, it's really interesting. I'm only wondering what kind of
>informations you'll need to keep. I would rather keep the multimaster
>capacity of pgpool like you said in your previous mail. So I guess the
>informations needed are the nodes' status, and the current action on a
>node. Is there anything more?
>
>
>-- 
>Guillaume
>  http://blog.guillaume.lelarge.info
>  http://www.dalibo.com
>
>