[pgpool-hackers: 3074] Re: Master watchdog sets quarantine state to primary node

[Tatsuo Ishii]

Hi Usama,

Today Hiramitsu-san asked this again. He wondered if the fix can be
incomporated into 4.0 or not.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

From: Tatsuo Ishii <ishii at sraoss.co.jp>
Subject: [pgpool-hackers: 3050] Re: Master watchdog sets quarantine state to primary node
Date: Wed, 26 Sep 2018 08:12:57 +0900 (JST)
Message-ID: <20180926.081257.1851656052923716506.t-ishii at sraoss.co.jp>

> Hi Usama,
> 
> Thank you for your great presentation in Pgpool-II Day Tokyo
> yesterday.  After the session Hiramitsu-san asked you about
> watchdog. I believe this is the thread he reffered to.
> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
> From: Muhammad Usama <m.usama at gmail.com>
> Subject: Re: Master watchdog sets quarantine state to primary node
> Date: Thu, 29 Mar 2018 22:40:31 +0800
> Message-ID: <CAEJvTzWn17qo__2tE628cQsXcD7dq=zZ_vtVZibRC31eScqgkg at mail.gmail.com>
> 
>> On Thu, Mar 29, 2018 at 10:10 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> 
>>> Usama,
>>>
>>> If the master watchdog sets primary node in quarantine state, no write
>>> query is possible because the query is routed to VIP -> master
>>> watchdog -> standby node. A user claimed that in this case the master
>>> watchdog should resign the master role so that another watchdog node
>>> can take over the role and continue to handle the write query.
>>>
>>> What do you think? For me the suggestion seems reasonable.
>>>
>> 
>> Yes seems like a good suggestion and solution.  I will take a look into
>> this and come up with the fix
>> 
>> Thanks
>> Best Regards
>> Muhammad Usama
>> 
>> 
>> 
>>>
>>> Best regards,
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese:http://www.sraoss.co.jp
>>>
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers