Google Cloud SQL is a fully managed service that is ideal for small teams
Use Cases and Deployment Scope
We are using Google Cloud SQL (PostgreSQL) database as the operational store. Together with Django we have developed a multi tenant solution. The database service helps us avoid operational overhead. It enables us to vertically scale the database service as we add more features and the number of application users increases over time.
Pros
- It reduces operational overhead
- It is easy to vertically scale
- It is integrated with Google cloud logging and monitoring for troubleshooting
Cons
- The cost of the service can be reduced so that it is affordable (for startups).
- Developers need to use an Google Cloud SQL auth proxy to connect from their personal machines which is an overhead.
- A third party tool needs to be used to run SQL queries and visualisation of database relationships. There is no tool provided or recommended by Google for developers.
Likelihood to Recommend
Google Cloud SQL is ideal when most of your solution components are using services of the Google Cloud Platform and you are working in a startup or small company where there are no operations engineers and you want to use a fully managed database service so as to avoid operational overhead.