A global supply chain enterprise operates a critical order management platform with a warm standby disaster recovery topology across Google Cloud regions `us-central1` (primary) and `europe-west3` (secondary). The application relies on Cloud SQL for PostgreSQL with asynchronous cross-region read replication. Following an unrecoverable regional disaster in `us-central1`, the operational engineering team must execute the disaster recovery runbook to restore service while ensuring data consistency and preventing split-brain states. In what sequential order should the operational team execute the disaster recovery failover tasks?
- 1Disable client traffic ingress at the primary load balancer and revoke database write permissions to isolate the degraded primary instance.
- 2Promote the cross-region Cloud SQL read replica in `europe-west3` to a standalone primary database instance.
- 3Scale out the secondary Compute Engine managed instance groups to full production capacity.
- 4Update Cloud DNS routing policies to point production domain names to the secondary region endpoint.
- 5Configure automated Cloud Storage backup schedules and initialize a new cross-region read replica from the newly promoted database instance.
Cevap
The correct operational sequence begins by stopping ingress traffic and revoking write permissions on the primary region to prevent split-brain updates. Next, promote the cross-region Cloud SQL read replica in the secondary region to a standalone read-write database instance. Third, scale up the secondary Compute Engine managed instance groups to handle full application load. Fourth, update Cloud DNS routing policies to direct client traffic to the secondary region endpoints. Finally, re-establish disaster recovery redundancy by enabling backup schedules and creating a new cross-region read replica from the newly promoted primary instance.
The correct operational order minimizes data loss and prevents split-brain scenarios. First, isolating the degraded primary stops incoming transactions and lets asynchronous replication finish applying in-flight logs. Second, promoting the database replica enables write capabilities in the secondary region. Third, scaling up compute capacity ensures the secondary application tier can handle the incoming user load. Fourth, modifying DNS records steers user traffic to the active secondary region. Finally, restoring backup schedules and creating a new cross-region replica re-establishes disaster recovery protection.
Adım Adım Çözüm
Anahtar Kavram
Disaster Recovery Failover Sequence and Split-Brain Prevention