Search Postgresql Archives

Re: Difference between UDR and BDR replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 28 January 2016 at 21:16, Kaushal Shriyan <kaushalshriyan@xxxxxxxxx> wrote:


On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer <craig@xxxxxxxxxxxxxxx> wrote:
On 28 January 2016 at 19:16, Kaushal Shriyan <kaushalshriyan@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux