Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpvlK-0004Qe-7u for pgsql-admin@arkaria.postgresql.org; Wed, 24 Nov 2021 17:08:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mpvlJ-0004aC-6n for pgsql-admin@arkaria.postgresql.org; Wed, 24 Nov 2021 17:08:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpvlI-0004Zw-Sx for pgsql-admin@lists.postgresql.org; Wed, 24 Nov 2021 17:08:48 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpvlG-0001Lw-7J for pgsql-admin@lists.postgresql.org; Wed, 24 Nov 2021 17:08:48 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 06ED13805AD; Wed, 24 Nov 2021 18:08:45 +0100 (CET) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id ZXWOCw8HoPD8; Wed, 24 Nov 2021 18:08:44 +0100 (CET) Received: from [127.0.0.1] (p5b248423.dip0.t-ipconnect.de [91.36.132.35]) by rs.plausibolo.de (Postfix) with ESMTPSA id B16D838059E; Wed, 24 Nov 2021 18:08:44 +0100 (CET) Date: Wed, 24 Nov 2021 18:08:42 +0100 From: Holger Jakobs To: pgsql-admin@lists.postgresql.org, Simon Riggs , MichaelDBA CC: Firthouse banu , pgsql-admin Subject: Re: User-Agent: K-9 Mail for Android In-Reply-To: References: <6cb32d43-75d1-b896-5267-48d75c536808@sqlexec.com> Message-ID: <0ED6B91F-C228-404F-A4F2-B9532E205B2D@jakobs.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 24=2E November 2021 18:06:45 MEZ schrieb Simon Riggs : >On Wed, 24 Nov 2021 at 14:03, MichaelDBA wrote= : >> >> You do understand that multi-master replication is not acid-compliant >> and the implications of that, right? It only works well for "read >> globally, write locally" scenarios=2E > >This isn't true=2E > >Async multi-master has performance advantages, but some drawbacks=2E But >systems such as BDR3 allow multiple modes of operation that overcome >these perceived issues=2E > Are you aware that the original poster asked for open source solutions? Of course, BDR3 is a great tool=2E --=20 Holger Jakobs, Bergisch Gladbach +49 178 9759012 - sent from mobile, therefore short -