A financial media company operates a real-time news analytics system hosted in Google Cloud's us-central1 region. The platform processes high-throughput data streams using Compute Engine Managed Instance Groups (MIGs) and stores user subscription profiles in Cloud SQL for PostgreSQL. The company requires a disaster recovery (DR) strategy for an unrecoverable outage in us-central1. The business mandates a Recovery Point Objective (RPO) of near zero (< 1 minute) and a Recovery Time Objective (RTO) under 15 minutes. To minimize idle infrastructure costs, compute resources in the secondary region (us-east4) should only be scaled up during an actual failover execution. Which disaster recovery execution strategy satisfies these requirements?
- Deploy a Pilot Light strategy: maintain cross-region read replicas for Cloud SQL in us-east4, and keep a minimal scaled-down MIG in us-east4; during failover, promote the Cloud SQL replica to primary and autoscaling expands the MIG.Answer
- BDeploy a Cold Standby strategy: schedule hourly Cloud SQL export dumps to a Multi-Regional Cloud Storage bucket and recreate the Compute Engine MIG and database from backups in us-east4 after an outage occurs.
- CMigrate the subscription database from Cloud SQL to Cloud Spanner across a single-region regional configuration and configure Compute Engine MIGs across two zones in us-central1.
- DDeploy a Warm Standby strategy: establish VPC Network Peering between us-central1 and us-east4, and rely on peered transitivity so secondary instances read directly from the primary us-central1 database during regional isolate tests.
Answer
Deploying a Pilot Light DR pattern with cross-region Cloud SQL read replicas and a minimal scaled-down Compute Engine MIG in the secondary region meets the near-zero RPO and 15-minute RTO requirements while optimizing cost.
The correct strategy combines continuous cross-region database replication (Cloud SQL read replica in us-east4) with a minimal compute footprint (scaled-down MIG). When a failure occurs in the primary region, promoting the database replica and scaling out the MIG fulfills the near-zero RPO and sub-15 minute RTO requirements without paying for full idle compute capacity.
Step-by-Step Solution
Key Concept
Disaster Recovery Patterns (Pilot Light vs Warm/Cold Standby) and RPO/RTO Alignment in GCP