Google Cloud SQL Reviews

31 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-7 of 7)

Cameron Gable profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
We migrated from using on-prem SQL databases to Google's managed MySQL database, CloudSQL, a few years back. It supports all of our relational database needs. Along with other Google-managed data structures, Cloud SQL plays an integral role for our software team and our R&D teams, as it is used as the primary storage for company-wide analysis.
  • It is fully managed, so it gives the user a hands-off approach to relational storage.
  • It has well-built APIs, so it is easy to access in a multitude of ways.
  • It is reasonably easy to use with the Google Cloud Console, so users can access it using a user interface.
  • There is some functionality you cannot do from the console, including, granting and restricting user privileges, among other database management capabilities.
  • It is not trivial to connect to spun up VMS. Currently, we use the Cloud SQL proxy to do so.
Overall, Cloud SQL serves all of the needs we need it to. It can do everything a relational database can do, plus it is completely managed so you don't have to worry about the size of the VM, partitioning, etc.
Read Cameron Gable's full review
Leonel Quinteros profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Google Cloud SQL with MySQL instances as our primary data storage for all our applications. Performance is great and configuring secure environments is straightforward. We reduced our DB maintenance tasks by 75% and our systems are running better than ever. Automatic backup policies and high availability replication are 1 click away.
  • Configuring a high availability cluster of MySQL or PostgreSQL databases is as easy as choosing how many instances do you want to have. Read-only replicas of the master DB can also be used for read operations relying on the "almost instant" replication mechanisms available.
  • Plays really well with other Google Cloud products, so interoperation with Cloud Functions, Cloud Run, Compute Engine, AppEngine, Kubernetes, VPC, etc. is straightforward and easy to secure, isolating the systems from outside.
  • Uptime SLA is high and maintenance operations are planned and notified in anticipation. Network and CPU performance is really good.
  • Automatic failover on high availability setups will automatically promote a read replica to master almost transparently for the client, so our applications will keep running even if the master DB server crashes.
  • There are no multi-master replication options. That may be a problem on distributed, high load, high performance environments.
  • Not many DB vendors available. MySQL came first, PostgreSQL took longer to be available and just now SQL Server is being offered as Beta.
  • Can get pricey quickly if you need to grow fast and much.
For any serious production setup, where "serious" means aware of the importance of having automatic/secure backups, a good recovery plan, high availability options and managed DB server maintenance, I go with this solution before any self-managed option.

I'd be cautious if I need too much processing power or storage available for my DB. On these cases, I'd first think again about my selected DB architecture, and then analyze some options to calculate ROI of each investment.
Read Leonel Quinteros's full review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use Google Cloud SQL for databases that are accessed across multiple servers. These dedicated SQL instances are easy to set up since they don't require a host VM. Not requiring a host VM also allows them to be more flexible and scalable. Settings allow Google Cloud SQL instances to automatically scale size as storage needs increase, and perform scheduled maintenance and backup. In our experience scaling and maintenance do not impact any system functionality.
  • Easy setup - No host VM, no software installation or configuration required.
  • Day to day reliability - Not depending on host VM allows more uptime.
  • Long term reliability - Storage scaling, backups, and maintenance can be scheduled to occur automatically.
  • Secure access is complicated to set up - This is the nature of secure access, but it can be frustrating spending much time simply configuring access.
  • No custom IP - It isn't possible to customize an instance's IP. This makes it harder to replace an instance since a new or clone instance always gets a new IP.
  • Cost tends to increase - This is the nature of cloud hosting, but over time costs creep up as utilization increases.
Google Cloud SQL is a great resource for some purposes, but it's probably overkill for others.
In cases where a database is not always needed (on sometimes, off others), it would be better to use a traditional software installation. If database needs are relatively small, software installation will perform just as well and be easier to support. If a database is only needed in one physical site or a small geographical region, it's better to use a regular server based installation. But as soon as a project has greater database needs, Google Cloud SQL is a great choice. Consider using it if any of these apply:

  • A large amount of data (10+ GB).
  • Decentralized access (many worksites, end-users, etc.).
  • Uptime and reliability are required.
Read this authenticated review
Bhargav Nanekalva profile photo
April 10, 2019

Second to none

Score 9 out of 10
Vetted Review
Verified User
Review Source
Google Cloud SQL is a managed SQL database service for MySQL and PostgreSQL. Since we use MySQL for some of our products, we moved our SQL tables schema and data from VMs to a Google Cloud SQL MySQL instance. This has helped us with simple backups/restorations, upgrades/downgrades, fine-tuning settings, and uptime. This also meant that if we had our MySQL running on a VM alongside other services and someone accidentally restarted/deleted the VM, then there's no need to worry about such situations if we are using the GCP's SQL.
  • It's easy to configure and use.
  • Built-in automatic data backups.
  • High availability instance failover.
  • Support for other open source SQL servers.
  • Lack of better information/documentation for failover configuration.
Google Cloud SQL provides the two most popular open source SQL servers, does everything right, and can be used for most use cases. It can be used for most business applications and at any scale, as Google Cloud SQL can scale very well based on the application needs. It's less appropriate for applications that use a DB other than MySQL and PostgreSQL, and for apps that don't need data persistence.
Read Bhargav Nanekalva's full review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
Google Cloud SQL (MySQL) is used as the relational data store for our product. The ability to scale up, have read replicas, and have automatic failover built into the offering are really nice features. The automated backup feature is nice as well. To have 7 days of backups available at any time without having to support the processes necessary to make that happen is great.
  • Automatic failover to another region in case the database goes down.
  • Easily scale the instance up if more processing power or memory is required.
  • Automatic backup validation. The backups are performed on a daily basis within the selected window, however, they are not validated. This means the backup could be reported as successful but ultimately be unusable in a situation where it is needed. We got around this issue by periodically validating on our own by spinning up a box, restoring the backup to the new instance, and then destroying the instance after validation. It's not perfect, but is a good sanity check to make sure our backups are valid in case we do need them.
It is great if you don't want to worry about managing hardware and infrastructure and instead focus your efforts on work directly related to your product's database needs, i.e. schema design, efficient queries, etc. However, if you are dealing with very large data sets, then BigQuery, BigTable, or similar might be better suited for your needs.
Read this authenticated review
Kristian Hareland profile photo
Score 7 out of 10
Vetted Review
Verified User
Review Source
We have been using it mainly whenever we need structured data.

Use case:
- Historical pricing of products (Archive)
  • Super easy to set up: new instance -> Authorization -> play
  • Automatic backup every night! (Keeps past 7 days as copy as well)
  • Automatic failover, in case your main SQL instance fails, they automatically switch you over.
  • It could be cheaper. Definitely cheaper.
  • It could provide more information about failovers.
  • It could allow you to customize more.
When you need relational storage.
Not when you need warehousing.
Read Kristian Hareland's full review
Tyler Longren profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
[We're] using it as the primary database supporting multiple WordPress installations that are running on Google Cloud. It's being used for every site that we currently have on Google Cloud, and are in the process of moving more sites over to this platform. Having everything on Google's infrastructure makes everything easy to manage and Google Cloud SQL is insanely fast.
  • It's insanely fast.
  • Easy integration with Google Cloud hosted services.
  • It's backed by Google's infrastructure, which is always good.
  • Connecting to it for the first time is a little confusing.
  • An interface for interacting with the data would be awesome.
If you're hosting a site on Google Cloud, it only makes sense to make use of Google Cloud SQL for the database, as opposed to running a separate MySQL service on a VM. It's extremely fast and has resulted in a dramatic improvement in page load time across multiple sites.
Read Tyler Longren's full review

Feature Scorecard Summary

Automatic software patching (7)
9.4
Database scalability (7)
8.8
Automated backups (7)
8.2
Database security provisions (7)
9.4
Monitoring and metrics (7)
8.4
Automatic host deployment (6)
7.9

About Google Cloud SQL

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

Google Cloud SQL Technical Details

Operating Systems: Unspecified
Mobile Application:No