Which solution will meet these requirements?
Create a read replica of the database. Direct the queries to the read replica.
Create a backup of the database. Restore the backup to another DB instance. Direct the queries to the new database.
Export the data to Amazon S3. Use Amazon Athena to query the S3 bucket.
Resize the DB instance to accommodate the additional workload.
Explanations:
Creating a read replica allows offloading read-heavy operations like reports from the primary DB instance. This helps maintain performance for daily workloads while enabling the reporting queries to run on the replica.
Restoring the backup to another DB instance does not address the need for regular report running. The backup-based solution is inefficient for monthly report performance and doesn’t handle the continuous load balance.
Exporting the data to S3 and using Amazon Athena to query it is an appropriate solution for analytics but does not meet the requirement of maintaining performance for the daily workloads on the MySQL database.
Resizing the DB instance could accommodate the additional workload temporarily, but it is not the most efficient or cost-effective solution for periodic reporting needs. This solution would likely be underutilized for the rest of the time.
As I see it, the answer is:
Create a read replica of the database. Direct the queries to the read replica.