Amazon RDS Aurora MySQL – Differences Among Editions

differences MySQL aurora versionsAmazon Aurora with MySQL Compatibility comes in three editions which, at the time of writing, have quite a few differences around the features that they support.  Make sure you don’t assume the newer Aurora 2.x supports everything in Aurora 1.x. On the contrary, right now Aurora 1.x (MySQL 5.6 based) supports most Aurora features.  The serverless option was launched for this version, and it’s not based on the latest MySQL 5.7.  However, the serverless option, too, has its own set of limitations

I found a concise comparison of what is available in which Amazon Aurora edition hard to come by so I’ve created one.  The table was compiled based mostly on documentation research, so if you spot some mistakes please let me know and I’ll make a correction.

Please keep in mind, this is expected to change over time. For example Amazon Aurora 2.x was initially released without Performance_Schema support, which was enabled in later versions.

There seems to be lag porting Aurora features from MySQL 5.6 compatible to MySQL 5.7 compatible –  the current 2.x release does not include features introduced in Aurora 1.16 or later as per this document

A comparison table

MySQL 5.6 BasedMySQL 5.7 BasedServerless MySQL 5.6 Based
Compatible to MySQL MySQL 5.6.10aMySQL 5.7.12 MySQL 5.6.10a
Aurora Engine Version1.18.02.03.011.18.0
Parallel Query YesNoNo
BacktrackYesNoNo
Aurora Global DatabaseYes NoNo
Performance InsightsYesNoNo
SELECT INTO OUTFILE S3YesYesYes
Amazon Lambda – Native FunctionYesNoNo
Amazon Lambda – Stored ProcedureYesYesYes
Hash Joins YesNoYes
Fast DDL YesYesYes
LOAD DATA FROM S3YesYesNo
Spatial Indexing YesYesYes
Asynchronous Key Prefetch (AKP)YesNoYes
Scan BatchingYesNoYes
S3 Backed Based MigrationYesNoNo
Advanced Auditing YesYesNo
Aurora ReplicasYesYesNo
Database CloningYesYesNo
IAM database authenticationYesYesNo
Cross-Region Read ReplicasYesYesNo
Restoring Snapshot from MySQL DBYesYesNo
Enhanced MonitoringYesYesNo
Log Export to CloudwatchYesYesNo
Minor Version Upgrade ControlYesYesAlways On
Data Encryption ConfigurationYesYesAlways On
Maintenance Window ConfigurationYesYesNo

Hope this is helps with selecting which Amazon Aurora edition is right for you, when it comes to supported features.


Photo by Nathan Dumlao on Unsplash

Share this post

Comments (6)

  • Soenke Reply

    Great article, thx!
    AFAIR I seems invoking Lambda is not available in Serverless Aurora according to the docs: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.limitations, so you might want to fix this in your overview.

    January 4, 2019 at 11:24 am
    • Soenke Reply

      Sorry, I was wrong. You can delete my comment. Sorry again for the noise.

      January 4, 2019 at 11:26 am
    • Soenke Reply

      Sorry, I was mistaken. You can delete my comment above.

      January 4, 2019 at 11:27 am
    • Peter Zaitsev Reply

      No worries. Indeed it was not easy to understand what kind of Lambda invocation is available in which edition.

      January 4, 2019 at 7:50 pm
  • Eric Peterson Reply

    This was compared to v.2.03.1, the current version is v.2.09.0. Would this change any of your “no” values above (i.e. Hash Joins, etc) to “yes”?

    October 14, 2020 at 2:05 pm
    • peterzaitsev Reply

      I have not looked at it recently. I mention version exactly as things are likely to change 🙂

      October 14, 2020 at 5:14 pm

Leave a Reply