Re: [ADMIN] avoiding split brain with repmgr - Mailing list pgsql-admin

From Phil Frost
Subject Re: [ADMIN] avoiding split brain with repmgr
Date
Msg-id CAC6ry0JcSFFztyE3rMmyw8rvt-O10e22sGBxeWpoPL6i6-xgMw@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] avoiding split brain with repmgr  (Aleksander Kamenik <aleksander.kamenik@gmail.com>)
List pgsql-admin
I recommend looking into Pacemaker if avoiding split-brain is a hard requirement. A proper solution requires:

- A mechanism to fence failed nodes, since "failed" really means "unknown". Without fencing there's a significant probability of split-brain. Pacemaker has a meatware fencing plugin which can be used on its own, or as a backup to automated fencing mechanisms.
- At least three nodes to establish quorum. Otherwise there's a risk that each half of a partition will try to fence the other, thinking the other half has failed.
- A non-trivial consensus protocol, one that's been mathematically studied and reviewed. Like encryption, this is a notoriously difficult problem and not the place for casually designed solutions.


https://aphyr.com/tags/jepsen is a good read on database consistency generally.

pgsql-admin by date:

Previous
From: Don Seiler
Date:
Subject: Re: [ADMIN] CREATE ANY TABLE privileges, etc
Next
From: Jerry Sievers
Date:
Subject: Re: [ADMIN] CREATE ANY TABLE privileges, etc