Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsNWr-007nAL-3H for pgsql-general@arkaria.postgresql.org; Mon, 16 Oct 2023 13:21:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qsNWn-000phL-WF for pgsql-general@arkaria.postgresql.org; Mon, 16 Oct 2023 13:21:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsNWn-000phA-KK for pgsql-general@lists.postgresql.org; Mon, 16 Oct 2023 13:21:02 +0000 Received: from mail1.dalibo.net ([51.159.93.128] helo=mail.dalibo.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsNWk-000zEU-Hy for pgsql-general@lists.postgresql.org; Mon, 16 Oct 2023 13:21:01 +0000 Received: from karst (82-65-23-130.subs.proxad.net [82.65.23.130]) by mail.dalibo.com (Postfix) with ESMTPSA id 20DAC1F7EE; Mon, 16 Oct 2023 15:20:57 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1697462457; bh=bF0YNLCG6h7iIe2v9wJ8arO05klYlteOFKi5+6PWvW8=; h=Date:From:To:Cc:Subject:In-Reply-To:References:From; b=BEllRlEEcQHh+9UFG9GxEQhCax2egzcIxG2kebbAX/RFIwCW6Zseld2mJArORbT85 QMBsT8evL+G4oz/wR219pudytcKF/hIV+4sNJRv2KrvVT6GrwzO1HnvL6lET/qegpL NkwYvpAry5r/h6yrgycla2hhetS2O4F4dJ20gPiU= Date: Mon, 16 Oct 2023 15:20:56 +0200 From: Jehan-Guillaume de Rorthais To: Laura Smith Cc: "pgsql-general@lists.postgresql.org" Subject: Re: Postgresql HA cluster Message-ID: <20231016152056.57c74d08@karst> In-Reply-To: References: <12601231697122729@mail.yandex.ru> <20231013151006.1348c722@karst> Organization: Dalibo MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 13 Oct 2023 19:21:46 +0000 Laura Smith wrote: > ------- Original Message ------- > On Friday, October 13th, 2023 at 14:10, Jehan-Guillaume de Rorthais > 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,