Creating a Cloud SQL Instance and Promoting Read Replica to Primary

1.25 hours
  • 6 Learning Objectives

About this Hands-on Lab

Creating a Read Replica for your master instance can help offload any read request to the replica. This will help your instance with performance. In this Hands-On Lab, we will learn how to create a Read Replica and promote that replica to become a standalone instance.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create a Cloud SQL Instance
  1. From the main console, navigation head over to SQL.
  2. Click on Create Instance.
  3. Choose MySQL.
  4. Name the instance patient-records-instance
    Root pass: 12345
    Database Version: MySQL 5.7
  5. Set the configuration to Development
  6. Set the Machine Type to Standard with 1 vCPU and 3.75GB memory
  7. Click Create
Enable the Cloud SQL Admin API and Connect to the instance using Google Cloud Shell
  1. From the main console navigation, head over to APIs and Services.
  2. Click on Enable APIs and Services.
  3. Then type in Cloud SQL Admin API.
  4. Click Enable.

Connect to the Cloud SQL instance

  1. From the SQL console, click on the patient-records-instance instance.
  2. Head to the Connect to the instance section.
  3. Click on Connect using the cloud shell
  4. You are prompted with the gcloud sql connect patient-records-instance –user=root –quiet command. Press Enter
  5. Put in the root password, which is 12345, and press enter
  6. You are now logged into the MySQL instance.
Create a Database and Table
  1. Use the command CREATE DATABASE master;.
  2. Use the command USE master; to use the database to create a table.
  3. Use the command CREATE TABLE mastertable (name VARCHAR(15), city VARCHAR(30));.
  4. Verify the table has been created by using the command SHOW TABLES;.
Create Read Replica
  1. Click on the REPLICAS tab within the Instance Details dashboard, then click on Create read replica.
  2. Keep everything as the default and click Create.
Promote Read Replica
  1. Click on the test-instance-replica tab under your master instance.
  2. Head to the top of the console and click on Promote Replica, then choose OK.
Login to the newly promoted replica and verify the replicated data.
  1. From the SQL console, click on the newly promoted test-instance-replica instance.
  2. Verify the database has been replicated by using the command SHOW DATABASES;
  3. Use the command USE master; then SHOW TABLES; to verify that the table has been replicated.

Additional Resources

You are given the task to create and test an environment where you will create a Database instance with a database and table for structured data.

You will need to create a solution that can offload read requests, so there isn’t anything degrading the performance of your database instance.

Also, your team would like to see that the solution to offload read requests stand alone as well.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?