April 15, 2024
Voiced by Polly

March 7, 2024: Submit up to date to vary GB to GiB.

March 8, 2024: Submit up to date to mirror right area availability.

At present, I’m happy to announce the provision of Provisioned IOPS (PIOPS) io2 Block Specific storage volumes for all database engines in Amazon Relational Database Service (Amazon RDS). Amazon RDS supplies you the flexibleness to decide on between totally different storage varieties relying on the efficiency necessities of your database workload. io2 Block Specific volumes are designed for vital database workloads that require excessive efficiency and excessive throughput at low latency.

Decrease latency and better availability for I/O intensive workloads
With io2 Block Specific volumes, your database workloads will profit from constant sub-millisecond latency, enhanced sturdiness to 99.999 % over io1 volumes, and drive 20x extra IOPS/GiB from provisioned storage (as much as 1,000 IOPS per GiB) on the similar value as io1. You’ll be able to improve from io1 volumes to io2 Block Specific volumes with none downtime, considerably enhancing the efficiency and reliability of your functions with out growing storage price.

“We migrated all of our main Amazon RDS situations to io2 Block Specific inside 2 weeks,” stated Samir Goel, Director of Engineering at Figma, a number one platform for groups that design and construct digital merchandise. “Io2 Block Specific has had a profound impression on the provision of the database layer at Figma. We have now deeply appreciated the consistency of efficiency with io2 Block Specific — in our observations, the latency variability has been underneath 0.1ms.”

io2 Block Specific volumes help as much as 64 TiB of storage, as much as 256,000 Provisioned IOPS, and a most throughput of 4,000 MiB/s. The throughput of io2 Block Specific volumes varies based mostly on the quantity of provisioned IOPS and quantity storage measurement. Right here is the vary for every database engine and storage measurement:

Database engine Storage measurement Provisioned IOPS Most throughput
Db2, MariaDB, MySQL, and PostgreSQL Between 100 and 65,536 GiB 1,000–256,000 IOPS 4,000 MiB/s
Oracle Between 100 and 199 GiB 1,000–199,000 IOPS 4,000 MiB/s
Oracle Between 200 and 65,536 GiB 1,000–256,000 IOPS 4,000 MiB/s
SQL Server Between 20 and 16,384 GiB 1,000–64,000 IOPS 4,000 MiB/s

Getting began with io2 Block Specific in Amazon RDS
You need to use the Amazon RDS console to create a brand new RDS occasion configured with an io2 Block Specific quantity or modify an current occasion with io1, gp2, or gp3 volumes.

Right here’s how you’ll create an Amazon RDS for PostgreSQL occasion with io2 Block Specific quantity.

Begin with the essential data resembling engine and model. Then, select Provisioned IOPS SDD (io2) from the Storage kind choices:

Use the next AWS CLI command to create a brand new RDS occasion with io2 Block Specific quantity:

aws rds create-db-instance --storage-type io2 --db-instance-identifier new-db-instance --db-instance-class db.t4g.massive --engine mysql --master-username masteruser --master-user-password <enter password> --allocated-storage 400 --iops 3000

Equally, to change an current RDS occasion to make use of io2 Block Specific quantity:

aws rds modify-db-instance --db-instance-identifier existing-db-instance --storage-type io2 --allocated-storage 500 --iops 3000 --apply-immediately

Issues to know

  • io2 Block Specific volumes can be found on all RDS databases utilizing AWS Nitro System situations.
  • io2 Block Specific volumes help an IOPS to allotted storage ratio of 1000:1. For instance, With an RDS for PostgreSQL occasion, the utmost IOPS may be provisioned with volumes 256 GiB and bigger (1,000 IOPS × 256 GiB = 256,000 IOPS).
  • For DB situations not based mostly on the AWS Nitro System, the ratio of IOPS to allotted storage is 500:1. On this case, most IOPS may be achieved with 512 GiB quantity (500 IOPS x 512 GiB = 256,000 IOPS).

Obtainable now
Amazon RDS io2 Block Specific storage volumes are supported for all RDS database engines and can be found in US East (Ohio, N. Virginia), US West (N. California, Oregon), Asia Pacific (Hong Kong, Mumbai, Seoul, Singapore, Sydney, Tokyo), Canada (Central), Europe (Frankfurt, Eire, London, Stockholm), and Center East (Bahrain) Areas.

By way of pricing and billing, io1 volumes and io2 Block Specific storage volumes are billed on the similar charge. For extra data, see the Amazon RDS pricing web page.

Be taught extra by studying about Provisioned IOPS SSD storage within the Amazon RDS Consumer Information.

Abhishek