Answer-first summary for fast verification
Answer: Migrate the MySQL database to an Amazon Aurora global database. Host the primary DB cluster in the primary Region. Host the secondary DB cluster in the DR Region.
## Explanation **Correct Answer: C** Amazon Aurora Global Database is specifically designed for multi-region disaster recovery scenarios with minimal operational overhead. Here's why: ### Why Option C is Correct: 1. **Built-in Multi-Region Replication**: Aurora Global Database provides automated, low-latency replication across AWS Regions with typical recovery point objectives (RPO) of less than 1 second. 2. **Minimal Operational Overhead**: AWS manages the replication, failover, and recovery processes automatically. 3. **Fast Failover**: In case of a regional outage, you can promote the secondary cluster in the DR Region to primary with minimal downtime (typically less than 1 minute). 4. **Read Scaling**: The secondary cluster can serve read traffic, improving performance. ### Why Other Options Are Not Optimal: **Option A**: - Requires manual setup and management of replication between EC2 instances - Higher operational overhead for monitoring, failover testing, and maintenance - No automated failover capabilities **Option B**: - Multi-AZ deployment provides high availability within a single region, not across regions - Read replicas in different Availability Zones are still within the same region - Doesn't address the multi-region DR requirement **Option D**: - Relies on scheduled backups, which means potential data loss between backup intervals - Manual restoration process required in DR Region - Higher RPO (Recovery Point Objective) and RTO (Recovery Time Objective) - Requires manual intervention for failover ### Key Considerations: - **RPO (Recovery Point Objective)**: Aurora Global Database provides near-zero RPO - **RTO (Recovery Time Objective)**: Fast promotion of secondary cluster (typically < 1 minute) - **Automation**: AWS manages replication, monitoring, and failover processes - **Cost**: While Aurora may have higher costs than self-managed solutions, it significantly reduces operational overhead This solution aligns with AWS best practices for disaster recovery across regions while minimizing operational complexity.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A solutions architect is designing a company's disaster recovery (DR) architecture. The company has a MySQL database that runs on an Amazon EC2 instance in a private subnet with scheduled backup. The DR design needs to include multiple AWS Regions. Which solution will meet these requirements with the LEAST operational overhead?
A
Migrate the MySQL database to multiple EC2 instances. Configure a standby EC2 instance in the DR Region. Turn on replication.
B
Migrate the MySQL database to Amazon RDS. Use a Multi-AZ deployment. Turn on read replication for the primary DB instance in the different Availability Zones.
C
Migrate the MySQL database to an Amazon Aurora global database. Host the primary DB cluster in the primary Region. Host the secondary DB cluster in the DR Region.
D
Store the scheduled backup of the MySQL database in an Amazon S3 bucket that is configured for S3 Cross-Region Replication (CCR). Use the data backup to restore the database in the DR Region.
No comments yet.