0
votes

We have existing data in on-premise mysql version 5.7 and planning to move application and database on AWS. we provisioned one RDS Mysql database and one Aurora Mysql db and connect application to both server. we saved execution timing in database so we found that RDS MySql is running 2times fast rather then Aurora database. AWS claim that performance of Aurora database is 5 times faster then RDS Mysql, but it seems this is not correct. Please suggest is there any tuning required with Aurora db.

System configuration for both DB: db.r6g.large (2CPU and 16 GB RAM)

Note : refer db column prodQueryTime as 'Mysql performance time' and experimentQueryTime as 'Aurora DB performance time' Query stats

1
The only useful benchmark is your application. And it may be 2x or 5x or some other multiple or fraction.Rick James

1 Answers

2
votes

There are many similar reports like yours, e.g. here. And the answer is that it depends what you do. AWS rep writes:

The most important aspect to keep in mind is that Aurora is optimized for concurrent workloads and its benefits are best evaluated by running parallel benchmarks.