QuestionQ49

VerifiedDesign Cost-Optimized Architectures

An ecommerce application uses a PostgreSQL database that runs on an Amazon EC2 instance. During a monthly sales event, database usage increases and causes database connection issues for the application. Traffic is unpredictable for future monthly sales events, which affects the sales forecast.

The company needs to maintain performance when traffic increases unpredictably.

Which solution resolves this issue in the MOST cost-effective way?

Explanation

Amazon Aurora Serverless v2 is designed for applications with variable or unpredictable workloads and can automatically scale compute and memory capacity up during traffic spikes and back down afterward. AWS documentation specifically cites ecommerce sales or promotional surges as a use case and notes that you pay only for the database resources consumed, which avoids the overprovisioning required by a larger fixed RDS instance. Amazon Redshift is intended for analytics/data warehousing rather than OLTP ecommerce transactions, and keeping PostgreSQL on EC2 does not provide the same managed, automatic database scaling behavior.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!