Second to none
April 10, 2019
Second to none
Score 9 out of 10
Overall Satisfaction with Google Cloud SQL
Google Cloud SQL is a managed SQL database service for MySQL and PostgreSQL. Since we use MySQL for some of our products, we moved our SQL tables schema and data from VMs to a Google Cloud SQL MySQL instance. This has helped us with simple backups/restorations, upgrades/downgrades, fine-tuning settings, and uptime. This also meant that if we had our MySQL running on a VM alongside other services and someone accidentally restarted/deleted the VM, then there's no need to worry about such situations if we are using the GCP's SQL.
- Google Cloud SQL has reduced our operational costs by not having to manage our own instance of the MySQL server.
- Since code and SQL instance are now decoupled, it was possible to scale where we had to.
Google Cloud SQL has competitors from Amazon Web Services and Microsoft Azure, where everyone is providing managed SQL servers. Google Cloud SQL is better because it has all the tooling that one will need for their data. At each step, it's possible for the data to transform, store, and provide actionables for the business.
Google Cloud SQL provides the two most popular open source SQL servers, does everything right, and can be used for most use cases. It can be used for most business applications and at any scale, as Google Cloud SQL can scale very well based on the application needs. It's less appropriate for applications that use a DB other than MySQL and PostgreSQL, and for apps that don't need data persistence.