Which solution meets these requirements?

By:
In: SAA-C02
Tagged:
With: 1 Comment
A company manages its own Amazon EC2 instances that run MySQL databases.The company is manually managing replication and scaling as demand increases or decreases.The company needs a new solution that simplifies the process of adding or removing compute capacity to or from its database tier as needed.The solution also must offer improved performance, scaling, and durability with minimal effort from operations.

Which solution meets these requirements?

Migrate the databases to Amazon Aurora Serverless for Aurora MySQL.

Migrate the databases to Amazon Aurora Serverless for Aurora PostgreSQL.

Combine the databases into one larger MySQL database. Run the larger database on larger EC2 instances.

Create an EC2 Auto Scaling group for the database tier. Migrate the existing databases to the new environment.

Explanations:

Amazon Aurora Serverless for Aurora MySQL automatically scales compute capacity based on demand, offering improved performance and durability with minimal management effort. It simplifies the process of handling varying workloads.

While Amazon Aurora Serverless for Aurora PostgreSQL also offers scalability and performance benefits, the requirement specifically mentions MySQL databases, making this option less suitable.

Combining databases into a larger MySQL database and running it on larger EC2 instances does not address the need for automated scaling and can lead to increased complexity in management.

Creating an EC2 Auto Scaling group for the database tier does not inherently provide the benefits of improved performance and durability that a managed service like Aurora Serverless offers. It still requires manual management of replication and scaling.

2025-09-28

1 Comment

  1. Albert
    Author

    I value that the answer is:
    Migrate the databases to Amazon Aurora Serverless for Aurora MySQL.

Leave a Reply

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

three × 1 =