From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Holger Jakobs <holger@jakobs.com>
Cc: pgsql-admin@lists.postgresql.org, Simon Riggs <simon.riggs@enterprisedb.com>
Cc: Firthouse banu <penguinsfairy@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Re:
Date: Wed, 24 Nov 2021 12:38:00 -0500
Message-ID: <7713c1fd-c674-eb79-02ea-0daf749ac098@sqlexec.com> (raw)
In-Reply-To: <0ED6B91F-C228-404F-A4F2-B9532E205B2D@jakobs.com>
References: <CAK_Ha4yABYGEGAMzfNJaxeepeQNFRTFaqYRsns3GCPFeQWEWhQ@mail.gmail.com>
<6cb32d43-75d1-b896-5267-48d75c536808@sqlexec.com>
<CANbhV-G7piJpocze7Hu+NEUb5omzc59PxgyYmX0PSwsSZznvrA@mail.gmail.com>
<0ED6B91F-C228-404F-A4F2-B9532E205B2D@jakobs.com>
Oh really? BDR is acid-compliant? How can it be without a global lock manager to control access to resources and a consistent view of data and enforce isolation levels?
Please explain the magic.
On Wed, 24 Nov 2021 at 14:03, MichaelDBA<MichaelDBA@sqlexec.com> 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.
Holger Jakobs wrote on 11/24/2021 12:08 PM:
> On Wed, 24 Nov 2021 at 14:03, MichaelDBA<MichaelDBA@sqlexec.com> 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.
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: MichaelDBA@sqlexec.com, holger@jakobs.com, simon.riggs@enterprisedb.com, penguinsfairy@gmail.com
Subject: Re: Re:
In-Reply-To: <7713c1fd-c674-eb79-02ea-0daf749ac098@sqlexec.com>
* 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