a way to script automatically to start and stop the sql database in gcp

Question

i want to run a job in cloud scheduler in gcp to start and stop the sql database in weekdays at working hours.

I have tried by triggering cloud function and using pubsub but i am not getting proper way to do it.

Answer 1

In order to achieve this you can use a Cloud Function to make a call to the Cloud SQL Admin API to start and stop your Cloud SQL instance (you will need 2 Cloud functions). You can see my code on how to use a Cloud Function to start a Cloud SQL instance and stop a Cloud SQL instance

After creating your Cloud Function you can configure the Cloud Scheduler to trigger the http address of each Cloud function

Answer 2

You can use the Cloud SQL Admin API to start or stop and instance. Depending on your language, there are clients available to help you do this. This page contains examples using curl.

Once you've created two Cloud Functions (one to start, and one to stop), you can configure the Cloud Scheduler to send a pub/sub trigger to your function. Check out this tutorial which walks you through the process.