I want to setup a three node cluster for postgresql service with juju on lxd. I have a few questions that need to be understand on my end.
I know there is pgbouncer which is more lightweight than the postgresql service so the first question is do I have to deploy three pgbouncer for each node?
I also want know how I can load balance connections through this cluster with haproxy or any other kind, I have read that postgres does not have active-active cluster so how I can split read-write queries ?
Thank you in advance.