Great cloud db offering
May 22, 2019

Great cloud db offering

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Google Cloud SQL

Google Cloud SQL (MySQL) is used as the relational data store for our product. The ability to scale up, have read replicas, and have automatic failover built into the offering are really nice features. The automated backup feature is nice as well. To have 7 days of backups available at any time without having to support the processes necessary to make that happen is great.
  • Automatic failover to another region in case the database goes down.
  • Easily scale the instance up if more processing power or memory is required.
  • Automatic backup validation. The backups are performed on a daily basis within the selected window, however, they are not validated. This means the backup could be reported as successful but ultimately be unusable in a situation where it is needed. We got around this issue by periodically validating on our own by spinning up a box, restoring the backup to the new instance, and then destroying the instance after validation. It's not perfect, but is a good sanity check to make sure our backups are valid in case we do need them.
  • It has allowed us to focus on our product/database and not worry about the infrastructure as much. This is a big benefit for a smaller company with limited resources.
The Google Cloud SQL offering fits into our development stack and was a clean replacement for our MySQL database. If we had been using SQL Server instead, then the offering from Azure would have made more sense. I have used both in the past and both work well, with GCP being a little less expensive.
It is great if you don't want to worry about managing hardware and infrastructure and instead focus your efforts on work directly related to your product's database needs, i.e. schema design, efficient queries, etc. However, if you are dealing with very large data sets, then BigQuery, BigTable, or similar might be better suited for your needs.

Google Cloud SQL Feature Ratings

Automatic software patching
Database scalability
Automated backups
Database security provisions
Monitoring and metrics
Automatic host deployment