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.
Author Name: Janani Ravi
Author Description:
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

Table of Contents

• Course Overview
  1min
• Understanding Cloud SQL in the GCP Service Taxonomy
  40mins
• Creating Cloud SQL Instances
  59mins
• Replication and Data Management
  46mins