[pgpool-hackers: 3513] Re: Quarantine state in native replication mode is dangerous

Muhammad Usama m.usama at gmail.com
Thu Feb 13 15:59:54 JST 2020


Hi Ishii-San


On Thu, Feb 13, 2020 at 6:08 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > Usama,
> >
> > I think quarantine state in native replication mode could cause data
> > inconsistency. Below is a step to reproduce the problem.
> [snip]
> > Probably we should not allow setting failover_require_consensus to on
> > in native replication mode, or at least add a strong warning to not do
> > so in the doc. What do you think?
>

I think not allowing the failover_require_consensus is the better way to go
here,
Since we are dealing with inconsistent data issue so in my opinion just a
warning
message would not be good enough.


Best regards
Muhammad Usama

>
> Probably at least we should change the default value for
> failover_require_consensus to off in pgpool.conf.sample-replication
> toward next minor release scheduled on February 20.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200213/aec76f07/attachment.html>


More information about the pgpool-hackers mailing list