[Solved] You tried to create a Cloud SQL instance with this command:gcloud sql instances create mydb --database-version=MYSQL_5_7 --tier=n1-standard-1 --region=us-west1But you get an error saying the tier is... | GCP

GCP - Cloud SQL and Databases

You tried to create a Cloud SQL instance with this command:

gcloud sql instances create mydb --database-version=MYSQL_5_7 --tier=n1-standard-1 --region=us-west1

But you get an error saying the tier is invalid. What is the likely cause?

AThe tier name is correct but the database version is invalid

BThe region us-west1 does not support MySQL 5.7

CThe tier name should be db-n1-standard-1 with 'db-' prefix

DThe tier name requires a different format for MySQL

Step-by-Step Solution

Solution:

Step 1: Check tier naming conventions
Cloud SQL machine tiers use the 'db-' prefix. The correct tier name is 'db-n1-standard-1'.
Step 2: Validate other parameters
MySQL 5.7 is valid, and us-west1 supports it. The error is due to missing 'db-' prefix in tier name.
Final Answer:
The tier name should be db-n1-standard-1 with 'db-' prefix -> Option C
Quick Check:
Tier names include 'db-' prefix [OK]

Quick Trick: Add 'db-' prefix to tier names for Cloud SQL [OK]

Common Mistakes:

Master "Cloud SQL and Databases" in GCP

9 interactive learning modes - each teaches the same concept differently

More GCP Quizzes

You tried to create a Cloud SQL instance with this command: