Re: MultiMaster Replication

Hi. You may want to check BDR, which allows bi-directional replication for up to 48 nodes.

https://www.2ndquadrant.com/en/resources/bdr/

You shouldn't experience significant replication delays, unless the connections between your servers are slow. Normally, transactions are replicated once they are committed.

Current version(1) is based on a modified PostgreSQL 9.4; new version(2.0) can run on a standard PostgreSQL 9.6, but it's not yet available publicly(Only 2ndQuadrant support customers). According to 2ndQuadrant, BDR 3.0, which will also run on community PG9.6, will be made available as open source in the next few months, or even earlier. https://blog.2ndquadrant.com/news-and-roadmap-for-bdr-multi-master-postgresql/

So, if you want my suggestion: if you can wait one or two months, I would seriously recommend to do so, so you can get BDR 3.0 on a standard postgresql, instead of 1.0 with a non-standard postgres. That will probably give you some trouble when you want to upgrade from 9.4 to 9.6(or higher), as the bdr-modified postgres is not binary compatible with the community version. Also, BDR 1.0 has still some issues, which may have been solved in BDR 2.0/3.0.

Regards,

Alvaro Aguayo
Operations Manager
Open Comb Systems E.I.R.L.

Office: (+51-1) 3377813 | Mobile: (+51) 995540103 | (+51) 954183248
Web: www.ocs.pe

----- Original Message -----
From: "Purav Chovatia" <puravc(at)gmail(dot)com>
To: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Sent: Monday, 15 January, 2018 10:43:36
Subject: MultiMaster Replication

Hello All,

Can you please share the most commonly used and stable tool/solution used
for multi-master replication. We are ok with a few minutes of data loss.

Many Thanks