Great cloud db offering
Updated March 06, 2024
Great cloud db offering
Score 9 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.
Pros
- Automatic failover to another region in case the database goes down.
- Easily scale the instance up if more processing power or memory is required.
Cons
- 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.
Comments
Please log in to join the conversation