What is the MOST cost-effective solution?
Migrate the monthly reporting to Amazon Redshift.
Migrate the monthly reporting to an Aurora Replica.
Migrate the Aurora database to a larger instance class.
Increase the Provisioned IOPS on the Aurora instance.
Explanations:
Migrating to Amazon Redshift may improve performance for large reports, but it involves additional costs and complexity. It is not the most cost-effective immediate solution.
Using an Aurora Replica for reporting offloads the read workload from the primary instance, reducing spikes in ReadIOPS and CPU utilization while being a cost-effective option.
Migrating to a larger instance class improves performance but incurs higher costs without addressing the root cause of the spikes.
Increasing Provisioned IOPS may improve performance but is a more expensive option that doesn’t effectively separate reporting workloads from transaction workloads.
I appraise that the answer is:
Migrate the monthly reporting to an Aurora Replica.