Item: Google Cloud SQL
Rating: 8
Author: Verified User

Use Cases and Deployment Scope

We used postage SQL to host our relational data of product catalog. Initially we had custom PostgreSQL hosted on AWS but due to costing, scalability and overhead of managing the underlying infrastructure we decided to move to some cloud hosted fully managed database. After evaluation we decided to choose GCP (Google Cloud Platform) and we have GCP hosted PostgreSQL.

Pros and Cons

Fully managed database service
Supports multiple database engines like PostgreSQL, MySql
Cost effective
Easy monitoring

GCP User interface needs to be improved. AWS has better and consistent user interface.
Documentation need to be improved for all the services and include limitations.
Advance monitoring should be made available along with features like cloud watch from AWS

Return on Investment

No need to manage underlying infrastructure due to fully managed database service
Scalability on demand
Easy to monitor
Easy to take back-ups

Usability

On demand scalability helps us provision extra resources as per our requirement and load on the application. Reduced cost due to fully managed services and no need to manage underlying infrastructure which reduced time of patching and maintaining underlying infrastructure. Easy to configure as per application requirements. Supports monitoring which is not available in custom hosted database instance on own computing infrastructure

Ease of Integration

Google Cloud SQL database API makes it easier to integrate and use database services in any application with any programming language. it works well with existing widely available JPA and GCP has well maintained library which we can directly use to integrate Google Cloud SQL in our application with existing build tools like maven and gradle

Alternatives Considered

Amazon Relational Database Service (RDS) and Azure SQL Database

We were already using other few services from GCP for computing and hosting because which Google Cloud SQL was our first choice. We compared pricing of other cloud database service providers like AWS RDS and Microsoft SQL database but we found Google Cloud SQL database service pricing little more worthy as per application requirements.

Key Insights

Do you think Google Cloud SQL delivers good value for the price?

Yes

Are you happy with Google Cloud SQL's feature set?

Yes

Did Google Cloud SQL live up to sales and marketing promises?

Yes

Did implementation of Google Cloud SQL go as expected?

Yes

Would you buy Google Cloud SQL again?

Yes

Other Software Used

Firebase

Likelihood to Recommend

Fully managed services with support for multiple database engines like PostgreSQL, MySql

Google Cloud SQL - Good Alternative to On Premise and Custom Database Hosting on Cloud

Overall Satisfaction with Google Cloud SQL