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 2m
- Prerequisites and Course Outline 4m
- Introducing Cloud SQL 3m
- MySQL on Cloud SQL 6m
- PostgreSQL on Cloud SQL 2m
- MySQL 2nd Generation Pricing 5m
- PostgreSQL Pricing 2m
- MySQL 1st Generation Pricing 1m
- Cloud SQL vs. Other GCP Storage Technologies 8m
- Cloud SQL Internals 5m
- The Web Console and Cloud Shell 5m
- Module Overview 1m
- Creating a Cloud SQL Instance 7m
- Editing an Instance Using the Web Console 4m
- Cloning, Starting, Stopping, and Deleting Instances 5m
- Connecting Using the Cloud Shell 5m
- Connecting Using a MySQL Client 6m
- Connecting Using SSL 7m
- Configuring Database Flags 3m
- Labeling Cloud SQL Instances 4m
- Introducing the Cloud SQL Proxy 5m
- Using the Cloud SQL Proxy 8m
- Working with PostgreSQL 4m
- Module Overview 1m
- High Availability Configuration 5m
- Configuring Failover Replicas for High Availability 7m
- Configuring Replication Lag Alerts Using Stackdriver 4m
- Automated and On-demand Backups 2m
- Restoring from a Backup 6m
- Creating and Managing Read Replicas 7m
- Creating a SQL Dump File 5m
- Importing Data from a SQL Dump File 3m
- Exporting and Importing CSV Files 4m
- Summary and Further Study 2m
About the author
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. After spending years working in tech in the Bay Area, New York, and Singapore at companies such as Microsoft, Google, and Flipkart, Janani finally decided to combine her love for technology with her passion for teaching. She is now the co-founder of Loonycorn, a content studio focused on providing ... more