Hello everyone We run our software in GKE and use PostgreSQL

Question

Hello everyone We run our software in GKE and use PostgreSQL Cloud SQL as database backend We want to use PgBouncer as connection pool middleware implemented as a microservice in GKE Is there any good Pulumi tutorial on how to achieve that Thank you

prehistoric-activity-61023 · Answer

What are you struggling with

prehistoric-activity-61023 · Answer

Do you need some help with managing GKE and CloudSQL from pulumi or you re asking how you can deploy PgBouncer within k8s cluster

some-continent-7311 · Answer

Well the setup I see is this Create a Docker image with PgBouncer in it Deploy it to GKE using Pulumi Change the connection strings to point to PgBouncer instead of Cloud SQL

some-continent-7311 · Answer

What is not clear to me is how to specify the correct connection string from PgBouncer to Cloud SQL The official documentation recommends to connect to Cloud SQL using Cloud SQL Auth proxy and load it as sidecar in the same pod as I assume PgBouncer

some-continent-7311 · Answer

Does it mean that the connection will look like this microservice gt PgBouncer gt Cloud SQL Auth proxy gt Cloud SQL

some-continent-7311 · Answer

In terms of hosts and ports is it going to be something like microservice pgbouncer service 6432 example port gt localhost 5432 gt lt cloud sql connection stringg gt 5432 gt Cloud SQL

some-continent-7311 · Answer

or is there a simpler way to deploy PgBouncer to GKE

prehistoric-activity-61023 · Answer

Did you enable private connection in Cloud SQL

prehistoric-activity-61023 · Answer

It s possible to setup CloudSQL and GKE to communicate over private IP address In that case you can simply get rid of cloud sql proxy

prehistoric-activity-61023 · Answer

but the way you described it seems legit as well That s how I did it back in time when private connections were not available in GCP although without PgBouncer

some-continent-7311 · Answer

If private connection is enabled what should I specify as host in PgBouncer config file in the ` databases ` section

prehistoric-activity-61023 · Answer

IP address of the Cloud SQL instance

some-continent-7311 · Answer

Great thank you

prehistoric-activity-61023 · Answer

you can get this value from `private ip address` output slightly smiling face