pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / 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