Re: Re: - Mailing list pgsql-admin

From MichaelDBA
Subject Re: Re:
Date
Msg-id 7713c1fd-c674-eb79-02ea-0daf749ac098@sqlexec.com
Whole thread Raw
In response to Re:  (Holger Jakobs <holger@jakobs.com>)
Responses Re: Re:  (Simon Riggs <simon.riggs@enterprisedb.com>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: MichaelDBA
Date:
Subject: Re: Re:
Next
From: Simon Riggs
Date:
Subject: Re: Re: