From: | Om Prakash Jaiswal <op12om(at)yahoo(dot)co(dot)in> |
---|---|
To: | Alvaro Aguayo Garcia-Rada <aaguayo(at)opensysperu(dot)com>, bricklen <bricklen(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, jasoninmel <jasoninmel+1(at)gmail(dot)com> |
Subject: | Re: Postgres - Replication |
Date: | 2017-03-21 08:07:55 |
Message-ID: | 1636173168.4735929.1490083675424@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
RegardsOm 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Michael@sqlexec.com | 2017-03-21 11:07:54 | Re: Postgres - Replication |
Previous Message | jasoninmel | 2017-03-21 03:36:29 | Re: Postgres - Replication |