We performed some testing to understand scalability differences between AWS RDS for Aurora, MySQL 5.7 and Elastic 7.13.

  • RDS Aurora - overall not impressed, no control over I/O throughput, auto-scaling applies only to server hardware

  • Single-query performance of Aurora worse than MySql.

  • Single-query performance of MySql and Elastic similar

  • Elastic scalability better over MySql, nothing we didn't know 🙂

Data volume during this benchmark: 3 TB data volume @ 300-400Million Germain unit inserted per day