Which solution resolves this issue in the MOST cost-effective way?
Migrate the PostgreSQL database to Amazon Aurora Serverless v2.
Enable auto scaling for the PostgreSQL database on the EC2 instance to accommodate increased usage.
Migrate the PostgreSQL database to Amazon RDS for PostgreSQL with a larger instance type.
Migrate the PostgreSQL database to Amazon Redshift to accommodate increased usage.
Explanations:
Amazon Aurora Serverless v2 is designed for unpredictable workloads. It scales automatically in response to demand, making it both cost-effective and suitable for handling traffic spikes during sales events.
PostgreSQL on an EC2 instance does not support direct auto-scaling. Scaling an EC2-based database requires manual intervention and might lead to downtime, making it less effective and cost-efficient for unpredictable traffic.
Migrating to Amazon RDS with a larger instance type can handle higher loads but may be costlier than serverless options. It also lacks the flexibility to scale back down when traffic decreases, leading to potentially higher costs during off-peak times.
Amazon Redshift is optimized for data warehousing, not for transactional workloads typical of an e-commerce application. This option is unsuitable for handling unpredictable, high-traffic transactional events like sales.
I evaluate that the answer is:
Migrate the PostgreSQL database to Amazon Aurora Serverless v2.