Question

A company currently has an application which consist of a .Net layer which connects to a MySQL database. They now want to move this application onto AWS. They want to make use of all AWS features such as high availability and automated backups. Which of the following would be an ideal database in AWS to migrate to for this requirement.

C. An EC2 instance with MySQL installed.
A. Aurora
D. An EC2 instance with Aurora installed.
B. DynamoDB

Answer 1

The ideal AWS database service for migrating an application that uses a .Net layer and MySQL is Amazon Aurora, due to its compatibility, high availability, and automated backups features.

Step-by-step explanation:

If a company currently has an application with a .Net layer which connects to a MySQL database and wishes to move this application onto AWS to make use of features like high availability and automated backups, the ideal database service to migrate to would be Amazon Aurora. Amazon Aurora is a MySQL and PostgreSQL compatible relational database that offers greater reliability, durability, and performance as well as seamless integration with other AWS services. Aurora provides the high availability with replicas across multiple AZs and automated backups, recovery, and patching with no need for manual intervention. In contrast, using an EC2 instance with MySQL or Aurora installed would require more maintenance and does not automatically provide the same level of high availability and backup features. DynamoDB is also a valuable AWS service, but it is a NoSQL database that would require changes to the application code which was originally designed to interface with MySQL.