Question #1357
A solutions architect is designing a disaster recovery solution for a mission-critical application using Amazon Aurora MySQL. The solution must replicate data to a secondary AWS Region with minimal ongoing costs.
Which approach meets these requirements MOST effectively?
Configure MySQL binary replication to an Aurora cluster in the secondary Region, maintaining a single DB instance there.
Create an Aurora global database and delete the DB instance in the secondary Region after setup.
Use AWS DMS for continuous replication to the secondary Region and delete the secondary DB instance.
Deploy an Aurora global database with one DB instance in the secondary Region.
Explanation
Answer D is correct because Aurora Global Database provides built-in cross-region replication with low-latency data synchronization. Deploying one DB instance in the secondary Region ensures the replication process remains active and allows for quick failover during a disaster. This approach minimizes ongoing costs by only running a single instance in the secondary Region.
Option A is incorrect because MySQL binary replication requires manual setup and management, increasing complexity and costs. Option B is invalid because deleting the DB instance in the secondary Region would halt replication, as Aurora Global Database requires at least one active instance to maintain replication. Option C is suboptimal because AWS DMS incurs additional costs and requires continuous replication tasks, making it less cost-effective than Aurora's native replication.
Key Points:
- Aurora Global Database automates cross-region replication at the storage layer.
- A single DB instance in the secondary Region balances cost and readiness.
- Deleting instances (as in B) disrupts replication, while DMS (C) adds unnecessary complexity and cost.
Answer
The correct answer is: B