Re: Multi master implementation - Mailing list pgsql-admin

From soumitra bhandary
Subject Re: Multi master implementation
Date
Msg-id MA1PR0101MB16873C1F9070F9E1BE39A685E0BF0@MA1PR0101MB1687.INDPRD01.PROD.OUTLOOK.COM
Whole thread Raw
In response to Multi master implementation  (Prince Pathria <prince.pathria@goevive.com>)
Responses Re: Multi master implementation  (Ron <ronljohnsonjr@gmail.com>)
Re: Multi master implementation  (Prince Pathria <prince.pathria@goevive.com>)
Re: Multi master implementation  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-admin
Hi Prince,

BDR is something which is not that much robust as conventional master slave replication. 

Why do you want master node in DR set up ?
Do you want to enable simultaneous write operations at DR site as well?? Normally DR setups remain in cascade replication from one of the stand by node at production side .

Sent from my iPhone

On 19-Dec-2018, at 11:55 PM, Prince Pathria <prince.pathria@goevive.com> wrote:

Hi,

I want to how people are implementing multi master architecture in Postgres. For now, I've come across BDR3 and bucardo for multimaster approach.

Though both doesn't seem to be much promising to me. 

Goal: 2 master and their 3 slaves. [1 master + 2 slaves] in production site and [1 master + 1 slave]
 in DR site. 

Can you guys share how you did it and what issues did you faced?

Thanks in advance!

Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com

pgsql-admin by date:

Previous
From: Kris Deugau
Date:
Subject: Re: install Postgres on RHED 7
Next
From: Ron
Date:
Subject: Re: Multi master implementation