Re: Difference between UDR and BDR replication

On 28 Jan 2016 6:51 pm, "Craig Ringer" <craig(at)2ndquadrant(dot)com> wrote:
>
> 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

Hi Craig,

Thanks a lot for all the help and really appreciated. I am still reading
and will ask here if I have any questions.

Regards,

Kaushal