Skip to content

Tag: cloud sql

Google Cloud Scheduler to Auto Shutdown Cloud SQL

Recently I started working on GCP, and for one of my POC I wanted cloud SQL. As this was POC I did not want it to run 24×7 and was trying to find a way to auto shutdown at a particular time to save cost. I don’t think there is any in-built option for that. However, GCP cloud scheduler has an option to call http request at a scheduled interval. This is good, as cloud SQL allows to have some management operation done through rest calls.

New I AM Service Account

For Scheduler to successfully run shutdown operation, it needs to be associated with associated with a service account with proper roles. So let’s create a new service account.

  • Navigate to I am and then click on service account. You’re screen might look like this.
  • now let’s put some name and description. I normally put service at the start of the name, but it’s not necessary.
  • After this, we need to associate proper role to this account. For this we are going to choose Clod SQL Admin
  • For this purpose we don’t need to associate any user to this service account.

New Scheduler

  • Navigate to scheduler and click on create job . And fill the name, description, frequency and Timezone.
  • For this choose Target Type as HTTP. Your url should be as mentioned below.
    URL: https://sqladmin.googleapis.com/v1/projects/project-id/instances/instance-id
    Method: Patch
    Auth Header: Add OAuth Token
    Service Account: service-mange-cloud-sql (one we created in above step, if your name is different please choose that)
    Body:
{
  "settings": {
    "activationPolicy": "NEVER"
  }
}
  • In the next step you can configure retry, I am keeping it default for simplicity.
  • one successfully created you should be able to see your job on scheduler home page. Here you can test your job as well.
Leave a Comment