Re: Multi master implementation - Mailing 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