Surprised to see AWS Aurora *slower* than RDS
Old DB: t2.medium RDS AZ
New DB: Aurora r3.large
For example, a representative set of SELECT queries run against both DBs:
$ time rds-db < perf_test.sql
real 0m34.502s
$ time aurora-db < perf_test.sql
real 0m42.240s
=========
We got a reply from AWS support person who contacted Aurora Tech team on our behalf. I include his reply, relevant if you're seeing similar degradation of performance. In a nutshell, single queries are _expected_ to be slower on Aurora. Aurora will scale better with concurrency.
"Nice talking on the phone with you! I have talked to RDS team about your issue with performance after switching to RDS Aurora.
The RDS team pointed out that Aurora’s performance will not be better than MySQL if the concurrency features are not used or if you are using Aurora as a traditional MySQL. They said Aurora will be highly beneficial if your work load is highly concurrent.
Aurora though should have 5x more throughput than RDS MySQL but only when the work load is used efficiently as it works well with multiple concurrent queries."