When working with Cloud SQL on any scale, you’ll need to manage multiple instances: creating, cloning, starting, stopping, restarting, and — eventually — deleting them. This hands-on lab gives you the experience of performing all those tasks so you’ll be familiar with the steps necessary to handle Cloud SQL instances completely.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Create an Instance
- From the main navigation, navigate to Cloud SQL.
- Click CREATE INSTANCE.
- Choose your database engine.
- In the Customize your instance section, choose the shared core machine type. Select a single zone deployment and 10GB storage. GCP lab and sandbox regions now include: US-East-1, US-West-1, US-Central-1, Europe-West-1, and Australia-Southeast-1.
- Enter an instance ID.
- Provide a password.
- Click CREATE.
- Create a Database
- Select your recently created Cloud SQL instance.
- Choose CREATE DATABASE.
- Name the database and leave the other fields at their default values.
- Click CREATE.
- Clone the Instance
- From the Instance details page, choose CLONE.
- Enter a new name for the clone if desired.
- Choose Clone latest state of instance.
- Click CLONE.
- Stop and Start an Instance
- Select the first instance created.
- Click STOP.
- After the instance has stopped, click START.
- Restart an Instance
- Select the cloned instance.
- Click RESTART.
- Delete an Instance
- Select the cloned instance.
- Click DELETE.
- Enter the name of the instance in the dialog to confirm the deletion.
- Click DELETE.