[pgpool-hackers: 4369] Load balancing after failover not working in 3-node HA PostgreSQL cluster

[Salman Ahmed]

Dear pgpool-hackers,

We’re currently working on pg_cirrus - a simple tool to setup 3-node HA
PostgreSQL clusters using pgpool. We’re facing an issue i.e. load balancing
after failover does not work.

When pg_cirrus sets up 3-node HA cluster within the same subnet, load
balancing works seamlessly as expected i.e. write operations go to primary
node and read operations go to standby nodes, but after primary node goes
down the read and write queries both land on the same newly promoted
primary node.

We’re using the following load balancing properties in pgpool.conf:

backend_weight0 = 0

backend_weight1 = 0.5

backend_weight2 = 0.5

load_balance_mode = on

Is this the expected behavior or are we doing something wrong, kindly guide
us.

To view our source code please go to:
https://github.com/stormatics/pg_cirrus

Thanks!
Salman Ahmed
Stormatics
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20230815/346cdd46/attachment.htm>