On Fri, 13 Oct 2023 19:21:46 +0000 Laura Smith <n5d9xq3ti233xiyif2vp@xxxxxxxxxxxxx> wrote: > ------- Original Message ------- > On Friday, October 13th, 2023 at 14:10, Jehan-Guillaume de Rorthais > <jgdr@xxxxxxxxxx> wrote: > > > But really, double check first why a simple primary-standby architecture > > doesn't meet your needs. The simpler the architecture is, the better. Even > > from the application point of view. > > > > > From my perspective I do wonder why Postgres doesn't have an equivalent to > MySQL Group Replication. > > Although you can run MySQL GR as multi-primary, most people run it as > primary-standby. > > However the difference with Postgres is that MySQL Group does leader > election. Whilst Postgres failover/failback is a highly manual affair. PostgreSQL core only cares about primary-standby replication. Auto-failover must involved various components way outside of the scope of PostgreSQL itself: the system, the network, sometime the storage, a quorum mechanism, sometime some fencing, etc. There's various auto-failover, non manual, solutions in PostgreSQL ecosystems, they just all live outside of the core. Regards,
