QuestionQ48

Reliability and Business Continuity

A company must deploy a MySQL database on AWS to support an application. The database must be highly available and recoverable, and it must meet the following objectives:

  • A recovery time objective (RTO) of 15 minutes
  • A recovery point objective (RPO) of 5 minutes

Which solution will satisfy these requirements in the MOST operationally effective way?

Explanation

An Amazon RDS Multi-AZ deployment maintains a standby replica in another Availability Zone and automatically fails over during an infrastructure outage; typical failover time is 60–120 seconds, satisfying a 15-minute RTO. Amazon RDS point-in-time recovery uses automated backups and transaction logs that RDS uploads every five minutes, supporting a 5-minute RPO. Because RDS manages replication, failover, backups, and recovery, it is more operationally effective than self-managed database replication and EBS snapshots on Amazon EC2.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!