pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMultiMaster Replication
4+ messages / 3 participants
[nested] [flat]
* MultiMaster Replication
@ 2018-01-15 15:43 Purav Chovatia <puravc@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Purav Chovatia @ 2018-01-15 15:43 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: MultiMaster Replication
@ 2018-01-15 16:12 Francis Santiago <santiagocfc@gmail.com>
parent: Purav Chovatia <puravc@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Francis Santiago @ 2018-01-15 16:12 UTC (permalink / raw)
To: Purav Chovatia <puravc@gmail.com>; +Cc: pgsql-admin
It uses* streaming replication* within the Postgres
2018-01-15 12:43 GMT-03:00 Purav Chovatia <puravc@gmail.com>:
> 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
>
--
*Francis del Carmen Santiago Cermeño*
*Ingeniero en Informática *
[image: LinkedIn]
*https://www.linkedin.com/in/sancfc <https://www.linkedin.com/in/sancfc>*
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: MultiMaster Replication
@ 2018-01-15 16:23 Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
parent: Purav Chovatia <puravc@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Alvaro Aguayo Garcia-Rada @ 2018-01-15 16:23 UTC (permalink / raw)
To: Purav Chovatia <puravc@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: MultiMaster Replication
@ 2018-01-21 10:12 Purav Chovatia <puravc@gmail.com>
parent: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
0 siblings, 0 replies; 4+ messages in thread
From: Purav Chovatia @ 2018-01-21 10:12 UTC (permalink / raw)
To: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>; +Cc: pgsql-admin
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@opensysperu.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@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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-01-21 10:12 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-01-15 15:43 MultiMaster Replication Purav Chovatia <puravc@gmail.com>
2018-01-15 16:12 ` Francis Santiago <santiagocfc@gmail.com>
2018-01-15 16:23 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2018-01-21 10:12 ` Purav Chovatia <puravc@gmail.com>
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