TrustRadius: an HG Insights company

Google Cloud SQL

Score8.7 out of 10

96 Reviews and Ratings

What is Google Cloud SQL?

Google Cloud SQL is a database-as-a-service (DBaaS) with the capability and functionality of MySQL.

Media

migrating to a fully managed database solution - Self-managing a database, such as MySQL, PostgreSQL, or SQL Server, can be inefficient and expensive, with significant effort around patching, hardware maintenance, backups, and tuning. Migrating to a fully managed solution can be done using a Database Migration Service with minimal downtime.
data-driven application development - Cloud SQL accelerates application development via integration with the larger ecosystem of Google Cloud services, Google partners, and the open source community.

1 / 2

Top Performing Features

  • Automatic software patching

    Patches applied to database automatically

    Category average: 8.3

  • Automatic host deployment

    Compute instance replacement in the event of hardware failure

    Category average: 6.8

  • Monitoring and metrics

    Built-in monitoring of multiple operational metrics

    Category average: 6.8

Areas for Improvement

  • Automated backups

    Automated backup enabling point-in-time data recovery

    Category average: 8

  • Database scalability

    Ease of scaling compute or memory resources and storage up or down

    Category average: 9.2

  • Database security provisions

    Provision for database encryption, network isolation, and identity access management

    Category average: 8.8

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

Google Cloud SQL is Solid DBaaS

Use Cases and Deployment Scope

We use Google Cloud SQL for relational database usage. For storing the user information, and several logical relations on the user entity like grouping of user. We use it only for storing the data, and it already covers the maintenance, so storing and retrieving data is our only use cases

Pros

  • Uptime
  • Less latency
  • Easy to maintain

Cons

  • Better UI
  • Easier way of connecting to it for debugging

Return on Investment

  • Backups are really good
  • Uptime is good
  • Scalability is good

Usability

Alternatives Considered

Google BigQuery, Google Cloud Pub/Sub, Google Compute Engine and Google Cloud Run

Other Software Used

Cursor, Anthropic Claude, OpenAI API Platform, Apache Airflow, Slack, Microsoft Visual Studio Code

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.

Return on Investment

  • Easy to scale the database service
  • Reduces operational overhead and costs
  • Easy to troubleshoot due to integration with Google cloud logging and monitoring

Usability

Alternatives Considered

DigitalOcean Managed Databases

Other Software Used

DBeaver, Google BigQuery, Google Cloud Pub/Sub, Google Compute Engine

One of the bests Cloud Database solutions in the market

Use Cases and Deployment Scope

Our product, [...], which a powerful marketing intelligence tool designed specifically for automotive dealerships, runs on Google Cloud. We're leveraging instance-based services, such as Compute Engine, Google Cloud SQL, Cloud Memory, as well as netsec services, such as Load Balancer and Firewalls. We're getting a robust and centralized solution, that provides us with comprehensive metrics on the consumption for each resource as well as monitoring tools to proactively keep our infrastructure up and running.

Pros

  • High-availability
  • Dynamic resource allocation
  • Serverless
  • Monitoring tools

Cons

  • Access through VPN
  • Defragmentation tools
  • Automatic version upgrade

Return on Investment

  • No costs associated with DBA resources
  • No costs associated with Server resources
  • Business continuity guaranteed due to dynamic resource allocation

Usability

Alternatives Considered

Rackspace Managed Hosting

Other Software Used

Google Compute Engine, Bitbucket, Docker

Google Cloud SQL - your analytics partner

Use Cases and Deployment Scope

Basically I use Google Cloud SQL for test my queries and check whether it's not performing well or takes time. Because Google Cloud SQL comes with the capabilities such as cloud storage, strong backend and fast quieres compilation features that's make it a best and suitable tool. If I talk about my use cases then I will majorly work it on to test my quieres, create tables, make connection with my other tools and erp system to fullfill my database management requirements. Generally when I didn't have Google Cloud SQL then I have to run my test cases on local server but after this I can easily do my work.

Pros

  • It has a easily and user understandable interface which provides it every necessary feature to come up with.
  • It's backend is very strong that can help us to run big quieres without any hesitation.
  • It's integration with other tools are one of the powerful feature which makes it more suitable to use.

Cons

  • So first all, it need to works more on the security feature.
  • The table accessible part is a bit confusing so, it can be optimize.
  • The data integration feature can be done for different erp system.

Return on Investment

  • The first one is it's performance is very good and it comes up with different solution.
  • Security can be improved for external resources or the schemas which are selected in it.
  • It can be more fragile so one can use it in the business purposes and this will make it a great product.

Usability

Alternatives Considered

Azure SQL Database and Azure Databricks

Other Software Used

Azure SQL Database, Apache Spark, Azure Databricks