Re: Load balancing of write queries among health-checked nodes

2024-10-07 Thread me+postgres
Among PostgreSQL instances there is only one master. But yes, each server may be considered master by the clients because it's Pgpool-II will redirect write queries to the actual master. Maybe it's even better to avoid this unnecessary traffic between servers and decide which Pgpool-II is in fro

Load balancing of write queries among health-checked nodes

2024-10-07 Thread me+postgres
Hello. 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 send queries to. DNS round-robin is not a solution because it can't distinguish between healthy and dead nodes. I thought about having a Pgpool-II i