Creating a Cloud SQL Instance and Promoting Read Replica to Primary

1. From the main console, navigation head over to SQL.
2. Click on ** Create Instance**.
3. Choose MySQL.
4. Use the following details:

• Name: test-instance
• Choose a Cloud SQL edition: Enterprise
• Root password: 12345
• Region: us-central1
• Single Zone: us-central1-a
• Database Version: MySQL 5.7
• Sandbox preset: Sandbox
• Machine shapes: Dedicated core and the 1 vCPU, 3.75 GB option.

5. Use the following details:

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.

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;.

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.

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.

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.