A company is running a critical e-commerce platform that uses a single-instance Amazon RDS for PostgreSQL DB instance. During a recent infrastructure event in the primary Availability Zone, the database became unavailable, resulting in a three-hour outage while the operations team restored the database from a backup. To prevent a recurrence, a SysOps Administrator is tasked with implementing a highly available architecture that supports automatic, synchronous failover and also offloads read-heavy reporting queries. Which combination of actions should the SysOps Administrator take to meet these requirements? (Select TWO.)
- Modify the RDS DB instance to enable a Multi-AZ deployment.Answer
- Create an Amazon RDS Read Replica and configure the reporting application to use the Read Replica endpoint.Answer
- CConfigure an Amazon Route 53 active-passive failover routing policy to redirect write queries from the primary instance endpoint to the Read Replica endpoint.
- DEnable cross-Region replication on the primary DB instance to automate database failover to a standby DB instance in a secondary AWS Region.
Answer
Modify the RDS DB instance to enable a Multi-AZ deployment, and create an Amazon RDS Read Replica and configure the reporting application to use the Read Replica endpoint.
To achieve high availability with automatic, synchronous failover and zero data loss, a Multi-AZ deployment is required. Multi-AZ creates a synchronous standby instance in a different Availability Zone and automatically updates DNS records during a failover event. To offload read-heavy reporting queries, a separate Read Replica should be deployed, and the reporting application should connect to the replica's endpoint.
Step-by-Step Solution
Key Concept
AWS Database High Availability and Read Scaling
Estimated Time:2m 30s