Date: Tue, 08 Oct 2024 07:03:57 +0400
From: me+postgres@kotovalexarian.com
To: pgsql-general@lists.postgresql.org
Subject: Load balancing of write queries among health-checked nodes
User-Agent: K-9 Mail for Android
Message-ID: <E72E2BA7-85BF-4446-B9D8-08F462CB392D@kotovalexarian.com>
MIME-Version: 1.0
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/E72E2BA7-85BF-4446-B9D8-08F462CB392D%40kotovalexarian.com>
Precedence: bulk

Hello=2E I have a PostgreSQL high availability cluster with Pgpool-II, but =
I don't use the virtual IP feature so my clients don't know which node to s=
end queries to=2E DNS round-robin is not a solution because it can't distin=
guish between healthy and dead nodes=2E

I thought about having a Pgpool-II instance on each client (client Pgpool-=
II -> cluster Pgpool-II -> PostgreSQL), but AFAIK it can't distribute write=
 queries=2E I also know that libpq may have multiple nodes to connect, but =
I need an advanced health check because a node may have connectivity but be=
 separated from the whole cluster so it must be considered dead=2E

Is there any solution?