An ecommerce company wants a disaster recovery solution for its Amazon RDS DB instances that run Microsoft SQL Server Enterprise Edition. The company's current recovery point objective (RPO) and recovery time objective (RTO) are 24 hours.
Which solution will meet these requirements MOST cost-effectively?
This solution is the most cost-effective and meets the RPO and RTO requirements of 24 hours.
Automatic Snapshots: Amazon RDS automatically creates snapshots of your DB instance at regular intervals. By copying these snapshots to another AWS Region every 24 hours, you ensure that you have a backup available in a different geographic location, providing disaster recovery capability.
RPO and RTO: Since the company's RPO and RTO are both 24 hours, copying snapshots daily to another Region is sufficient. In the event of a disaster, you can restore the DB instance from the most recent snapshot in the target Region.
Why Not Other Options?:
Option A (Cross-Region Read Replica): This could provide a faster recovery time but is more costly due to the ongoing replication and resource usage in another Region.
Option B (DMS Cross-Region Replication): While effective for continuous replication, it introduces complexity and cost that isn't necessary given the 24-hour RPO/RTO.
Option C (Cross-Region Native Backup Copy): This involves more manual steps and doesn't offer as straightforward a solution as automated snapshot copying.
AWS Reference:
Amazon RDS Automated Backups and Snapshots - Details on automated backups and snapshots in RDS.
Copying an Amazon RDS DB Snapshot - How to copy DB snapshots to another Region.
Mirta
26 days agoEleonore
4 days agoJustine
6 days agoThea
1 months agoJanna
1 months agoGayla
1 months agoGail
5 days agoDong
12 days agoRosendo
1 months agoMyra
1 months agoJose
11 days agoMarya
1 months agoRosendo
2 months ago