A finance company is running its business-critical application on current-generation Linux EC2 instances. The application includes a self-managed MySQL database performing heavy I/O operations. The application is working fine to handle a moderate amount of traffic during the month. However, it slows down during the final three days of each month due to month-end reporting, even though the company is using Elastic Load Balancers and Auto Scaling within its infrastructure to meet the increased demand. Which of the following actions would allow the database to handle the month-end load with the LEAST impact on performance?
Select one answer.
Marked answer: B
Community Discussion
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Chose B1
Migrate to Amazon RDS + Add Read Replicas: This moves the workload to managed RDS, reducing operational burden. Adding read replicas offloads read/reporting queries from the primary. Can scale read replicas just for month-end (temporarily). Great match for reporting load (which is read-heavy). Minimal operational overhead — RDS handles patching, backups, etc.
1
B. Performing a one-time migration of the database cluster to Amazon RDS, and creating several additional read replicas to handle the load during end of month.
