Scaling PostgreSQL with Google Cloud and HAProxy

[@MichaelV77777]

nice job, but it would also be helpful if you described how to connect to the primary to do writes while also doing load balancing across the replicas.

[@MuratcanBerber]

HaProxy cannot split read and write queries. You need to use pgpool-ii , JDBC connection string or split read and write in application layer using multiple ports in HaProxy. For example, create multiple frontends and backends in HaProxy: ports 3000 for Writes and 4000-40001-4002.. ports for Reads. You cannot scale writes unless you have a multi-admin setup. You can use hosts file instead of ip addresses and ports to use ailaises. It is convenient to only change ip addresses when failover occurs so that there is no need to change the alias.

[@RicardoJosue]

hi, how are this with Azure? grettings from México