Search code examples
google-app-enginegoogle-cloud-sql

gae cloud sql active connections not closing (keeping the instance running)

I stopped all the instance Running in my app but still Cloud SQL have a one Active connection, I have no idea why.. is that keeping the Cloud Sql Instance running.. and I'm getting charged for the hours it used.. please help

Solution

  • There are a few places that a flag could be set to keep the Cloud SQL instance alive.

    1. Go to the Dev Console Your Project -> Cloud SQL -> SQL Instance -> Edit -> "Show advanced options..." -> ACTIVATION POLICY make sure its set to "On Demand".

    if you are still seeing it up then:

    1. Go here and fill out the information. Under fields select only 'settings' click execute and scroll down. Look for 'activationPolicy' and see whats set to. You can use the API browser to change the setting or gcloud