SAP-C02 · Question #222
A company is running a critical application that uses an Amazon RDS for MySQL database to store data. The RDS DB instance is deployed in Multi-AZ mode. A recent RDS database failover test caused a…
The correct answer is C. Use RDS Proxy in front of the database D. Migrate the database to Amazon Aurora MySQL E. Create an Amazon Aurora Replica. RDS Proxy with Aurora are the best combination for less than "20 sec" failover time. According to this article RDS Proxy can reduce the failover time of Aurora by 79% while it can reduce RDS failover time by only 32%…
Question
A company is running a critical application that uses an Amazon RDS for MySQL database to store data. The RDS DB instance is deployed in Multi-AZ mode. A recent RDS database failover test caused a 40-second outage to the application. A solutions architect needs to design a solution to reduce the outage time to less than 20 seconds. Which combination of steps should the solutions architect take to meet these requirements? (Choose three.)
Options
- AUse Amazon ElastiCache for Memcached in front of the database
- BUse Amazon ElastiCache for Redis in front of the database.
- CUse RDS Proxy in front of the database
- DMigrate the database to Amazon Aurora MySQL
- ECreate an Amazon Aurora Replica
- FCreate an RDS for MySQL read replica
How the community answered
(42 responses)- A19% (8)
- B12% (5)
- C64% (27)
- F5% (2)
Explanation
RDS Proxy with Aurora are the best combination for less than "20 sec" failover time. According to this article RDS Proxy can reduce the failover time of Aurora by 79% while it can reduce RDS failover time by only 32%: https://aws.amazon.com/blogs/database/improving-application-availability-with-amazon-rds-
Community Discussion
No community discussion yet for this question.