There are a lot of blog posts on the internet which warn you about using the Query Cache in MySQL.
I was surprised to see that the query cache was enabled in Aurora.
This was the size on a ‘db.r3.large’ instance.
On a ‘db.r3.2xlarge’ instance, it was set to 2460900352 i.e. 2.4GB
I am not sure, if amazon has done something to improve the query cache.
So, do run tests with Aurora and see if the cache suits you.