Answer-first summary for fast verification
Answer: Migrate to Amazon Aurora MySQL, use Aurora Replicas with Auto Scaling.
The best solution is to migrate the database to Amazon Aurora MySQL and use Aurora Replicas with Auto Scaling. Aurora MySQL is designed for high availability and performance with minimal replication lag. Aurora Replicas can automatically scale based on load, providing better performance during peak times. This solution meets the requirements of minimizing changes to the application code and reducing ongoing operational overhead.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A web application on AWS uses Amazon RDS for MySQL with a primary DB instance and five read replicas. The requirement is to keep the read replicas lagging no more than 1 second behind the primary during peak loads. The solution must minimize code changes and operational overhead.
A
Migrate to Amazon Aurora MySQL, use Aurora Replicas with Auto Scaling.
B
Deploy Amazon ElastiCache for Redis, modify app to query cache first.
C
Move to MySQL on EC2, use large compute-optimized instances for replicas.
D
Switch to Amazon DynamoDB, set high RCUs with on-demand scaling.
No comments yet.