Disk I/O in Amazon RDS/EC2 instances
Amazon RDS/EC2 uses EBS volume for database and log storage. Depending on the size of storage requested , Amazon RDS automatically stripes across multiple EBS volumes to enhance IOPS performance.
Amazon EBS provides 3 volume types :
1. General Purpose (SSD) volumes
2. Provisioned IOPS (SSD) Volumes
3. Magnetic Volumes
Before we further discuss characteristics of each of these EBS volume, let us first take a look what IOPS are and how measurement take places for these.
What are IOPS:
IOPS are input and output operations per second. Amazon EBS measures each IO operation per second ( that is 256 kb or smaller) as one IOPS. I/O operations larger than 256KB are counted in 256KB units. For example 1024 KB I/O operation will be counted as 4 IOPS.
General Purpose (SSD) volumes:
General purpose (SSD) volumes offers cost effective storage that is ideal for a broad range of workloads. These volume can offer single digit millisecond latency , the ability to burst to 3000 IOPS for extended period of time. These volume can range from 1 GB to 16 TB.
General purpose (SSD) volume provide baseline performance of 3 IOPS/ GB and maximum of 10000 IOPS (3334 GB). Throughput of these volumes range in between of 128 MB/s to 160 MB/s.
Performance of general purpose (SSD) volume is governed by volume size. Higher the size , higher accumulation of I/O credits where I/O credits represent available bandwidth that General Purpose (SSD) volume can use to burst large I/O when more than baseline performance is required.
Provisioned IOPS (SSD) Volumes:
Provisioned IOPS (SSD) volumes are designed to meet the need of I/O intensive workloads , mainly database workloads that are very much sensitive to storage performance. Here while configuring (creating volume) provisioned IOPS (SSD) volume, we have to specify desired IOPS rate. These volume can range from 4 GB to 16 TB with a maximum throughput 320 MB/s. We can achieve maximum of 20000 IOPS with these volumes.
Magnetic Volume:
Magnetic volumes provide the lowest cost per gigabyte of all EBS volume types. Magnetic volumes are backed by magnetic drives and are ideal for workloads performing sequential reads, workloads where data is accessed infrequently, and scenarios where the lowest storage cost is important. These volumes deliver approximately 100 IOPS on average and they can range in size from 1 GB to 1 TB.
