EBS Volume Types for Oracle Database Migration: Best Practices

Best EBS Volume Type for Migrating Oracle Database

Question

A solutions architect is migrating an enterprise Oracle database to EBS backed EC2 instances requiring 10,000 IOPS.

Which EBS volume type would be appropriate for this scenario?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Answer: A.

Option A is CORRECT because gp2 volume type provides max IOPS of 16,000.

Option B is incorrect because gp2 volume type is the more appropriate option.

Option C is incorrect because st1 volume type provides 500 max IOPS performance.

Option D is incorrect because sc1 volume type provides 250 max IOPS performance.

Reference:

https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-volume-types.html

In this scenario, the enterprise Oracle database requires 10,000 IOPS for EBS backed EC2 instances. This requirement rules out the use of the gp2, st1, and sc1 EBS volume types since they do not provide the required IOPS.

The appropriate EBS volume type for this scenario is io1. The io1 volume type is designed for applications with high I/O requirements, such as databases, that require predictable and consistent performance. It provides high performance for mission-critical workloads by allowing you to provision a specific level of IOPS for your volume.

When creating an io1 volume, you can provision the desired number of IOPS (up to a maximum of 64,000 IOPS) and set the volume size (up to a maximum of 16 TiB). The cost of the io1 volume type is higher than the other EBS volume types due to its high performance and reliability.

In summary, the appropriate EBS volume type for migrating an enterprise Oracle database to EBS backed EC2 instances requiring 10,000 IOPS is io1.