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 instance.
  1. From the main navigation, click Cloud SQL.
  2. Click Create Instance.
  3. Choose your database engine.
  4. In the Customize your instance section, in Machine Type. Choose Standard and 1 vCPU, 3.75 GB. Select a single zone deployment and 10GB storage.
  5. Enter an instance ID.
  6. Provide a password.
  7. Click Create.
Create a database.
  1. Select the 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 Create clone.
  2. Enter a new name for the clone if desired.
  3. Choose Clone latest state of instance.
  4. Click Create 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 Standard Machine type and 1 vCPU, 3.75 GB. Select a single zone deployment and 10GB storage.

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?