| From: | Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com> |
|---|---|
| To: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
| Cc: | jgdr(at)dalibo(dot)com, inzamam(dot)shafiq(at)hotmail(dot)com, cyberdemn(at)gmail(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Patroni vs pgpool II |
| Date: | 2023-04-07 05:41:11 |
| Message-ID: | CANNMO+LcFb_8hfDKYfPyROuEoZtbeM5X7JtGsAwP27NYonEt=w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Apr 6, 2023 at 9:17 PM Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> wrote:
> With quorum failover is enabled, w0, w1, and w2 communicate each other
> to vote who is correct (if it cannot communicate, it regards other
> watchdog is down). In the case above w0 and w1 are majority and will
> win.
Communication takes time – network latencies. What if during this
communication, the situation becomes different?
What if some of them cannot communicate with each other due to network issues?
What if pg1 is currently primary, pg0 is standby, both are healthy, but
due not network issues, both pg1 and w2 are not reachable to other
nodes? Will pg1 remain primary, and w0 and w1 decide to promote pg0?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2023-04-07 06:13:28 | Re: Patroni vs pgpool II |
| Previous Message | Ron | 2023-04-07 05:15:22 | Re: Patroni vs pgpool II |