MIME-Version: 1.0
References: <897B047D-B99D-4637-ACBD-E98EC3D38DD5@leisi.net> <CAKAnmm+VQXYJAFczyo01JZoQcx4CVoM26xyUuVmjbbujR0u=5w@mail.gmail.com>
In-Reply-To: <CAKAnmm+VQXYJAFczyo01JZoQcx4CVoM26xyUuVmjbbujR0u=5w@mail.gmail.com>
From: "sunyucong@gmail.com" <sunyucong@gmail.com>
Date: Mon, 11 Nov 2024 09:46:45 -0500
Message-ID: <CAJygYd1Q0Zf6U8OWVT2ET5E3sg0d3XPbEJaD0jF93d3___UH7A@mail.gmail.com>
Subject: Re: Advice on cluster architecture for two related, but distinct, use cases
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: Matthias Leisi <matthias@leisi.net>, pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001803550626a42c33"
Archived-At: <https://www.postgresql.org/message-id/CAJygYd1Q0Zf6U8OWVT2ET5E3sg0d3XPbEJaD0jF93d3___UH7A%40mail.gmail.com>
Precedence: bulk

--0000000000001803550626a42c33
Content-Type: text/plain; charset="UTF-8"

CC

On Mon, Nov 11, 2024 at 09:28 Greg Sabino Mullane <htamfids@gmail.com>
wrote:

> Some of those requirements are vague, but yes, Patroni should probably be
> the first approach you look at. If the second datacenter is just for
> redundancy, then a simple setup would be:
>
> DCA (data center A):
> Postgres server 1
> Postgres server 2
>
> DCB:
> Postgres server 3 (set no_failover: true)
>
> You will also need a DCS system of some sort (e.g. etcd on all three
> nodes), as well as a backup system (e.g. pgBackRest). Will also need to
> decide how automated you want things to be (for example, cross datacenter
> failover in the above would be manually done). It should definitely be able
> to handle your RPO/RTO requirements easily enough.
>
> [Patroni] However it seems relatively complex to set up and operate
>
>
> Setting things up can be a little complex, yes, but once done it just
> works, so very little operation resources are needed.
>
> We can not assume eg a load balancer.
>
>
> Possible via the application: see
> https://www.postgresql.org/docs/current/libpq-connect.html (esp.
> target_session_attrs)
>
> Cheers,
> Greg
>
>

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

<div>CC</div><div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"=
gmail_attr">On Mon, Nov 11, 2024 at 09:28 Greg Sabino Mullane &lt;<a href=
=3D"mailto:htamfids@gmail.com">htamfids@gmail.com</a>&gt; wrote:<br></div><=
blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
 #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><div>Some o=
f those requirements are vague, but yes, Patroni should probably be the fir=
st approach you look at. If the second datacenter is just for redundancy, t=
hen a simple setup would be:</div><div><br></div><div>DCA (data center A):<=
/div><div>Postgres server 1</div><div>Postgres server 2</div><div><br></div=
><div>DCB:</div><div>Postgres server 3 (set no_failover: true)</div><div><b=
r></div><div>You will also need a DCS system of some sort (e.g. etcd on all=
 three nodes), as well as a backup system (e.g. pgBackRest). Will also need=
 to decide how automated you want things to be (for example, cross datacent=
er failover in the above would be manually done). It should definitely be a=
ble to handle your RPO/RTO requirements easily enough.</div><div><br></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">[Patroni] However it seem=
s relatively complex to set up and operate</blockquote><div><br></div><div>=
Setting things up can be a little complex, yes, but once done it just works=
, so very little operation resources are needed.=C2=A0</div><div><br></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">We can not assume eg a lo=
ad balancer.</blockquote><div><br></div><div>Possible via the application: =
see=C2=A0<a href=3D"https://www.postgresql.org/docs/current/libpq-connect.h=
tml" target=3D"_blank">https://www.postgresql.org/docs/current/libpq-connec=
t.html</a> (esp. target_session_attrs)</div><div><br></div><div>Cheers,</di=
v><div>Greg</div><div><br></div></div>
</div>
</blockquote></div></div>

--0000000000001803550626a42c33--