757

Of your peers have already watched this video.

3:10 Minutes

The most insightful time you'll spend today!

Explainer

What is Google Cloud SQL?

Cloud SQL is a fully managed relational database for MySQL, PostgreSQL, and SQL Server.

It reduces maintenance cost and automates database provisioning, storage capacity management, replication, and backups. It offers quick setup, with standard connection drivers and built-in migration tools.

How Do You Set It Up?

Cloud SQL is easy to setup. You select the region and zone where you would like the instance to be, and it gets created there.

You also have a lot of configuration options, where you can select the machine type with the right number of CPU and amount of memory you need.

Choose storage each type between solid state and hard disk drives, depending on latency queries per second and cost requirements and set storage capacity.

Higher storage capacity leads to better performance.

What About Back Up?

Cloud SQL also offers automated backups and recovery options.

You can set time slots and locations for backups. For production applications, it is recommended to enable high availability, or HA.

By enabling this feature, the database instancewill automatically failover to another zone in your selected region in case of an outage.

You can also create cross-regional replicas to protect from regional failures.

In addition, you can enable automatic storage increase to add more storage when nearing capacity.

How Do You Migrate an Existing MySQL Database to Cloud SQL?

Cloud console makes it very easy by providing a migrate data button, which guides you through easy steps.

First, you provide your data source details, things like public IP address, port number,

and your replication credentials.

Second, you create a Cloud SQL read replica, just like we discussed in the creation process, using a SQL dump file.

Third, you sync the read replica with source. And, finally, you promote the read replica to primary instance with very low downtime.

Is Data Safe in Cloud SQL?

Like anything else in Google Cloud,the data in Cloud SQL is encrypted at rest and in transit.

External connections can be encrypted using SSL or Cloud SQL Proxy, which is a tool to help you connect to your Cloud SQL instance from your local machines.

You can use Cloud SQL as a relational database for your applications that are hosted within Google Cloud, like App Engine, Cloud Run, Compute Engine, Kubernetes Engine, or Cloud Functions.

You can also connect your Cloud SQL database with applications that are hosted outside of Google Cloud.

How Much Does It Cost and What Are Some Uses Cases?

Cloud SQL pricing varies depending on MySQL, PostgreSQL,or SQL Server.

Broadly speaking, though, it’s the combination of the type of instance, storage, or network you use. SQL Server also has some licensing costs.

Since Cloud SQL is a relational database, you can use it with any online transaction processing apps, such as order or payment processing apps, where you need to handle frequent queries with fast response times.

More Relevant Stories for Your Company

How-to

How to Migrate an Oracle Database to Google Cloud

As more enterprises migrate a growing number of workloads to the cloud, migrating databases, too, has become a key focus. But migrating databases is also really tough. This is due to a number of different reasons. The first one is that there's a lot of proprietary technology and functionality that's

Case Study

Quantum Metric Increases Business 10-fold

At Quantum Metric, we’re in the business of bringing our customers business insights that are based on customer experience data and analytics for mid-market and Fortune 500 companies. Our software, powered by big data, machine intelligence, and Google Cloud, helps our customers identify, quantify, prioritize and measure opportunities to improve

How-to

Quick Tips to Get the Most Out of Cloud Spanner

Today, IT Admins and DBAs are inundated with thankless tasks. But they no longer have to deal with that. With Cloud Spanner, they can focus on value-add and innovation instead of maintenance. Creating or scaling a globally replicated database for mission-critical apps now takes a handful of clicks. Industry-leading high-availability

Case Study

How L&T Financial Services Processes 95% of Motorcycle Loans in Less Than Two Minutes

L&T Financial Services is one of the largest lenders in India. India’s demonetization policy in recent years has led to a shift from cash transactions to digital payments. In 2016, the government withdrew 500 and 1000 rupee notes from circulation and encouraged a heavily cash-based population to deposit their canceled notes

SHOW MORE STORIES