Read replicas in GCP - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a read replica instance in Cloud SQL.

GCP

gcloud sql instances create replica-instance --master-instance-name=[1] --region=us-central1

Drag options to blanks, or click blank then click option'

Areplica-instance

Bprimary-instance

Cbackup-instance

Dmain-instance

Attempts:

3 left

💡 Hint

Common Mistakes

Using the replica instance name instead of the primary instance name.

Confusing backup instances with master instances.

The --master-instance-name flag specifies the primary instance to replicate from.

2fill in blank

medium

Complete the code to enable replication on the primary Cloud SQL instance.

GCP

gcloud sql instances patch primary-instance --[1]=ON

Drag options to blanks, or click blank then click option'

Abackup

Bmaintenance

Cbin-log-enabled

Dfailover

Attempts:

3 left

💡 Hint

Common Mistakes

Enabling backup instead of replication.

Using maintenance or failover flags incorrectly.

Enabling bin-log-enabled on the primary instance allows read replicas to sync data.

3fill in blank

hard

Fix the error in the command to list read replicas of a Cloud SQL instance.

GCP

gcloud sql instances list --filter='[1]:REPLICA'

Drag options to blanks, or click blank then click option'

Ainstance

Brole

Creplica

DINSTANCE_TYPE

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'REPLICA' as a filter key instead of a value.

Using 'role' or 'instance' which are not valid filter keys here.

The filter key INSTANCE_TYPE is used to specify instance types like 'REPLICA'.

4fill in blank

hard

Fill both blanks to configure a read replica with a specific machine type and storage size.

GCP

gcloud sql instances create replica-instance --master-instance-name=primary-instance --tier=[1] --storage-size=[2]

Drag options to blanks, or click blank then click option'

Adb-custom-2-3840

Bdb-f1-micro

C20GB

D10GB

Attempts:

3 left

💡 Hint

Common Mistakes

Using a very small machine type that is not recommended for replicas.

Specifying storage size without units.

The --tier flag sets the machine type, and --storage-size sets the disk size for the replica.

5fill in blank

hard

Fill all three blanks to create a read replica with a specific region, activation policy, and database version.

GCP

gcloud sql instances create replica-instance --master-instance-name=primary-instance --region=[1] --activation-policy=[2] --database-version=[3]

Drag options to blanks, or click blank then click option'

Aus-east1

Balways

CPOSTGRES_14

Dus-west1

Attempts:

3 left

💡 Hint

Common Mistakes

Using an invalid region name.

Setting activation policy to 'never' which disables the instance.

Choosing a database version that does not match the primary.

The --region flag sets the location, --activation-policy controls instance start behavior, and --database-version specifies the database engine version.