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

Tatsuo Ishii ishii at sraoss.co.jp
Wed Sep 26 08:12:57 JST 2018


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
>>


More information about the pgpool-hackers mailing list