-
Course
- Cloud
- Data
Creating and Administering Google Cloud SQL Instances
Cloud SQL is the Google Cloud Platform's managed SQL service which offers powerful and simple RDBMS functionality. Cloud SQL supports both MySQL as well as PostgreSQL on the cloud.
What you'll learn
An important component of an organization's on-premises solution is the relational database. Cloud SQL is an RDBMS offering on the GCP which makes the operational and administrative aspects of databases very easy to handle. In this course, Creating and Administering Google Cloud SQL Instances, you will learn how to create, work with and manage Cloud SQL instances on the GCP. First, you will assess the range of data storage services on the GCP and understand when you would choose to use Cloud SQL over other technologies. Then, you will create Cloud SQL instances, connect to them using a simple MySQL client, and configure and administer these instances using the web console as well as the gcloud command line utility. Next, you will focus on how Cloud SQL can work in high-availability mode. After that, you will configure failover replicas for high-availability and simulate an outage event to see how the failover replica kicks in. FInally, you will see how to use read replicas for increased read throughput and how data can be migrated into Cloud SQL instances using a SQL dump or from CSV files. At the end of this course, you will be comfortable creating, connecting to, and administering Cloud SQL instances to manage relational databases on the Google Cloud Platform.
Table of contents
- Module Overview | 1m 32s
- Prerequisites and Course Outline | 3m 55s
- Introducing Cloud SQL | 2m 46s
- MySQL on Cloud SQL | 5m 47s
- PostgreSQL on Cloud SQL | 1m 35s
- MySQL 2nd Generation Pricing | 5m 12s
- PostgreSQL Pricing | 2m
- MySQL 1st Generation Pricing | 43s
- Cloud SQL vs. Other GCP Storage Technologies | 7m 51s
- Cloud SQL Internals | 4m 39s
- The Web Console and Cloud Shell | 4m 51s
About the author
A problem solver at heart, Janani has a Masters degree from Stanford and worked for 7+ years at Google. She was one of the original engineers on Google Docs and holds 4 patents for its real-time collaborative editing framework.
More Courses by Janani