RE: Multi-master replication

BDS Only using the free v1.0... Sent from Yahoo Mail on Android On Sat, 14 Aug 2021 at 2:07, Laura Smith wrote: ‐‐‐ Original Message ‐‐‐ On Friday, August 13th, 2021 at 12:35 PM, Zahir Lalani wrote: > Confidential > > Thx Laura > > So here is the dilemma - everything in the clo

RE: Multi-master replication

‐‐‐ Original Message ‐‐‐ On Friday, August 13th, 2021 at 12:35 PM, Zahir Lalani wrote: > Confidential > > Thx Laura > > So here is the dilemma - everything in the cloud world tends toward > horizontal scaling. We do that with PG using single master and multiple > slaves. But we are wr

Re: Multi-master replication

On Fri, Aug 13, 2021, 5:05 PM Zahir Lalani wrote: > Confidential > > Thx Laura > > So here is the dilemma - everything in the cloud world tends toward > horizontal scaling. We do that with PG using single master and multiple > slaves. But we are write heavy and of course the load on the master is

Re: Multi-master replication

On Fri, Aug 13, 2021 at 11:35:29AM +, Zahir Lalani wrote: > Confidential > > Thx Laura > > So here is the dilemma - everything in the cloud world tends toward > horizontal scaling. We do that with PG using single master and multiple > slaves. But we are write heavy and of course the load on

RE: Multi-master replication

route for write heavy applications. Z > -Original Message- > From: Laura Smith > Sent: 13 August 2021 10:47 > To: Zahir Lalani > Cc: pgsql-general@lists.postgresql.org > Subject: Re: Multi-master replication > > ‐‐‐ Original Message ‐‐‐ > > On Friday

Re: Multi-master replication

‐‐‐ Original Message ‐‐‐ On Friday, August 13th, 2021 at 9:00 AM, Zahir Lalani wrote: > Confidential > > Hello all > > Does anyone on the list have production experience of using PG in a > multi-master setup – if so using which tools? > > Thx > > Zahir I have sometimes considered it

Multi-master replication

Confidential Hello all Does anyone on the list have production experience of using PG in a multi-master setup - if so using which tools? Thx Zahir

Re: Geographical multi-master replication

> When I said “supported version” of BDR, I mostly meant a newer version of Postgres. I know you have to decide on getting support BDR but regardless of what route you take, part of your plan needs to be > 9.4 :). I agree with you. We will be upgrading to the latest postgres version. On Tue, Jan

Re: Geographical multi-master replication

On Mon, Jan 28, 2019 at 3:32 PM Ruben Rubio Rey wrote: > Hi Jeremy, > > > Why don't you consider upgrading from postgres 9.4 and with it to a > supported version of BDR? There is nothing better you can do to keep your > infrastructure up to date, performant, secure, and actually meet your > mult

Re: Geographical multi-master replication

Hi Jeremy, > Why don't you consider upgrading from postgres 9.4 and with it to a supported version of BDR? There is nothing better you can do to keep your infrastructure up to date, performant, secure, and actually meet your multi-master needs than to upgrade to a newer version of postgres which

Re: Sv: Re: Geographical multi-master replication

On Fri., 25 Jan. 2019, 8:40 pm Andreas Kretschmer > > Am 25.01.19 um 10:10 schrieb Andreas Joseph Krogh: > > To my surprise I'm unable to find downloadable BDR3. I thought it was > > an open-source extention to vanilla-pg-11, isn't that the case anymore? > > yeah, you have to sign a support contra

Re: Sv: Re: Geographical multi-master replication

Am 25.01.19 um 10:10 schrieb Andreas Joseph Krogh: To my surprise I'm unable to find downloadable BDR3. I thought it was an open-source extention to vanilla-pg-11, isn't that the case anymore? yeah, you have to sign a support contract. It works as a extension to vanilla-pg-11, but it's not

Sv: Re: Geographical multi-master replication

På fredag 25. januar 2019 kl. 06:45:43, skrev Andreas Kretschmer < andr...@a-kretschmer.de >: Am 25.01.19 um 06:10 schrieb Jeremy Finzel: > >     The problem is that the version for BDR 1.0.7, which has an >     implementation for postgres 9.4, will be on end o

Re: [External] Re: Geographical multi-master replication

I do not know the use case but we did try the following. We had a small requirement wrt some regional data written to tables but needs to be available to all regions. We made use of logical replication to replicate/publish each local table to all the other regions ( like a many to many) In theory,

Re: Geographical multi-master replication

Am 25.01.19 um 06:10 schrieb Jeremy Finzel: The problem is that the version for BDR 1.0.7, which has an implementation for postgres 9.4, will be on end of live at the end of this year. Unfortunately the paid solution is out of our budget, so we currently have two options: find

Re: Geographical multi-master replication

> > The problem is that the version for BDR 1.0.7, which has an implementation > for postgres 9.4, will be on end of live at the end of this year. > Unfortunately the paid solution is out of our budget, so we currently have > two options: find an alternative or remove the multi-region implementatio

Geographical multi-master replication

Hi Everybody, I am currently working with a client that has requirements for geographically dispersed multi-master replication. The current solution that we have in place is the BDR 1.0.7, which is asynchronous and eventually consistent and it is actually very close to real time. So far we are