Which solution will remediate the errors MOST cost-effectively?

By:
In: SAP-C01
Tagged:
With: 1 Comment
A greeting card company recently advertised that customers could send cards to their favorite celebrities through the company’s platform.Since the advertisement was published, the platform has received constant traffic from 10,000 unique users each second.The platform runs on m5.xlarge Amazon EC2 instances behind an Application Load Balancer (ALB).The instances run in an Auto Scaling group and use a customAMI that is based on Amazon Linux.The platform uses a highly available Amazon Aurora MySQL DB cluster that uses primary and reader endpoints.The platform also uses an Amazon ElastiCache for Redis cluster that uses its cluster endpoint.The platform generates a new process for each customer and holds open database connections to MySQL for the duration of each customer’s session.However, resource usage for the platform is low.Many customers are reporting errors when they connect to the platform.Logs show that connections to the Aurora database are failing.Amazon CloudWatch metrics show that the CPU load is low across the platform and that connections to the platform are successful through the ALB.

Which solution will remediate the errors MOST cost-effectively?

Set up an Amazon CloudFront distribution. Set the ALB as the origin. Move all customer traffic to the CloudFront distribution endpoint.

Use Amazon RDS Proxy. Reconfigure the database connections to use the proxy.

Increase the number of reader nodes in the Aurora MySQL cluster.

Increase the number of nodes in the ElastiCache for Redis cluster.

Explanations:

Adding CloudFront distribution may improve latency and caching for static content, but it will not address the Aurora database connection issue.

RDS Proxy manages database connections efficiently, pooling and reusing connections to Aurora MySQL, which can help handle high connection demands cost-effectively.

Increasing reader nodes can improve read scalability, but this does not directly address the issue of too many open database connections.

Adding more Redis nodes does not resolve database connection limits with Aurora MySQL, as Redis is not the source of the connection errors.

2025-10-13

1 Comment

  1. Janet
    Author

    From what I’ve seen, the answer is:
    Use Amazon RDS Proxy. Reconfigure the database connections to use the proxy.

Leave a Reply

Your email address will not be published. Required fields are marked *

1 × 3 =