Re: MultiMaster Replication

Thanks Alvaro. I checked BDR and it looks really good.

But still, to make sure I have done the diligence, is there a true
"opensource" replication solution/tool available from the community?

Also, would appreciate if others can share what do they use for replication
with PostgreSQL and some pros/cons of it.

Regards

On 15 January 2018 at 21:53, Alvaro Aguayo Garcia-Rada <
aaguayo(at)opensysperu(dot)com> wrote:

> 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
>