GCPcloud~30 mins

Creating a Cloud SQL instance in GCP - Try It Yourself

Choose your learning style10 modes available

Learn Why Deep Visual Try Challenge Project Recall Time

Creating a Cloud SQL instance

📖 Scenario: You are setting up a Cloud SQL instance on Google Cloud Platform to host a database for a small web application. This instance will store user data securely and allow the application to connect to it.

🎯 Goal: Build a Cloud SQL instance configuration using Terraform that creates a MySQL database instance with basic settings.

📋 What You'll Learn

Create a Terraform resource block for a Cloud SQL instance named my-sql-instance.

Set the database version to MYSQL_8_0.

Configure the instance with a db-f1-micro machine type.

Set the region to us-central1.

Enable automated backups.

💡 Why This Matters

🌍 Real World

Cloud SQL instances are used to host managed relational databases for applications, removing the need to manage database servers manually.

💼 Career

Knowing how to create and configure Cloud SQL instances is essential for cloud engineers and developers working with Google Cloud Platform to build scalable and reliable applications.

Progress0 / 4 steps

DATA SETUP: Define the Terraform provider

Write a Terraform block to configure the Google Cloud provider with the project ID my-gcp-project and region us-central1.

GCP

# Your code here

Hint

Use the provider "google" block with project and region attributes.

CONFIGURATION: Define the Cloud SQL instance resource

Add a Terraform resource block named google_sql_database_instance with the name my-sql-instance and set the database version to MYSQL_8_0.

GCP

provider "google" {
  project = "my-gcp-project"
  region  = "us-central1"
}

# Your code here

Hint

Use resource "google_sql_database_instance" "my-sql-instance" and set name and database_version.

CORE LOGIC: Configure the instance settings

Inside the google_sql_database_instance resource, add an settings block that sets the tier to db-f1-micro and the location to us-central1.

GCP

provider "google" {
  project = "my-gcp-project"
  region  = "us-central1"
}

resource "google_sql_database_instance" "my-sql-instance" {
  name             = "my-sql-instance"
  database_version = "MYSQL_8_0"

  # Your code here
}

Hint

Use a settings block with tier and location inside the resource.

COMPLETION: Enable automated backups

Inside the settings block, add a backup_configuration block with enabled = true to enable automated backups.

GCP

provider "google" {
  project = "my-gcp-project"
  region  = "us-central1"
}

resource "google_sql_database_instance" "my-sql-instance" {
  name             = "my-sql-instance"
  database_version = "MYSQL_8_0"

  settings {
    tier    = "db-f1-micro"
    location = "us-central1"

    # Your code here
  }
}

Hint

Add a backup_configuration block inside settings with enabled = true.

Practice

(1/5)

1. What is the main purpose of creating a Cloud SQL instance in Google Cloud?

easy

A. To store files and objects in the cloud

B. To set up a managed database service without handling server maintenance

C. To create a virtual machine for running applications

D. To configure network firewalls for security

Recommended

Ready to prove it?

Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

10 questions~5 mineasy hard

Creating a Cloud SQL instance in GCP - Try It Yourself

Practice

Solution

Step 1: Understand Cloud SQL service

Step 2: Identify the purpose of creating an instance

Final Answer:

Quick Check:

Solution

Step 1: Recall correct gcloud command syntax

Step 2: Check flags for database version and region

Final Answer:

Quick Check:

Solution

Step 1: Analyze command parameters

Step 2: Validate parameters

Final Answer:

Quick Check:

Solution

Step 1: Check tier naming conventions

Step 2: Validate other parameters

Final Answer:

Quick Check:

Solution

Step 1: Identify flag for high availability

Step 2: Confirm other parameters

Final Answer:

Quick Check:

Ready to prove it?