MENU
A company has an application that runs on Amazon EC2 instances. The application stores data on an Amazon RDS for MySQL Single-AZ DB instance. Requests to the DB instance from the application include reads and writes.
A CloudOps engineer must implement a solution that provides failover for the DB instance. The solution must minimize application downtime.
Which solution will meet these requirements?
For Amazon RDS for MySQL, a Multi-AZ DB instance deployment provides synchronous standby replication to another Availability Zone and supports automatic failover if the primary DB instance or Availability Zone fails. This directly meets the requirement for failover while minimizing application downtime. A read replica in the same Availability Zone does not provide the same automatic high-availability failover path and is mainly used for read scaling. Auto Scaling groups apply to EC2 instances, not RDS DB instances. RDS Proxy can improve application connection handling and failover behavior, but it does not by itself create a standby database for a Single-AZ instance. The database must first have a high-availability deployment. Therefore, modifying the DB instance to Multi-AZ is the correct reliability solution.
Currently there are no comments in this discussion, be the first to comment!