public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: Vidyashree H S <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: Kashif Zeeshan <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Postgresql active-active nodes in cluster
Date: Mon, 13 May 2024 10:13:54 -0400
Message-ID: <CAKAnmm+ZXJ2TxhWSj9CJ_2MtaSxKqqT5kvEhqvb=X3s7g4KgTg@mail.gmail.com> (raw)
In-Reply-To: <MAZPR01MB6815114742553C2273A15F82FCE22@MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM>
References: <MAZPR01MB681598F48E3AE9BC81106AD4FCE62@MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM>
<CAAPsdhc0jhRqF+kBgFbiGewY9mnVDNR63qr0xefizBre=p3POA@mail.gmail.com>
<CAKAnmmKX9wV1HTnMNnwQ9bpKZb4863+33r4UC7UD2dLiTAV77Q@mail.gmail.com>
<[email protected]>
<MAZPR01MB6815C3A83150D63752AB013AFCE72@MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM>
<MAZPR01MB6815114742553C2273A15F82FCE22@MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM>
On Mon, May 13, 2024 at 2:53 AM Vidyashree H S <
[email protected]> wrote:
>
> - Is that multi master replication is not recommended to do ?
>
>
No, it is not recommended, as it has a very, very narrow use case, and
comes with a lot of drawbacks. Sure, you COULD configure your car to also
be able to ride across the river like a boat, but it's far easier to use a
bridge, or a barge. And now your car is harder to care for, and has a lot
more ways in which it could break.
>
> - If we can do, can I get any resource for implementing that on
> PostgreSQL which is open-source?
>
> You still have not told us your use case. That can help us to guide you to
the right solution. But for totally open source solutions there are not
many out there. Here are some:
* https://github.com/JumpMind/symmetric-ds
* https://github.com/bucardo/bucardo
You can also in theory use logical replication if at least version 16:
* https://www.crunchydata.com/blog/active-active-postgres-16
Cheers,
Greg
view thread (7+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Postgresql active-active nodes in cluster
In-Reply-To: <CAKAnmm+ZXJ2TxhWSj9CJ_2MtaSxKqqT5kvEhqvb=X3s7g4KgTg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox