Of databases and clouds
Use Cases and Deployment Scope
The web/infra team uses Google Cloud SQL as a managed MySQL database for most of our staging/testing environments. We have an array of internal tools that depend on a MySQL database. It addresses our need to store relational data for the tools and services that we build around our product(s)
Pros
- Easy to set up
- Provides a good web interface to monitor resource consumption
- Has built in backups and replication support
Cons
- Connection options. Currently, only connections via sockets are supported if using with CloudRun
- Connection drops during maintenance
- Costs escalate quickly when usage grows
Likelihood to Recommend
It is well suited if already working in a Google Cloud environment with multiple other Google Cloud services. For example, when setting up a cloud run application, it has a build in connector to Cloud SQL if the application requires one. It isn't well suited in a multi cloud or hybrid cloud environment