From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Difference between UDR and BDR replication |
Date: | 2016-01-28 13:21:44 |
Message-ID: | CAMsr+YFcnFuaZB691O76kzhxT=vaPDxiTnYO-ZSLPqxY6uuang@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 28 January 2016 at 21:16, Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com>
wrote:
>
>
> On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer <craig(at)2ndquadrant(dot)com>
> wrote:
>
>> On 28 January 2016 at 19:16, Kaushal Shriyan <kaushalshriyan(at)gmail(dot)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
>>
>
> Hi Craig,
>
> Thanks for the explanation. Does it mean UDR is Master to Slave
> replication?
>
>
Correct. Please use either PostgreSQL's built-in streaming replication
features or pglogical instead, though. If you're not sure which, use the
built-in replication features.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Bala Venkat | 2016-01-28 14:22:10 | Replication Question |
Previous Message | Kaushal Shriyan | 2016-01-28 13:16:44 | Re: Difference between UDR and BDR replication |