Which solution will meet these requirements?

An application team uses an Amazon Aurora MySQL DB cluster with one Aurora Replica. The application team notices that the application read performance degrades when user connections exceed 200. The number of user connections is typically consistent around 180. with occasional sudden increases above 200 connections. The application team wants the application to automatically scale as user demand increases or decreases.

Which solution will meet these requirements?
A . Migrate to a new Aurora multi-master DB cluster. Modify the application database connection string.
B . Modify the DB cluster by changing to serverless mode whenever user connections exceed 200.
C . Create an auto scaling policy with a target metric of 195 DatabaseConnections
D . Modify the DB cluster by increasing the Aurora Replica instance size.

View Answer

Answer: C

Explanation:

Step-by-Step

Understand the Problem:

The application read performance degrades when user connections exceed 200.

Need to automatically scale the database based on user demand.

Analyze the Requirements:

Implement auto scaling based on user connections to ensure optimal performance.

Evaluate the Options:

Option A: Migrate to a new Aurora multi-master DB cluster.

Multi-master clusters provide read and write scalability but may require significant changes to the application.

Option B: Modify the DB cluster to serverless mode.

Aurora Serverless provides automatic scaling, but it is more suitable for variable workloads with unpredictable demand.

Option C: Create an auto scaling policy with a target metric of 195 DatabaseConnections.

This directly addresses the need to scale based on user connections.

Auto scaling can add or remove replicas to maintain optimal performance.

Option D: Increase the Aurora Replica instance size.

This may improve performance but does not address scalability for sudden increases in user connections.

Select the Best Solution:

Option C: Creating an auto scaling policy with a target metric of 195 DatabaseConnections ensures the DB cluster scales automatically to handle increased load.

Reference: Amazon Aurora Auto Scaling

Scaling Aurora DB Instances

Auto scaling based on DatabaseConnections ensures the Aurora DB cluster maintains optimal performance as user demand fluctuates.