BDR works fine for writeloads that are geographically separate. True multi-master is ACID compliant when you have a global transaction manager like Postgres-xc or Postgres-xl.
Regards
Sent from my iPad
On Mar 21, 2017, at 4:07 AM, Om Prakash Jaiswal <op12om@yahoo.co.in> wrote:
I am using Bucardo.
It is working fine. It has been runinning for 5 years across 50 replicated nodes.
I strongly recommend Bucardo for master-master replication.
It is trigger based asynchronous replication system.
Regards
Om Prakash
On Saturday, 18 March 2017 10:24 PM, Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com> wrote:
I have some experience with BDR. Works fine.
Alvaro Aguayo Jefe de Operaciones Open Comb Systems E.I.R.L.
----- Original Message ----- From: "bricklen" <bricklen@gmail.com> To: "jasoninmel" <jasoninmel+1@gmail.com> Cc: pgsql-admin@postgresql.org Sent: Saturday, 18 March, 2017 11:41:48 AM Subject: Re: [ADMIN] Postgres - Replication
On Thu, Mar 16, 2017 at 8:34 PM, jasoninmel < jasoninmel+1@gmail.com > wrote:
Please note that I'm open for any other replication method that would allow better scalability. One of the best option would be to have Multi-master setup though I haven't seen any documentation around the support for such capability by Postgres.
Postgresql doesn't support multi-master in the core project but there are options available. Have you come across BiDirectional Replication (BDR) yet? https://2ndquadrant.com/en/resources/bdr/
