Postgres Pro
Downloads
Home   >   mailing lists

Re: Difference between UDR and BDR replication - Mailing list pgsql-general

From Craig Ringer
Subject Re: Difference between UDR and BDR replication
Date
Msg-id CAMsr+YE2e_3bjLhfyoke0Scz5Lj4CWwL9Ggg4JnicsHbskxSCA@mail.gmail.com
Whole thread Raw
In response to Difference between UDR and BDR replication  (Kaushal Shriyan <kaushalshriyan@gmail.com>)
Responses Re: Difference between UDR and BDR replication
List pgsql-general
Tree view
On 28 January 2016 at 19:16, Kaushal Shriyan <kaushalshriyan@gmail.com> wrote:
Hi,

Can somebody please help me understand the difference between UDR and BDR with examples?


BDR is for multiple masters that all replicate to each other.

UDR takes data from one server and copies it to another. One way. (By the way, I strongly advise you to now use pglogical instead of UDR).

BDR:

  A <==> B

UDR/pglogical:

  A ==> B


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

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Request - repeat value of \pset title during \watch interations
Next
From: Kaushal Shriyan
Date:
Subject: Re: Difference between UDR and BDR replication