Search code examples
amazon-web-servicesamazon-ec2rds

AWS EC2 vs RDS performance

I have an m4.10xlarge EC2 instance and a AWS RDS, both running MySQL 5.7 with same data.

I tried running a few complex queries (cross joins, nested select) on them, and found that the EC2 instance has consistently better performance (lower duration and fetch time).

Can I safely conclude the EC2 database, which has more CPUs, has better performance than RDS, which has Provisioned IOPS (SSD)?

RDS specs:

enter image description here

Solution

  • No. You cant conclude so. You should use equivalent specs in RDS too. Also,right configuration of the db parameter groups play a great role in giving the optimal perfomance output from RDS.

    1. You should use a better spec for your rds instance.
    2. Configure the parameter group variables to match the global variables of your Ec2 setup to get similar performance.