I used Google Cloud SQL in my previous organization to be database of apps that we developed such as safety management system in mining, workflow management system developed in-house, supplier management system, microservices for various apps in subsidiary company e.g. insurtech, crypto, media, fintech, and many others. At that time, I found no issue using Google Cloud SQL.
Pros
Autoscaling storage
Ease of use to scale up vertically when needed
High availability database
Cons
If storage that has been auto-scaled, it would be great if it can be shrunk to reduced cost
Auto sizing in Google Cloud SQL without downtime
Likelihood to Recommend
It is suited for application that requires relational database where relationship between table must be strict and database has to support join and transaction e.g. if a DML statement fails within a transaction the previously successful statement must be rolled-back, like finance app, supply chain, transaction app, etc.
It is not suited for application where data definition can't be defined in advance like NoSQL. And also not suited to contain cache for apps and receiving big amount of data (e.g. sensor) in short time.
VU
Verified User
Manager in Information Technology (Mining & Metals company, 1001-5000 employees)
