CODEWITHSUNDEEP
google-app-enginegoogle-cloud-platformgoogle-cloud-sql
BKSingh
BKSingh

Reputation: 527

max no of allowed concurrent connections of google cloud sql from app engine

I am using 2nd Gen Google Cloud Sql and running an app engine instance on flexible environment. The app engine connects to the cloud sql to run sql queries. I have set up a connection pool to create min of 10 connections and max of 200.

However, I read this - https://cloud.google.com/sql/docs/mysql/diagnose-issues which says - "Each App Engine instance running in a standard environment cannot have more than 12 concurrent connections to a Google Cloud SQL instance." It however says nothing about flexible environment of app engine.

I tried updaing the min connections in my connection pool as 20. On the dashboard I could see 20 Active Connections. Seems the 12 concurrent connection limit is for standard environment. However I could not find any document confirming the same.

Can anyone educate me on the limits of concurrent connections from flexible environment

Upvotes: 0

Views: 5792

Answers (1)

Vadim
Vadim

Reputation: 5126

There are no limits specific to App Engine Flexible. You can create as many connections as the Cloud SQL instance will allow.

The number of maximum number of allowed connections is described here: https://cloud.google.com/sql/faq#sizeqps

Keep in mind that this limit is not an indicator of how many connections your instance can handle for your workload. For example, if you have a heavy workload and you use a n1-standard-1 instance, it's unlikely that you can utilize all 4000 connections.

Upvotes: 1

Related Questions