[Pgpool-hackers] Follow master patch modified

[Gilles Darold]

Hi Tatsuo,

+1, but what's about enabling this feature just only when the
follow_master_command is enabled ?
in all other cases we will keep using find_primary_node().

Le 05/04/2011 10:46, Tatsuo Ishii a écrit :
> Just for memory...
>
> I talked to Toshihiro about this patches.  Problem with this approach
> is, if user does not want to promote a standby when the primary goes
> down, pgpool-II waits for recovery_timeout seconds (without this
> patch, pgpool-II immediately returns), which means failover process
> takes for seconds from user's point of view. I'm afraid it's not
> an acceptable behavior.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
>> Hi,
>>
>> How about the attached prototype patch, about the solution of
>> find_primary_node() problem?
>>
>> This patch is simple design and small.
>>
>> - Primary node is "SELECT pg_is_in_recovery()" = false,
>>   Standby node is "SELECT pg_is_in_recovery()" = true.
>> - Wait till a primary node appears when failover occurred.
>> - Use recovery_timeout for timeout.
>>
>> Any feedback will be appreciated.
>>
>> -- 
>> Toshihiro Kitagawa
>> SRA OSS, Inc. Japan
>>
>> On Wed, 30 Mar 2011 16:45:34 +0900
>> Toshihiro Kitagawa <kitagawa at sraoss.co.jp> wrote:
>>
-- 
Gilles Darold
Administrateur de bases de données
http://dalibo.com - http://dalibo.org