A company plans to migrate a MySQL-based application from an on-premises environment to AWS. The application performs database joins across several tables and uses indexes for faster query response times. The company needs the database to be highly available with automatic failover. Which solution on AWS will meet these requirements with the LEAST operational overhead?

Question

Accepted Answer

B. Deploy an Amazon RDS Multi-AZ DB instance. An Amazon RDS Multi-AZ DB instance provides synchronous replication to a standby instance in a different Availability Zone and offers automatic failover, ensuring high availability with the least operational overhead since AWS manages the failover process.

Answer

A. Deploy an Amazon RDS DB instance with a read replica. Deploying an Amazon RDS DB instance with a read replica provides read scaling, but failover to a read replica is typically a manual process or requires custom automation, not automatic failover for the primary.

Answer

C. Deploy Amazon DynamoDB global tables. Amazon DynamoDB is a NoSQL database and does not support traditional relational database joins or indexes, making it unsuitable for migrating a MySQL-based application that relies on these features.

Answer

D. Deploy multiple Amazon RDS DB instances. Use Amazon Route 53 DNS with failover health Deploying multiple Amazon RDS DB instances with Amazon Route 53 DNS failover requires more manual configuration and operational overhead for replication and failover management compared to a fully managed RDS Multi-AZ setup.

A company plans to migrate a MySQL-based application from an on-premises environment to AWS. The application performs database joins across several tables and uses indexes for faster query response ti

Question

Options

How the community answered

Why each option

Topics

Community Discussion