Google Cloud SQL - Good Alternative to On Premise and Custom Database Hosting on Cloud
We used postage SQL to host our relational data of product catalog. Initially we had custom PostgreSQL hosted on AWS but due to costing, …
Starting at $0 per core hour
View PricingOverview
What is Google Cloud SQL?
Google Cloud SQL is a database-as-a-service (DBaaS) with the capability and functionality of MySQL.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Automated backups (22)9.494%
- Database security provisions (22)9.292%
- Database scalability (22)9.090%
- Monitoring and metrics (21)8.686%
Reviewer Pros & Cons
Pricing
License - Express
$0
Cloud
per core hour
License - Web
$0.01134
Cloud
per core hour
Storage - for backups
$.08
Cloud
per month per GB
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://cloud.google.com/sql/pricing?ut…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
Choosing a PostgreSQL database on Google Cloud
YouTube
Database Configurations with Google Cloud SQL
YouTube
Connecting Google Sheets to Cloud SQL using Apps Script
YouTube
Features
Return to navigation
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Google Cloud SQL?
Google Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server. Google states more than 95% of Google Cloud's top 100 customers use Cloud SQL to run their businesses.
Displays AI/ML-driven insights and recommendations for performance, security, reliability, and cost. Database performance issues are displayed and managed through pre-built dashboards and visual query plans using Cloud SQL Insights. Cloud SQL with Active Assist uses advanced analytics and ML to identify over-provisioned and idle instances in a fleet and sends alerts when they are needed.
Fully managed
Cloud SQL automates backups, replication, patches, encryption, and storage capacity.
Open and standards-based
Cloud SQL supports the most popular open source and commercial engines, including MySQL, PostgreSQL, and SQL Server with support for extensions, configuration flags, and popular developer tools. The user can create a database with a few clicks in the console and connect an application.
Cost-effectiveness
Users can scale with application growth, customize machine types, and choose different levels of performance and availability, up to a 99.99% availability SLA. Committed use discounts offer additional savings for one to three year commitments.
Intelligent insights and manageability
Gemini in Databases
AI-powered assistance is included to simplify database management. Gemini in Cloud SQL, in preview, enables developers, operators, and database administrators to build applications quickly using natural language, and helps manage, optimize, and govern an entire fleet of databases with a single pane of glass.
Google Cloud SQL Features
Database-as-a-Service Features
- Supported: Database scalability
- Supported: Automated backups
- Supported: Database security provisions
- Supported: Monitoring and metrics
Google Cloud SQL Screenshots
Google Cloud SQL Videos
Cloud SQL in a minute
What is Cloud SQL?
Introducing Cloud SQL Insights
Google Cloud SQL Competitors
Google Cloud SQL Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
Frequently Asked Questions
Google Cloud SQL is a database-as-a-service (DBaaS) with the capability and functionality of MySQL.
Azure SQL Database, Amazon Relational Database Service (RDS), and Microsoft SQL Server are common alternatives for Google Cloud SQL.
Reviewers rate Automatic software patching highest, with a score of 9.6.
The most common users of Google Cloud SQL are from Small Businesses (1-50 employees).
Comparisons
Compare with
Reviews and Ratings
(77)Attribute Ratings
Reviews
(1-4 of 4)Companies can't remove reviews or game the system. Here's why
December 03, 2020
All the functionality of MySQL with added managed support
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.
75%
7.5
- Allowed for the storage of Terabytes of data without a lot of developer time, freeing up man hours.
We came to Google Cloud SQL in need of a cloud database solution to house analytic data we collect from various I.T. systems, most importantly our trouble ticketing tool. The goal was a central repository that was easy to manage for our small organization. Our data storage needs are small compared to many organizations.
- Easy Setup
- Easy Configuration
- Tools we use send people elsewhere (AWS especially)
- Few integrations
81.66666666666666%
8.2
- Less on site storage used
- Centralized data storage
Google Cloud SQL is just as good as the other guys. We were already invested in GCP, which made the choice very easy. We did not want to start fresh in AWS or Azure. We used our existing GCP setup and just added Cloud SQL. It's unfortunate that companies continue to send people to AWS when Google's offerings are just as good or better.
November 30, 2019
Simpler and more reliable database hosting
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.
90%
9.0
- Simpler IT administration since database software management is eliminated.
- Lower server requirements since databases are in dedicated instances.
- Higher reliability and uptime.
There are many options for cloud-hosted dedicated SQL instances. In many ways, simply moving from software and server-based database to a dedicated cloud database is just generally good. All hosts provide some sort of scaling and backup, and all separate the server management from database administration.
Google Cloud SQL is very straightforward and easy to use. Once a SQL instance is created, there are easy to follow guides for getting connected and adjusting basic features.
The real benefit of using Google's services over another provider comes into play for anybody already using other Google Cloud services. Management is easy since all Google Cloud resources can be accessed from a single console web interface. Perhaps most importantly, communications between cloud resources are more secure since they don't go over the public internet, and they generally avoid incurring networking charges.
Google Cloud SQL is very straightforward and easy to use. Once a SQL instance is created, there are easy to follow guides for getting connected and adjusting basic features.
The real benefit of using Google's services over another provider comes into play for anybody already using other Google Cloud services. Management is easy since all Google Cloud resources can be accessed from a single console web interface. Perhaps most importantly, communications between cloud resources are more secure since they don't go over the public internet, and they generally avoid incurring networking charges.
November 20, 2019
Managed MySQL/PostgreSQL DB infrastructure and clusters
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.
90%
9.0
- When first migrated to a cloud environment, the Cloud SQL instance had a higher cost than our former MySQL VM instance, but many other infrastructure costs had also been reduced and the total balance of our migration to the cloud was a reduction of 45% of our infrastructure costs.
- DB performance has increased and maintenance tasks reduced in a high percentage.
- Disaster recovery plans are easier to follow now than before our cloud migration.
Google Cloud SQL is very similar to other cloud provider options. AWS and DigitalOcean are direct competitors, While Azure is focusing on their own products. At cloud provider level, it's a matter of choosing the provider, and this product will not play a significant role on that decision.
Now, between this and managing my own DB instances, only reasons to do that are if I need a DB vendor not available, if doing that will reduce operational costs significantly, or if I need to have full control over my data for regulatory or confidentiality reasons.
Now, between this and managing my own DB instances, only reasons to do that are if I need a DB vendor not available, if doing that will reduce operational costs significantly, or if I need to have full control over my data for regulatory or confidentiality reasons.