Which type of RDS instance has the best IO: Extra large database instance or Extra large high memory instance

Question

I am getting IO performance issues using Amazon RDS using mysql 5.5.12. There are two types of instances that are similar and close in price:

Extra large database instance: 15 GB of memory, 8 ECUs (4 virtual cores with 2 ECUs each), 64-bit platform, high I / O capacity (only for MySQL DB Engine) ($ 0.88 per hour)

High memory capacity 17.1 GB, 6.5 ECUs (2 virtual cores with 3.25 ECUs), 64-bit platform, high I / O capacity ($ 0.65 per hour)

Does anyone know if an extra-large database has a faster IO than an extra large instance with high memory?

Answer 1

m1.xlarge instances (the mentioned 64-bit / 15 GB) get a network adapter for themselves and therefore have better network performance (and therefore EBS). With alternation, you can withstand 1,500 iops, unlike the standard 100 iops.

When used in RDS, you will see the highest iops values, setting the size of your storage to at least 300 GB, which will lead to alternation of the barcode.

If you need more RAM or CPU, only the instance types c1.xlarge and m2.4xlarge have a full network adapter for themselves - they would also need a 300 GB memory allocation to use it.