pg.ddx.io pgsql-general@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
To: Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Postgresql HA cluster
Date: Mon, 16 Oct 2023 15:20:56 +0200
Message-ID: <20231016152056.57c74d08@karst> (raw)
In-Reply-To: <vpcXDAHFD1W7p676FE7rDkNf1qbvanrr7fAiULGOG0WmbUPQ2ZrlnOxgO7QTG8NB6m9fuGuP8o_Mm-9eduG7xjxeotEM-6KC2d0E9Mzxfk8=@protonmail.ch>
References: <YQBPR0101MB6282FB50CD4ED470B98DEF20E4CDA@YQBPR0101MB6282.CANPRD01.PROD.OUTLOOK.COM>
<YQXPR01MB62865246E684BD30645B68B3E4CCA@YQXPR01MB6286.CANPRD01.PROD.OUTLOOK.COM>
<12601231697122729@mail.yandex.ru>
<YQBPR0101MB628268D625DC924D614E0C03E4D2A@YQBPR0101MB6282.CANPRD01.PROD.OUTLOOK.COM>
<20231013151006.1348c722@karst>
<vpcXDAHFD1W7p676FE7rDkNf1qbvanrr7fAiULGOG0WmbUPQ2ZrlnOxgO7QTG8NB6m9fuGuP8o_Mm-9eduG7xjxeotEM-6KC2d0E9Mzxfk8=@protonmail.ch>
On Fri, 13 Oct 2023 19:21:46 +0000
Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch> wrote:
> ------- Original Message -------
> On Friday, October 13th, 2023 at 14:10, Jehan-Guillaume de Rorthais
> <jgdr@dalibo.com> 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,
view thread (13+ messages) latest in thread
Message-ID: <20231016152056.57c74d08@karst> Permalink: ../20231016152056.57c74d08@karst/ Also on: postgresql.org/message-id/20231016152056.57c74d08@karst ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-general@postgresql.org Cc: jgdr@dalibo.com, n5d9xq3ti233xiyif2vp@protonmail.ch Subject: Re: Postgresql HA cluster In-Reply-To: <20231016152056.57c74d08@karst> References: <YQBPR0101MB6282FB50CD4ED470B98DEF20E4CDA@YQBPR0101MB6282.CANPRD01.PROD.OUTLOOK.COM> <YQXPR01MB62865246E684BD30645B68B3E4CCA@YQXPR01MB6286.CANPRD01.PROD.OUTLOOK.COM> <12601231697122729@mail.yandex.ru> <YQBPR0101MB628268D625DC924D614E0C03E4D2A@YQBPR0101MB6282.CANPRD01.PROD.OUTLOOK.COM> <20231013151006.1348c722@karst> <vpcXDAHFD1W7p676FE7rDkNf1qbvanrr7fAiULGOG0WmbUPQ2ZrlnOxgO7QTG8NB6m9fuGuP8o_Mm-9eduG7xjxeotEM-6KC2d0E9Mzxfk8=@protonmail.ch> <20231016152056.57c74d08@karst> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox