GCP 101: Exploring Google Cloud SQL Database

No move to the cloud is complete without considering what to do with your databases. Do you leave them in your data center or on-prem legacy server or do you migrate them to the cloud? Migrating databases isn’t as hard as you think.

In this latest edition of GCP 101, we’ll explore the Google Cloud SQL database as a valid and efficient migration option for your existing relational databases to keep your data pipeline strong and reliable.

What is Google Cloud SQL Database?

If you’re using MySQL, PostgreSQL and SQL Server relational database engines and want a cloud-based alternative for them, Google Cloud SQL is worth exploring.

Google Cloud SQL is a fully managed, relational database that is designed to help you set up, maintain, manage, and administer your MySQL, PostgreSQL and SQL Server relational databases on Google Cloud Platform.

This service ensures your relational databases are reliable, scalable and secure in the cloud. Cloud SQL delivers powerful services for performance-intensive workloads, delivering up to 60,000 input/output operations per second (IOPS) with no extra cost for IO.

alarm clocksWhen it comes to deployment, it sets up in minutes, using built-in migration tools and standard drivers. Users can create connected databases in the cloud in minutes. Once those databases are up and running, it easily scales your instances with a single API call.

This is the case both when you are looking to start with simple testing or want to run a full-blown, highly scalable database in a production environment. It’s important to know that this cloud-based, relational database service is:

Fully Managed

Forget managing the day-to-day needs of your database. Because Cloud SQL is fully managed, it automatically backs, replicates and encrypts your data. It also applies patches when needed and manages capacity increases and drops. Oh, and according to Google, Cloud SQL is more than 99.95% available from anywhere in the world.

Reliable

The fact that Cloud SQL is fully managed only enhances its reliability. It takes automatic backups and replication a step further by providing automatic failover. This means if the Google Cloud server housing your Cloud SQL database crashes, your data is automatically moved to a standby server so it remains highly available to you.

The fact that Cloud SQL is fully managed only enhances its reliability. @OnixNetworking

Integrated

Users can access Cloud SQL from nearly any application or Google Cloud service, including App Engine, Compute Engine and Google Kubernetes Engine. You also can use Big Query to query your Cloud SQL databases and expand your analytics possibilities.

Google Cloud SQL

What are the Features of Google Cloud SQL Database?

Google Cloud SQL has several features that drive the above benefits. These include:

High Availability of Data

With a simple click of a button, users can replicate an instance to another zone or region. This built-in, high availability allows you to provide isolation for the instance from infrastructure hardware and software failures.

Secure Access and Connectivity

All data in Google Cloud SQL is encrypted at rest and in transit, both on Google networks and when it is stored, whether it’s in tables, backups or temporary files. This database service also supports private connectivity for organizations that use Google Virtual Private Cloud (VPC) and also includes a firewall with each instance to control public access.

Usage Scalability

There’s no need to worry about having too much data stored in Cloud SQL. You can easily scale up by adding up to 64 processor cores and 400+ GB of RAM to support up to 30TB of storage. What’s more, Cloud SQL can automatically scale up your storage capacity when you get close to your limit. This eliminates the need to estimate future storage needs and also keeps you from overbuying storage that you don’t use.

Backup and Restoretcc

Cloud SQL offers daily binary logging and backups. It also provides point-in-time restoration.

Now that you’ve explored the Google Cloud SQL database services, you won’t want to miss a look at other key services that Google Cloud Platform offers. Be sure to check out other blogs in our GCP 101 series:

GCP 101: An Introduction to Google Cloud Platform

GCP 101: How to Use Google Compute Engine

GCP 101: Building a Data Pipeline in Google Cloud Platform

GCP 101: How Autoscaling Works in the Google Cloud

GCP 101: Let’s Talk about Google Cloud Storage

Post Your Comments


SEARCH Blog

Data Management

MEET THE AUTHOR

Nickolaos Contaxakis, Cloud Solutions Engineer

Nickolaos Contaxakis, Cloud Solutions Engineer

A seasoned IT consultant with over 25 years of experience, Nick has run his own consulting business and worked for a variety of organizations including some of the biggest names in the industry. A self-admitted geek, he is recognized for his passion and curiosity for everything that is technology related.

MORE POSTS BY NICKOLAOS CONTAXAKIS, CLOUD SOLUTIONS ENGINEER

need some help moving to the cloud?

Meet with our cloud experts to talk through your best options. 

Get a Cloud Assessment