Step by step guide to deploy on Google Cloud with Cloud SQL

[pip8786]

Is your feature request related to a problem? Please describe.

I haven't worked with terraform before. However, I'd like to set up PGBouncer in front of my Google Cloud SQL database since it's used by many different Cloud Functions and a Vercel/NextJS web app (which is also a serverless solution). I've been running out of connections on my database recently and started looking for solutions and this seems to be the recommended one. Note that I'm using Prisma to connect to the database, but I don't think that affects this request.

Describe the solution you'd like

I think a step by step guide on how to set this up on Google Cloud infrastructure would be really helpful in getting someone like me going.

Describe alternatives you've considered

Alternatively, I could try to infer how to set it up from the existing documentation and finding information on how to use terraform with Google.

[andreyluchianic]

@pip8786 almost same infrastructure in my case Next, Vercel, Cloud Run but i know terraform so if @christippett can help me setup it i can write step by step docs

[pip8786]

@andreyluchianic That sounds great. I'd think all you'd have to do is fork this repository and add a *.md file in a pull request. I guess the other issue is this repository is pretty old now and I had to make a lot of updates to it to get it to even run: https://github.com/social-cascade/terraform-google-cloud-sql-pgbouncer. I'm not sure that it's maintained anymore so starting a fresh fork and just working on that may be best?

[andreyluchianic]

actually @pip8786 i got this working with example default configuration,
the only problem was #7 and i was able to connect to my database trough pgbouncer

not used admin account tho
db is old - PostgreSQL 11.16

[andreyluchianic]

i have 10 databases for each CMS,
looks promising