A company’s ordering application stores customer data in Amazon RDS for MySQL. During business hours, employees run one-off reporting queries that cause long-running reads and lead to timeouts during order processing. The company must eliminate the timeouts but still allow employees to run queries. What should a solutions architect do to meet these requirements?

Creating a read replica for Amazon RDS for MySQL is the most effective solution. Read replicas asynchronously replicate data from the primary instance, allowing read-heavy workloads like reporting queries to run on the replica without impacting the performance of the primary database used by the ordering application. This offloads the reporting queries, eliminating timeouts on the primary instance. Distributing the ordering application to both