A media enterprise is designing a highly resilient database architecture on AWS. The system must meet two requirements:
1. Achieve high availability with synchronous replication to prevent data loss in the event of a single data center outage.
2. Provide disaster recovery capabilities that can survive a complete regional disaster.
Which deployment strategy best satisfies these requirements while minimizing write latency for the primary database?
- Deploy the primary database and its synchronous standby replica across multiple Availability Zones within a single AWS Region, and configure asynchronous replication to a secondary database in a different AWS Region.Answer
- BDeploy the primary database and its synchronous replica in two different AWS Regions, and use Edge Locations to cache write operations to reduce latency.
- CDeploy the primary database in a single Availability Zone, and set up synchronous replication to an Edge Location within the same Region to handle failover.
- DDeploy the primary database and its standby replica in a single Availability Zone to eliminate network latency, and configure synchronous replication to a Local Zone in a different country.
Answer
Deploy the primary database and its synchronous standby replica across multiple Availability Zones within a single AWS Region, and configure asynchronous replication to a secondary database in a different AWS Region.
Deploying the primary database and its standby replica across multiple Availability Zones within a single AWS Region ensures high availability. Since Availability Zones are physically isolated but connected via low-latency, redundant fiber-optic networks, synchronous replication is supported with minimal impact on write latency. To survive a regional disaster, data must be replicated to a different AWS Region. Because of the latency introduced by geographic distance, this replication must be asynchronous to avoid slowing down writes on the the primary database.
Step-by-Step Solution
Key Concept
AWS Regions and Availability Zones replication characteristics