Lab Intro: Cloud SQL for MySQL: Qwik Start

Introduction

This tutorial will guide you through the basics of using Cloud SQL for MySQL, as presented in the Qwiklabs video. You'll learn how to set up a Cloud SQL instance, connect to it, and perform basic operations. This knowledge is essential for managing databases in a cloud environment, making it highly relevant for developers and database administrators.

Step 1: Create a Cloud SQL Instance

1. Access Google Cloud Console

   • Go to the Google Cloud Console (console.cloud.google.com).
   • Ensure you have a Google Cloud account and are logged in.

2. Navigate to SQL Section

   • On the left sidebar, find and click on "SQL" under the "Databases" section.

3. Initiate Instance Creation

   • Click on the “Create Instance” button.
   • Select “MySQL” as the database engine.

4. Configure Instance Settings

   • Choose an instance ID (this will be the name of your instance).
   • Set a strong password for the root user.
   • Select the region and zone where you want your instance to be located.
   • Adjust any additional settings as needed, such as machine type and storage.

5. Create the Instance

   • Click on the “Create” button and wait for the instance to be provisioned. This may take a few minutes.

Step 2: Connect to Your Cloud SQL Instance

1. Set Up Connection Method

   • Once the instance is created, go to the instance details page.
   • Under the “Connect to this instance” section, choose your preferred connection method (e.g., using Cloud Shell, MySQL client, or a programming environment).

2. Connect via Cloud Shell

   • Open Cloud Shell by clicking the terminal icon in the top right corner of the console.
   • Use the following command to connect to your instance:

     gcloud sql connect [INSTANCE_ID] --user=root
     

   • Replace [INSTANCE_ID] with your actual instance ID.

3. Enter Password

   • When prompted, enter the password you created for the root user.

Step 3: Create a Database and Table

1. Create a Database

   • Once connected, create a new database by executing:

     CREATE DATABASE mydatabase;
     

2. Select the Database

   • Use the following command to select your new database:

     USE mydatabase;
     

3. Create a Table

   • Create a table to store data:

     CREATE TABLE users (
       id INT AUTO_INCREMENT PRIMARY KEY,
       name VARCHAR(100),
       email VARCHAR(100)
     );
     

Step 4: Insert and Retrieve Data

1. Insert Data into Table

   • Add a sample user to your table:

     INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');
     

2. Retrieve Data

   • Fetch the data you inserted with:

     SELECT * FROM users;
     

Conclusion

In this tutorial, you learned how to create and connect to a Cloud SQL for MySQL instance, as well as how to create a database and perform basic data operations. This foundational knowledge will help you manage databases effectively in a cloud environment. As a next step, consider exploring advanced features such as automated backups, security settings, and scaling options.