Question #1248
A company operates its own Amazon EC2 instances hosting PostgreSQL databases, manually handling replication and scaling during demand fluctuations. The company requires a solution that automates the process of adjusting compute capacity in the database tier while enhancing performance, scalability, and durability with minimal operational involvement. Which solution best addresses these requirements?
Migrate the databases to Amazon Aurora Serverless for Aurora MySQL.
Migrate the databases to Amazon Aurora Serverless for Aurora PostgreSQL.
Merge the databases into a single larger PostgreSQL instance hosted on a more powerful EC2 instance.
Deploy an EC2 Auto Scaling group for the database tier and migrate the existing databases to this setup.
Explanation
Answer B is correct because Amazon Aurora Serverless (PostgreSQL-compatible) provides automated scaling of compute capacity based on application demand, eliminating manual intervention. It offers high performance through a distributed, fault-tolerant storage system and built-in replication across Availability Zones, enhancing durability. Aurora Serverless also reduces operational overhead by managing provisioning, patching, and backups.
Option A is incorrect because migrating to Aurora MySQL changes the database engine, which may require application modifications. Option C (merging into a single EC2 instance) does not address scalability or durability, as vertical scaling lacks elasticity and introduces single-point failure risks. Option D (EC2 Auto Scaling) is unsuitable for stateful databases like PostgreSQL, as Auto Scaling groups are designed for stateless workloads and do not automate database replication or failover.
Answer
The correct answer is: B