Question #818
A company is using an Amazon Aurora MySQL DB cluster in the us-west-2 Region. The company needs to provide customers in the eu-central-1 Region with real-time read and write access to the same dataset as customers in the US. Customers in both Regions must be able to write to the database and see updates from the other Region immediately, without experiencing high latency or stale data.
Which solution will meet these requirements?
Create an RDS for MySQL read replica of the Aurora DB cluster in eu-central-1. Configure the replica to forward write queries to the primary DB cluster. Deploy the application in eu-central-1 and configure it to use the RDS for MySQL endpoint in eu-central-1.
Take a snapshot of the Aurora DB cluster in us-west-2 and copy it to eu-central-1. Restore the snapshot as a new Aurora DB cluster in eu-central-1. Set up bidirectional replication between the two DB clusters. Deploy the application in eu-central-1 and configure it to use the new Aurora DB cluster endpoint.
Add a cross-Region read replica in eu-central-1 for the Aurora DB cluster. Configure the application in eu-central-1 to use the read replica endpoint. Enable write forwarding on the primary DB cluster to allow writes from eu-central-1 to propagate back to us-west-2.
Add eu-central-1 as a secondary Region to the Aurora DB cluster. Enable write forwarding on the DB cluster. Deploy the application in eu-central-1 and configure it to use the Aurora MySQL endpoint in eu-central-1.
Explanation
Option D is correct because Aurora Global Database supports cross-Region replication with a primary Region and secondary Regions. Adding eu-central-1 as a secondary Region allows local read/write access via write forwarding, which routes writes to the primary Region (us-west-2). Aurora's storage-based replication ensures low-latency data synchronization (typically <1s), meeting the real-time requirement.
Other options are incorrect:
- A: RDS MySQL read replicas cannot replicate from Aurora, and read replicas are read-only.
- B: Bidirectional replication between Aurora clusters is not natively supported and risks data conflicts.
- C: Cross-Region read replicas with write forwarding introduce latency for writes, as updates must propagate back to the replica.
Key Points:
1. Aurora Global Database enables multi-Region access with write forwarding.
2. Secondary Regions provide low-latency reads and write forwarding to the primary.
3. Storage-based replication ensures near-real-time data consistency across Regions.
Answer
The correct answer is: D