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.Cevap
- 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.
Cevap
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.
Adım Adım Çözüm
Anahtar Kavram
Managing Cloud SQL High Availability and manual failover procedures