AWS Certified Advanced Networking - Specialty: Ensuring Baseline Performance and Low Latency for MySQL Database on EC2 Instance

How to Ensure Baseline Performance and Low Latency for MySQL Database on EC2 Instance

Prev Question Next Question

Question

Your team is planning to host an application in AWS.

This application will be using a MySQL database hosted on an EC2 Instance.

It is anticipated that the disk performance might take a hit due to the high Input/Output activity.

How can you ensure baseline performance with low latency for the database tier?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

To ensure baseline performance with low latency for the MySQL database hosted on an EC2 Instance, you should use EBS Provisioned IOPS volumes.

Explanation:

A) Enhanced Networking provides higher packet per second (PPS) performance, lower network jitter, and lower latencies, but it won't help with disk performance. C) EFS is a shared network file system, and it is not optimized for databases. Using EFS for database storage can result in latency and performance issues. D) Amazon S3 is an object storage service and is not suitable for hosting databases due to its eventual consistency model, which means that data may take some time to propagate across the system, leading to inconsistent database reads.

B) EBS Provisioned IOPS volumes are designed to deliver predictable, high performance for I/O intensive workloads such as database applications. With Provisioned IOPS volumes, you can specify the amount of IOPS you need, and Amazon will ensure that you get that level of performance consistently. You can attach EBS volumes to EC2 instances, and you can choose between different volume types based on your requirements. In this case, Provisioned IOPS volumes will ensure that the disk performance of the MySQL database is optimized and predictable, providing a low latency experience.

Therefore, the correct answer is B) Ensure to use EBS Provisioned IOPS volumes.