Firstly take a look at this recent AWS April 2016 Webinar Series – Migrating your Databases to Aurora and the AWS June 2016 Webinar Series – Amazon Aurora Deep Dive – Optimizing Database Performance session lead by Puneet Agarwal
Here are the main reasons I would look into for choosing AWS Aurora over AWS RDS MySQL
- Faster recovery from instance failure (X5 times or more vs. MySQL)
- Consistent lower impact on the Primary replica
- Need additional throughput (theoretically X5 times for the same resources vs. MySQL). This was achieved by decoupling the cache and storage sub-systems and spreading them across many nodes as well as performing log commit first while DB manipulation is done asynchronously.
- Using or can migrate to MySQL 5.6
- Comfortable with the Aurora I/O mechanism (16K for read, 4K for write, all can be batched if smaller)
- Get more replicas (maximum of 15 vs. 5 in MySQL)
- Prioritise recovery replica targets and set replicas with different size than the master
- Need virtually no replication lag – since replica nodes share the same storage as the master uses
- Able to decide about encryption at rest, at DB creation
- Accept working with the InnoDB engine alone
- Want to eliminate the need for cache warming
- Allow additional 20% pricing over MySQL to gain all the above 🙂