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 1mpvo0-0004VW-Ry for pgsql-admin@arkaria.postgresql.org; Wed, 24 Nov 2021 17:11:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mpvnz-0000LR-IQ for pgsql-admin@arkaria.postgresql.org; Wed, 24 Nov 2021 17:11:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpvnz-0000IK-7J for pgsql-admin@lists.postgresql.org; Wed, 24 Nov 2021 17:11:35 +0000 Received: from mail-oi1-x235.google.com ([2607:f8b0:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mpvnw-0008R0-KX for pgsql-admin@postgresql.org; Wed, 24 Nov 2021 17:11:34 +0000 Received: by mail-oi1-x235.google.com with SMTP id bk14so6666174oib.7 for ; Wed, 24 Nov 2021 09:11:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=PRbuqRLGwK677lnyGZFxExKVPo4WkZNZOFY3UZuft1Y=; b=Od9J5BCSQyJRl67BYwm2jZF5yzTUiO/red1+HvIBa3FZedOqKpHpwt/0qxb3lpFO1V D4pjq8fGyc9yUv+6X8ZDFFUIKnIa2x9DZFDpe/grmfSnJ1HT9eMjYye801S/yfKPO+Ot rQNHfugf2MitPc78gZpddeDGa5QjB5LsBT52X2SdE3N+1z1khjb0y7EK/op0K1zbyy4c F+oy5aSEw419Zp/2K0DuoqzyEQIoEKNHES8nQbz1Qc4+UpzvachBMsTWvikf1ztVeGFL UErHHpfxyVE5gapphjdqY1RGn49zKWQSP00SvsVjTR5198GQvGEJ8rUNqTxj0DGUQirD pp+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=PRbuqRLGwK677lnyGZFxExKVPo4WkZNZOFY3UZuft1Y=; b=j/vPa2Bp25Tb38v+coK879DtErJ56ZNE7GU/h1SVZeK/ntkYWbk4DiZfUntn8B7KO8 sR0mmGcni5KxETiAYn99bi2FpnHe23QC7F0/cLK8f96PmNpr3uOKtKemY3E0zzUuFQM1 FZ47GA8olskubqtgNxeTsS1rgVeiUYU9iPeyNA1W55lLgZbUfL9c6clEKI9vwsaj3i25 4jms4qDlJW331gTkD1qCNbvQIx2zmQnIo9Jb7zmytj8zjpaEnPtLwb7Tyjt2zDxaHA8o lgq7tM30qGaonVbQjygsZ27XtuCm7p9m1voJPIAhmwVQNimLRT+cwyWGGfaXBjS/Fcp4 NPlg== X-Gm-Message-State: AOAM532NDcmta1LS3zt6IHgCWMmVMLe7GiCPPaLGfusGZsJ2k/WlWL0b v3ebn0mlklPPz26QfBHH+TOaEIXC5TTE1achUY0YhDExoNcD26RDTSET49E1nppBhlY2Q9z34Px ydWuWdP8graK2I4O1PrtQHsehlxnB0gBOQTQLmHPXJQXCyAepQEhGRlE1xFLphqo0eumGjbB7g7 4LZ+rbGLojZYduluQUAXD5VSOmhkk25sureRCswnGXfypgzMw= X-Google-Smtp-Source: ABdhPJxwQrQH+K+OW/nqmZZvxhuDHCltg31zx75a1x9+z/SLiogaUpUf9WAUBuhNbFbq1D/vSBgXJh3KUb32tkf2axY= X-Received: by 2002:aca:7c3:: with SMTP id 186mr7862493oih.60.1637773891960; Wed, 24 Nov 2021 09:11:31 -0800 (PST) MIME-Version: 1.0 References: <6cb32d43-75d1-b896-5267-48d75c536808@sqlexec.com> <0ED6B91F-C228-404F-A4F2-B9532E205B2D@jakobs.com> In-Reply-To: <0ED6B91F-C228-404F-A4F2-B9532E205B2D@jakobs.com> From: Simon Riggs Date: Wed, 24 Nov 2021 17:11:20 +0000 Message-ID: Subject: Re: To: Holger Jakobs Cc: pgsql-admin@lists.postgresql.org, MichaelDBA , Firthouse banu , pgsql-admin Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 24 Nov 2021 at 17:08, Holger Jakobs wrote: > > Am 24. 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. > > > >This isn't true. > > > >Async multi-master has performance advantages, but some drawbacks. But > >systems such as BDR3 allow multiple modes of operation that overcome > >these perceived issues. > > > > Are you aware that the original poster asked for open source solutions? Yes, I read that, which is why I didn't reply to the OP. My response was to the statement about "multi-master replication". > Of course, BDR3 is a great tool. -- Simon Riggs http://www.EnterpriseDB.com/