From: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
To: Purav Chovatia <puravc@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: MultiMaster Replication
Date: Mon, 15 Jan 2018 11:23:30 -0500 (PET)
Message-ID: <89259046.277375.1516033409999.JavaMail.zimbra@opensysperu.com> (raw)
In-Reply-To: <CADrzpjEg=U8zv-J3y4xKBzPEv4wX82PtMnsDyYnjTzsZG_7f3Q@mail.gmail.com>
References: <CADrzpjEg=U8zv-J3y4xKBzPEv4wX82PtMnsDyYnjTzsZG_7f3Q@mail.gmail.com>
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@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aaguayo@opensysperu.com, puravc@gmail.com
Subject: Re: MultiMaster Replication
In-Reply-To: <89259046.277375.1516033409999.JavaMail.zimbra@opensysperu.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox