Обсуждение: PostgreSQL HA

Поиск
Список
Период
Сортировка

PostgreSQL HA

От
venkata786 k
Дата:
Hi Team,

Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions.
My Team is thinking about implementing active-active replacing master-slave.

Regards,
Venkat





Virus-free. www.avast.com

Re: PostgreSQL HA

От
Ganesh Korde
Дата:
You can go for BDR from 2nd Quadrant.

On Sat, 26 Dec 2020, 4:17 pm venkata786 k, <venkata.k786@gmail.com> wrote:
Hi Team,

Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions.
My Team is thinking about implementing active-active replacing master-slave.

Regards,
Venkat





Virus-free. www.avast.com

Re: PostgreSQL HA

От
Atul Kumar
Дата:
Use xdb, simpler and better

On Saturday, December 26, 2020, venkata786 k <venkata.k786@gmail.com> wrote:
Hi Team,

Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions.
My Team is thinking about implementing active-active replacing master-slave.

Regards,
Venkat





Virus-free. www.avast.com

Re: PostgreSQL HA

От
venkata786 k
Дата:
Hi Ganesh,

BDR supports postgres 12 & 13 versions ??
I think we have BDR compatible for 9.4 postgres.
Could you plz confirm.


On Sat, 26 Dec 2020 at 16:22, Ganesh Korde <ganeshakorde@gmail.com> wrote:
You can go for BDR from 2nd Quadrant.

On Sat, 26 Dec 2020, 4:17 pm venkata786 k, <venkata.k786@gmail.com> wrote:
Hi Team,

Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions.
My Team is thinking about implementing active-active replacing master-slave.

Regards,
Venkat





Virus-free. www.avast.com

Re: PostgreSQL HA

От
venkata786 k
Дата:
Hi Ganesh,

I saw symmetric DS in Google.
Are there any disadvantages with symmetric DS?



Virus-free. www.avast.com

On Sat, 26 Dec 2020 at 16:22, Ganesh Korde <ganeshakorde@gmail.com> wrote:
You can go for BDR from 2nd Quadrant.

On Sat, 26 Dec 2020, 4:17 pm venkata786 k, <venkata.k786@gmail.com> wrote:
Hi Team,

Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions.
My Team is thinking about implementing active-active replacing master-slave.

Regards,
Venkat





Virus-free. www.avast.com

Re: PostgreSQL HA

От
Jehan-Guillaume de Rorthais
Дата:
On Sat, 26 Dec 2020 05:51:22 +0530
venkata786 k <venkata.k786@gmail.com> wrote:

> Hi Team,
> 
> Could you please share postgresql's best active(R/W)-active(R/W) (multi
> master replication) solutions.
> My Team is thinking about implementing active-active replacing master-slave.

Symmetric replication bring a lot of complexity in various layers:
application, architecture, backups.

Why do you need symmetric replication? Do you have any issues with asymmetric
replication?

Re: PostgreSQL HA

От
Andreas Kretschmer
Дата:

Am 26.12.20 um 17:20 schrieb venkata786 k:
> Hi Ganesh,
>
> BDR supports postgres 12 & 13 versions ??
> I think we have BDR compatible for 9.4 postgres.
> Could you plz confirm.

That's true. PG 9.4 is out of support.



Regards, Andreas

-- 
2ndQuadrant, an EDB company
www.2ndQuadrant.com / www.enterprisedb.com