TrustRadius: an HG Insights company

Google Cloud SQL

Score8.9 out of 10

81 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

Screenshot of 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.
Screenshot of 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

Screenshot of 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.

Top Performing Features

  • Automated backups

    Automated backup enabling point-in-time data recovery

    Category average: 8.3

  • Automatic software patching

    Patches applied to database automatically

    Category average: 8.7

  • Database scalability

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

    Category average: 9

Areas for Improvement

  • Database security provisions

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

    Category average: 8.8

  • Automatic host deployment

    Compute instance replacement in the event of hardware failure

    Category average: 7.4

  • Monitoring and metrics

    Built-in monitoring of multiple operational metrics

    Category average: 6.7

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

Effortless Database Management with Google Cloud SQL

Use Cases and Deployment Scope

Basically I use Cloud SQL comes with the capabilities such as cloud storage, strong backend and fast quires compilation features that's make it a best and suitable tool. It has helped us automate a lot of our reporting processes and has helped us optimize our team effectively.

Pros

  • Automation of tasks
  • It has a easily and user understandable interface which provides it every necessary feature to come up with.
  • Monitoring tools

Cons

  • Defragmentation tools
  • The data integration feature can be done for different erp system.
  • more information on how to use the product

Return on Investment

  • No costs associated with Server resources
  • Saved us multiple hours per work on automation of tasks
  • Great monitoring allows us visibility to optimize database

Usability

Alternatives Considered

Amazon Relational Database Service (RDS) and Azure SQL Database

Other Software Used

Amazon Relational Database Service (RDS), Docker

Good offering for cloud deployed sidecar.

Use Cases and Deployment Scope

For certain aspects of the BI Landscape, we required the data to be hosted in the cloud rather than on-premises. Architecture. - A sidecar database is deployed in Google Cloud SQL as a supplement to the main on-premise data warehouse. - Data is replicated from on-prem systems and sensor data - Cloud SQL acts as a read-optimized layer for BI tools and sharing to other cloud services.

Pros

  • Performance scaling during peak use.
  • Operational Simplicity.
  • Avoids licensing costs of expensive middleware to expose on-premise systems to external cloud services.

Cons

  • More customer control wrt. backup schedule and retention.
  • More granular segmentation for workload limits depending on which pipeline accesses the data to avoid costly errors or misuse.
  • Enhanced remote API for stored procedures, enabling initiation from on-premise databases to streamline orchestration and monitoring.

Return on Investment

  • Rapid Prototyping and Development.
  • It was easy to integrate outside once the internal replications were set up.
  • Scalability to fit with changing demand.

Usability

Alternatives Considered

MySQL and SAP BW/4HANA

Other Software Used

SAP Datasphere, Microsoft Power BI, SAP Business Warehouse

An excellent tool for some specific scenarios.

Use Cases and Deployment Scope

Our clients need a database solution for their e-commerce tools. They usually used a dedicated virtual machine with a traditional DBMS, but this would cost too much to maintain. Using a cloud solution like Google Cloud SQL would be a better solution in this case, avoiding unnecessary infrastructure maintenance costs.

Pros

  • Very stable.
  • Very secure.
  • Easy to use.

Cons

  • Cost can get high really quickly.
  • Log access could be better.
  • Sharing access with team member not so easy.

Return on Investment

  • Reduced in at least 50% the time required to maintain the databases.
  • Reduced complexity of backups.
  • Reduced total cost of operation for not-database intensive applications.

Usability

Other Software Used

Amazon Relational Database Service (RDS), Google Maps API, MobaXTerm, Termius