PostgreSQL HA

Started by venkata786 kover 5 years ago7 messagesgeneral

venkata.k786@gmail.com

over 5 years ago

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

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Ganesh Korde

ganeshakorde@gmail.com

over 5 years ago

In reply to: venkata786 k (#1)

Re: PostgreSQL HA

You can go for BDR from 2nd Quadrant.

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

Show quoted text

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

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#m_-8285752177786612489_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Atul Kumar

akumar14871@gmail.com

over 5 years ago

In reply to: venkata786 k (#1)

Re: PostgreSQL HA

Use xdb, simpler and better

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

Show quoted text

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

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#m_1212501648721883306_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

venkata786 k

venkata.k786@gmail.com

over 5 years ago

In reply to: Ganesh Korde (#2)

Re: PostgreSQL HA

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:

Show quoted text

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

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#m_9193675869156348298_m_-8285752177786612489_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

venkata786 k

venkata.k786@gmail.com

over 5 years ago

In reply to: Ganesh Korde (#2)

Re: PostgreSQL HA

Hi Ganesh,

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

On Sat, 26 Dec 2020 at 16:22, Ganesh Korde <ganeshakorde@gmail.com> wrote:

Show quoted text

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

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#m_9193675869156348298_m_-8285752177786612489_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Jehan-Guillaume de Rorthais

jgdr@dalibo.com

over 5 years ago

In reply to: venkata786 k (#1)

Re: PostgreSQL HA

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?

Andreas Kretschmer

andreas@a-kretschmer.de

over 5 years ago

In reply to: venkata786 k (#4)

Re: PostgreSQL HA

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