An aerospace satellite operations company hosts its ground telemetry monitoring system on Google Cloud. The primary workload runs in region `europe-west1`, utilizing Compute Engine Managed Instance Groups (MIGs) for application servers and Cloud SQL for PostgreSQL for critical mission metadata. To comply with regulatory requirements, the system requires a Disaster Recovery (DR) warm standby in `europe-west4` capable of achieving a Recovery Point Objective (RPO) of near-zero and a Recovery Time Objective (RTO) under 15 minutes. A regional catastrophe causes a complete failure of `europe-west1`. Which set of disaster recovery execution steps should the cloud architect specify in the failover runbook?
- Promote the cross-region Cloud SQL read replica in `europe-west4` to a standalone primary instance, reconfigure the `europe-west4` MIG application instances to target the promoted database, and update Cloud DNS routing policies to direct traffic to `europe-west4`.Cevap
- BRestore the latest automated Cloud SQL export file from a Cloud Storage multi-region bucket into a newly created Cloud SQL instance in `europe-west4`, then update Cloud DNS records.
- CSpin up new Compute Engine MIG instances in `europe-west4` during failover execution without requesting pre-allocated regional CPU quota, relying on automatic GCP project quota expansion during regional outage events.
- DRoute traffic from application servers in `europe-west4` through a transitive VPC Peering connection via a central hub VPC to access the database proxy in `europe-west1` until the primary region recovers.
Cevap
Promote the cross-region Cloud SQL read replica in `europe-west4` to a standalone primary instance, reconfigure the `europe-west4` MIG application instances to target the promoted database, and update Cloud DNS routing policies to direct traffic to `europe-west4`.
Promoting a cross-region Cloud SQL read replica to a standalone primary database is the standard GCP disaster recovery pattern for relational workloads requiring near-zero RPO and fast RTO. Because data is asynchronously replicated continuously across regions, promoting the replica provides immediate read-write capability. Updating application configurations and DNS routing completes the regional failover sequence within the required time window.
Adım Adım Çözüm
Anahtar Kavram
Disaster Recovery execution using Cloud SQL cross-region read replica promotion
Tahmini Süre:1m 30s