Re: Bi-Directional replication client awareness - Mailing list pgsql-general

From Andres Freund
Subject Re: Bi-Directional replication client awareness
Date
Msg-id 20140712114536.GB3494@awork2.anarazel.de
Whole thread Raw
In response to Bi-Directional replication client awareness  (Martin Gudmundsson <martingudmundsson@gmail.com>)
Responses Re: Bi-Directional replication client awareness  (Martin Gudmundsson <martingudmundsson@gmail.com>)
List pgsql-general
On 2014-07-12 13:23:08 +0200, Martin Gudmundsson wrote:
>
> 12 jul 2014 kl. 12:33 skrev Andres Freund <andres@2ndquadrant.com>:
>
> > On 2014-07-12 18:22:30 +0800, Craig Ringer wrote:
> >> On 07/12/2014 02:24 PM, Martin Gudmundsson wrote:
> >>> Any ideas giving BDR an option to be synchronous. I mean in ”close quarters” with low latency it should work ok.
> >>
> >> BDR doesn't do synchronous replication _yet_, but it's on the roadmap.
> >
> > Just to clarify: There's two things that sometimes are referred to as
> > 'synchronous' in the context of multimaster replication.
> >
> > Just like with HS' builtin synchronous replication it can mean that the
> > client doesn't get a reply until the COMMIT has safely been replicated
> > to other systems. That's supported by BDR today.
>
> Would that be to a streaming replication synchronous standby? I.e replicated to a read only node?

It's possible to do it to a streaming replication sync standby, but also
to another BDR node. The logical decoding facility added in 9.4 allows
logical replication solutions to use the same mechanism as streaming rep
does.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: Bi-Directional replication client awareness
Next
From: Michael Paquier
Date:
Subject: Re: Bi-Directional replication client awareness