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.
Successfully complete this lab by achieving the following learning objectives:
- Create a Cloud SQL Instance
- From the main console, navigation head over to SQL.
- Click on Create Instance.
- Choose MySQL.
- Name the instance patient-records-instance
Root pass: 12345
Database Version: MySQL 5.7
- Set the configuration to Development
- Set the Machine Type to Standard with 1 vCPU and 3.75GB memory
- Click Create
- Enable the Cloud SQL Admin API and Connect to the instance using Google Cloud Shell
- From the main console navigation, head over to APIs and Services.
- Click on Enable APIs and Services.
- Then type in Cloud SQL Admin API.
- Click Enable.
Connect to the Cloud SQL instance
- From the SQL console, click on the patient-records-instance instance.
- Head to the Connect to the instance section.
- Click on Connect using the cloud shell
- You are prompted with the gcloud sql connect patient-records-instance –user=root –quiet command. Press Enter
- Put in the root password, which is 12345, and press enter
- You are now logged into the MySQL instance.
- Create a Database and Table
- Use the command CREATE DATABASE master;.
- Use the command USE master; to use the database to create a table.
- Use the command CREATE TABLE mastertable (name VARCHAR(15), city VARCHAR(30));.
- Verify the table has been created by using the command SHOW TABLES;.
- Create Read Replica
- Click on the REPLICAS tab within the Instance Details dashboard, then click on Create read replica.
- Keep everything as the default and click Create.
- Promote Read Replica
- Click on the test-instance-replica tab under your master instance.
- 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.
- From the SQL console, click on the newly promoted test-instance-replica instance.
- Verify the database has been replicated by using the command SHOW DATABASES;
- Use the command USE master; then SHOW TABLES; to verify that the table has been replicated.