Difference between UDR and BDR replication
Hi,
Can somebody please help me understand the difference between UDR and BDR
with examples?
Thanks in Advance.
Regards,
Kaushal
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
On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer <craig@2ndquadrant.com> wrote:
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
Hi Craig,
Thanks for the explanation. Does it mean UDR is Master to Slave
replication?
Regards,
Kaushal
On 28 January 2016 at 21:16, Kaushal Shriyan <kaushalshriyan@gmail.com>
wrote:
On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer <craig@2ndquadrant.com>
wrote: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
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
On 28 Jan 2016 6:51 pm, "Craig Ringer" <craig@2ndquadrant.com> wrote:
On 28 January 2016 at 21:16, Kaushal Shriyan <kaushalshriyan@gmail.com>
wrote:
On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer <craig@2ndquadrant.com>
wrote:
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
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