A company is hosting a production web application on AWS that uses an Amazon RDS for MySQL DB instance. The database must be designed to survive the failure of a single Availability Zone (AZ) with minimal downtime and automatic failover. Additionally, the application requires read scaling to handle a high volume of reporting queries.
Which combination of configurations should a solutions architect implement to meet these requirements? (Select TWO.)
- Deploy the RDS DB instance in a Multi-AZ configurationAnswer
- Create one or more RDS Read Replicas for the databaseAnswer
- CConfigure an RDS Read Replica in a different Availability Zone to act as the primary automatic failover target
- DConfigure an Amazon Route 53 latency routing policy to load balance write requests between the primary DB instance and its replica
- EDeploy a second standalone RDS DB instance in a different Availability Zone as a pilot light database and run a daily script to sync the data
Answer
Deploy the RDS DB instance in a Multi-AZ configuration and create one or more RDS Read Replicas for the database.
To achieve high availability and automatic failover, the RDS instance should be deployed in a Multi-AZ configuration. To scale read traffic, one or more Read Replicas should be created.
Step-by-Step Solution
Key Concept
High availability is achieved through Multi-AZ deployments, while read performance is scaled through Read Replicas.