Why managed databases matter in GCP - See It in Action

Why managed databases matter

📖 Scenario: You are working for a small online store that wants to keep its customer and order data safe and easy to manage. You decide to use a managed database service on Google Cloud Platform (GCP) to help with this.

🎯 Goal: Create a simple configuration for a managed database instance on GCP. This will help the store keep data safe, backed up, and easy to access without needing to manage the database server yourself.

📋 What You'll Learn

Create a variable called instance_name with the exact value store-db-instance

Create a variable called database_version with the exact value POSTGRES_14

Create a variable called tier with the exact value db-f1-micro

Create a variable called region with the exact value us-central1

Create a configuration dictionary called db_config that includes the instance name, database version, tier, and region

Add a final key backup_enabled set to True in db_config

💡 Why This Matters

🌍 Real World

Managed databases let businesses avoid the hard work of running database servers. They handle backups, updates, and scaling automatically.

💼 Career

Cloud engineers and developers often configure managed databases to ensure applications run smoothly without manual database management.

1

Create initial variables for the managed database

Create a variable called instance_name and set it to "store-db-instance". Then create a variable called database_version and set it to "POSTGRES_14".

GCP

# Your code here

Need a hint?

Use simple assignment to create the variables with the exact names and values.

2

Add configuration variables for tier and region

Create a variable called tier and set it to "db-f1-micro". Also create a variable called region and set it to "us-central1".

GCP

instance_name = "store-db-instance"
database_version = "POSTGRES_14"
# Your code here

Need a hint?

Use simple assignment again for these two new variables.

3

Create the database configuration dictionary

Create a dictionary called db_config that includes the keys "instance_name", "database_version", "tier", and "region". Use the variables you created earlier as the values for these keys.

GCP

instance_name = "store-db-instance"
database_version = "POSTGRES_14"
tier = "db-f1-micro"
region = "us-central1"
# Your code here

Need a hint?

Use a dictionary with keys as strings and values as the variables you defined.

4

Enable backups in the database configuration

Add a key called backup_enabled with the value True to the db_config dictionary.

GCP

instance_name = "store-db-instance"
database_version = "POSTGRES_14"
tier = "db-f1-micro"
region = "us-central1"
db_config = {
    "instance_name": instance_name,
    "database_version": database_version,
    "tier": tier,
    "region": region
}
# Your code here

Need a hint?

Add the new key and value inside the existing dictionary.