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.
Florinda
9 months agoJolanda
9 months agoSherron
10 months agoIsaiah
10 months agoEvangelina
10 months agoSharika
10 months agoDenny
11 months agoCornell
11 months agoValentin
11 months agoLoreta
11 months agoKirk
11 months agoErnest
11 months agoShanice
11 months agoDona
11 months agoJacquline
11 months agoMirta
2 years agoMerilyn
2 years agoEleonore
2 years agoJustine
2 years agoThea
2 years agoJanna
2 years agoGayla
2 years agoTalia
2 years agoGail
2 years agoDong
2 years agoRosendo
2 years agoMyra
2 years agoVerda
2 years agoBenton
2 years agoEllsworth
2 years agoJose
2 years agoMarya
2 years agoRosendo
2 years ago