Re: Geographical multi-master replication - Mailing list pgsql-general

From Ruben Rubio Rey
Subject Re: Geographical multi-master replication
Date
Msg-id CABNqb5Y-6fOTLL5yjaDW=jupLFiSyCdQdQJ3L=eMDJUkaa_+Zg@mail.gmail.com
Whole thread Raw
In response to Re: Geographical multi-master replication  (Jeremy Finzel <finzelj@gmail.com>)
Responses Re: Geographical multi-master replication
List pgsql-general
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 does have BDR support.

This is something that we have definitely thought of. That would be a good alternative but I have an strong feeling that the business won't be willing to pay for it. The cost of the paid BDR version, in comparison with the current fixed expenses of the infrastructure, are just too large. That's why we are researching alternatives.


On Fri, Jan 25, 2019 at 4:10 PM Jeremy Finzel <finzelj@gmail.com> wrote:
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 implementation. We are currently looking for alternatives.

You are missing all of the alternatives here.  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 does have BDR support.

Even "stock" postgres 9.4 is set for end of life soon.  Upgrade!

Thanks,
Jeremy

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: number and type of locks for an alter sequence
Next
From: Jeremy Finzel
Date:
Subject: Re: Geographical multi-master replication