Which solution will meet these requirements MOST cost-effectively?
Create a cross-Region read replica. Configure the reports to be generated from the read replica.
Activate Multi-AZ DB instance deployment for RDS for PostgreSQL. Configure the reports to be generated from the standby database.
Use AWS Data Migration Service (AWS DMS) to logically replicate data to a new database. Configure the reports to be generated from the new database.
Create a read replica in us-east-1. Configure the reports to be generated from the read replica.
Explanations:
Creating a cross-Region read replica would introduce latency and additional costs due to data transfer between regions. This solution does not address the performance issue in the current region effectively.
Activating Multi-AZ does not improve read performance since it is primarily for high availability. The standby instance is not used for read operations, which means reports would still generate load on the primary instance.
Using AWS DMS to replicate data to a new database involves additional complexity and cost. While it may help with performance, it is not the most straightforward or cost-effective solution compared to other options.
Creating a read replica in the same region (us-east-1) allows read operations (like report generation) to be offloaded from the primary database. This reduces load on the primary instance, improving performance cost-effectively.
From my point of view, the answer is:
Create a read replica in us-east-1. Configure the reports to be generated from the read replica.