An enterprise healthcare logistics platform operates its primary inventory and ordering engine on Cloud SQL for MySQL in `europe-west1`, fronted by a Compute Engine Managed Instance Group (MIG). The architecture team must establish a disaster recovery (DR) execution plan to recover application operations in `europe-west4` during a catastrophic regional outage. Business continuity requirements specify a Recovery Point Objective (RPO) of and a Recovery Time Objective (RTO) of , while strictly minimizing idle infrastructure costs during standard operations. Which execution strategy meets all technical and business constraints?
- AMigrate the inventory database from Cloud SQL to a multi-region Cloud Spanner instance spanning `europe-west1` and `europe-west4`, while maintaining fully provisioned, active Compute Engine MIG capacity in both regions continuously.
- Maintain a cross-region asynchronous Cloud SQL read replica in `europe-west4`, pre-allocate regional compute quotas, and keep an unscaled MIG template ready. During failover, promote the replica to a primary database, scale out the MIG instance count, and update Cloud DNS routing.Cevap
- CProvision a secondary MIG in `europe-west4` and route hybrid backend traffic through an existing VPC Network Peering connection established between `europe-west1` and the central hybrid transit VPC, avoiding a separate VPN or Interconnect in `europe-west4`.
- DConfigure automated hourly Cloud SQL export dumps to a multi-region Cloud Storage bucket. Upon regional disaster declaration, restore the database from snapshot into `europe-west4` and request an emergency regional vCPU quota increase for compute scaling.
Cevap
Maintain a cross-region asynchronous Cloud SQL read replica in the DR region with pre-allocated compute quotas and unscaled MIG instance templates. Upon disaster declaration, promote the replica, scale up the MIG, and update DNS routing.
The correct strategy uses a Cloud SQL cross-region read replica to continuously mirror state from `europe-west1` to `europe-west4`, satisfying the RPO. Pre-approved compute quota and automated MIG deployment templates allow compute capacity to scale on demand during a failover event within the 15-minute RTO, while keeping idle compute costs at near zero during normal operation.
Adım Adım Çözüm
Anahtar Kavram
Disaster Recovery Strategy Execution (Warm Standby / Pilot Light with Cloud SQL Cross-Region Replication)