Can I connect to Google Cloud SQL from Google Compute Engine?

Question

I am building a Django site on Google Compute Engine, and I want to install my database in SQL Cloud. It is possible?

What is the most common way to do this? Installing MySQL on virtual machine or use a Cloud SQL instance?

Thank you.

Answer 1

You can use either Google Cloud SQL or manage your own SQL database, depending on your needs.

To use Cloud SQL, you'd want to follow the instructions here: https://developers.google.com/cloud-sql/docs/external

If you want to manage your own SQL database, you can install MySQL or some other database on an instance. Depending on your needs, you can start with a g1-small with a fairly large disk attached and then later use a larger instance type to run your database.

If you're running your own database, you'll need to make sure to take regular backups and copy them off the database machine, to someplace like Google Cloud Storage. If you're using Cloud SQL, you can use the console or the API to schedule database backups.