An e-commerce platform has deployed its application in AWS. The backend uses Amazon RDS for MySQL with one primary instance and five read replicas to handle read-heavy traffic. Business requirements dictate that read replicas must not fall more than 1 second behind the primary. The system uses stored procedures that execute on a regular schedule. As web traffic increases, replication lag worsens during peak hours. A solutions architect needs to reduce the lag as much as possible without introducing significant changes to the application or increasing ongoing maintenance effort. What is the best way to achieve this?