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
Return on Investment
- Improved integration with Google Cloud, we have set up some automations with Google Workspace, and we have noticed that the raw data sharing between them is very fast as compared to using some other managed database, not sure why.
- Due to some downtime during maintenance, we had to set up a relatively small service which ingested the data while this went down and dumped it when it came back up. So this was a negative impact on our ROI, since now we had to remedy this downtime against the same profit margins
- It was cheaper than the legacy aws service since we needed large database instances
Usability
Alternatives Considered
Amazon Relational Database Service (RDS), DigitalOcean Managed Databases and Azure Database
Other Software Used
IBM Cloud Monitoring, Amazon CloudWatch, AWS Fargate





