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.
Parallel Query YesNoNo
Aurora Global DatabaseYes NoNo
Performance InsightsYesNoNo
Amazon Lambda – Native FunctionYesNoNo
Amazon Lambda – Stored ProcedureYesYesYes
Hash Joins YesNoYes
Fast DDL YesYesYes
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 (4)

Leave a Reply