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'snot yet available publicly(Only 2ndQuadrant support customers). According to 2ndQuadrant, BDR 3.0, which will also
runon 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
BDR3.0 on a standard postgresql, instead of 1.0 with a non-standard postgres. That will probably give you some trouble
whenyou want to upgrade from 9.4 to 9.6(or higher), as the bdr-modified postgres is not binary compatible with the
communityversion. 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@gmail.com>
To: "pgsql-admin" <pgsql-admin@postgresql.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