A SysOps Administrator is configuring a production database environment for a MySQL application on Amazon RDS. The database must be highly available with automatic failover support in the event of an Availability Zone outage. Additionally, the administrator must offload high-volume read traffic to reduce the load on the primary database instance. Which combination of actions should the SysOps Administrator take to meet these requirements? (Select TWO.)
- Modify the RDS DB instance to be a Multi-AZ deployment to enable synchronous replication and automated failover.Answer
- Create an RDS Read Replica and update the application configuration to route read queries to the Read Replica endpoint.Answer
- CConfigure an Amazon Route 53 DNS failover routing policy to redirect database write traffic to an RDS Read Replica endpoint if the primary instance becomes unavailable.
- DConfigure the application to route read queries to the private IP address of the standby DB instance in the Multi-AZ deployment.
Answer
To meet the high availability and read performance requirements, the SysOps Administrator must modify the RDS DB instance to be a Multi-AZ deployment and create an RDS Read Replica to offload read queries to its endpoint.
The correct actions are to modify the RDS DB instance to be a Multi-AZ deployment and create an RDS Read Replica. A Multi-AZ deployment provides high availability and automatic failover by maintaining a synchronous standby instance in a different Availability Zone. The failover is managed by AWS changing the DNS record to point to the standby. Creating a Read Replica allows you to offload read queries to a separate database endpoint, reducing the read load on the primary DB instance.
Step-by-Step Solution
Key Concept
Distinguishing between RDS Multi-AZ deployments for high availability/automated failover and RDS Read Replicas for read scalability.