Managing Google Cloud SQL Instances

1 hour
  • 6 Learning Objectives

About this Hands-on Lab

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
  1. From the main navigation, navigate to Cloud SQL.
  2. Click CREATE INSTANCE.
  3. Choose your database engine.
  4. 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.
  5. Enter an instance ID.
  6. Provide a password.
  7. Click CREATE.
Create a Database
  1. Select your recently created Cloud SQL instance.
  2. Choose CREATE DATABASE.
  3. Name the database and leave the other fields at their default values.
  4. Click CREATE.
Clone the Instance
  1. From the Instance details page, choose CLONE.
  2. Enter a new name for the clone if desired.
  3. Choose Clone latest state of instance.
  4. Click CLONE.
Stop and Start an Instance
  1. Select the first instance created.
  2. Click STOP.
  3. After the instance has stopped, click START.
Restart an Instance
  1. Select the cloned instance.
  2. Click RESTART.
Delete an Instance
  1. Select the cloned instance.
  2. Click DELETE.
  3. Enter the name of the instance in the dialog to confirm the deletion.
  4. Click DELETE.

Additional Resources

You’ve been asked to take control of the team's Cloud SQL initiative. To fully grasp how the platform works, you’ll need to understand basic Cloud SQL instance management tasks. You’ll need to know how to create instances, as well as clone, start, stop, restart, and delete them.

You’ll need to accomplish the following steps to complete your task:

  1. Create a new Cloud SQL instance
  2. Create a database
  3. Clone the instance
  4. Stop the first instance
  5. Start the first instance
  6. Restart the second instance
  7. Delete both instances

Note: When creating the instance, use a one zone configuration and 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.

Note: Please refer to the lab guide when working on this lab.

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?