Your team manages a production Cloud SQL for PostgreSQL instance configured with High Availability (HA) across two zones in the us-central1 region. As part of a disaster recovery audit, you are required to perform a controlled failover test to verify that the standby instance takes over primary duties without destroying or re-creating the database instance. Which command or action should you execute to accomplish this operational task?
- Execute `gcloud sql instances failover INSTANCE_NAME` to initiate a manual failover to the standby instance.Answer
- BExecute `gsutil failover gs://INSTANCE_NAME` to initiate the regional switch of database storage.
- CChange the instance persistent disk storage class to Coldline to force an automatic zonal rebalancing event.
- DMigrate the database to Cloud Bigtable clusters to enable automatic relational transaction failover.
Answer
Execute the `gcloud sql instances failover INSTANCE_NAME` command to initiate a manual failover to the standby instance.
Executing `gcloud sql instances failover INSTANCE_NAME` triggers a controlled failover of a high-availability Cloud SQL instance to its secondary standby zone, making it the standard operational procedure for failover testing.
Step-by-Step Solution
Key Concept
Managing Cloud SQL High Availability and manual failover procedures