Re: Postgres - Replication

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(at)yahoo(dot)co(dot)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(at)opensysperu(dot)com> wrote:
>
>
> I have some experience with BDR. Works fine.
>
> Alvaro Aguayo
> Jefe de Operaciones
> Open Comb Systems E.I.R.L.
>
> Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51) 954183248
> Website: www.ocs.pe
>
> ----- Original Message -----
> From: "bricklen" <bricklen(at)gmail(dot)com>
> To: "jasoninmel" <jasoninmel+1(at)gmail(dot)com>
> Cc: pgsql-admin(at)postgresql(dot)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(at)gmail(dot)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/
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
>