MIME-Version: 1.0
References: <MAZPR01MB681598F48E3AE9BC81106AD4FCE62@MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM>
 <CAAPsdhc0jhRqF+kBgFbiGewY9mnVDNR63qr0xefizBre=p3POA@mail.gmail.com>
 <CAKAnmmKX9wV1HTnMNnwQ9bpKZb4863+33r4UC7UD2dLiTAV77Q@mail.gmail.com>
 <Zj1a2_OKjZMS-gTU@momjian.us> <MAZPR01MB6815C3A83150D63752AB013AFCE72@MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM>
 <MAZPR01MB6815114742553C2273A15F82FCE22@MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM>
In-Reply-To: <MAZPR01MB6815114742553C2273A15F82FCE22@MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Mon, 13 May 2024 10:13:54 -0400
Message-ID: <CAKAnmm+ZXJ2TxhWSj9CJ_2MtaSxKqqT5kvEhqvb=X3s7g4KgTg@mail.gmail.com>
Subject: Re: Postgresql active-active nodes in cluster
To: Vidyashree H S <Shreevidya.hs@exaleapsemi.com>
Cc: Bruce Momjian <bruce@momjian.us>, Kashif Zeeshan <kashi.zeeshan@gmail.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000021724d061856812b"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmm%2BZXJ2TxhWSj9CJ_2MtaSxKqqT5kvEhqvb%3DX3s7g4KgTg%40mail.gmail.com>
Precedence: bulk

--00000000000021724d061856812b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, May 13, 2024 at 2:53=E2=80=AFAM Vidyashree H S <
Shreevidya.hs@exaleapsemi.com> 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 t=
o
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

--00000000000021724d061856812b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, May 13, 2024 at 2:53=E2=80=AFAM V=
idyashree H S &lt;<a href=3D"mailto:Shreevidya.hs@exaleapsemi.com">Shreevid=
ya.hs@exaleapsemi.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><b=
lockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-le=
ft:1px solid rgb(204,204,204);padding-left:1ex"><div class=3D"msg1896562591=
895180878"><div dir=3D"ltr">
<ul>
<li style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calib=
ri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Is that multi master replication is not recommended to do ?</div></li></ul>=
</div></div></blockquote><div><br></div><div>No, it is not recommended, as =
it has a very, very narrow use case, and comes with a lot of drawbacks. Sur=
e, you COULD configure your car to also be able to ride across the river li=
ke a boat, but it&#39;s far easier to use a bridge, or a barge. And now you=
r car is harder to care for, and has a lot more ways in which it could brea=
k.</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class=3D"msg=
1896562591895180878"><div dir=3D"ltr"><ul><li style=3D"font-family:Aptos,Ap=
tos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif;font-size=
:12pt;color:rgb(0,0,0)"><span style=3D"font-size:12pt">If we can do, can I =
get any resource for implementing that on PostgreSQL which is open-source?<=
/span></li></ul></div></div></blockquote><div>You still have not told us yo=
ur use case. That can help us to guide you to the right solution. But for t=
otally open source solutions there are not many out there. Here are some:</=
div><div><br></div><div>* <a href=3D"https://github.com/JumpMind/symmetric-=
ds">https://github.com/JumpMind/symmetric-ds</a><br></div><div>*=C2=A0<a hr=
ef=3D"https://github.com/bucardo/bucardo">https://github.com/bucardo/bucard=
o</a></div><div><br></div><div>You can also in theory=C2=A0use logical repl=
ication if at least version 16:</div><div><br></div><div>* <a href=3D"https=
://www.crunchydata.com/blog/active-active-postgres-16">https://www.crunchyd=
ata.com/blog/active-active-postgres-16</a><br></div><div><br></div><div><br=
></div><div>Cheers,</div><div>Greg</div><div><br></div></div></div>

--00000000000021724d061856812b--