Amazon Aurora MySQL 5.7 Expands List of Supported Features to Improve Performance and Manageability

Posted on: Nov 22, 2019

Starting today, a number of Amazon Aurora features like invoking an AWS Lambda function synchronously, hot row contention, Backtrack, and hash joins, will now be available on the MySQL 5.7-compatible edition of Aurora to improve performance and manageability. The MySQL 5.7-compatible edition of Amazon Aurora already offers enhancements such as JSON support, spatial indexes, and generated columns. 

Synchronous Invocation of AWS Lambda Functions allows you to run code without thinking about servers by extending the capabilities of the Aurora MySQL database and invoking external applications to act upon data changes.

Hot row contention provides up to 16x throughput improvement in transactions per minute relative to MySQL 5.7 when there are many transactions contending for the rows on the same page.

Backtrack offers a quick way to recover from user errors, such as dropping the wrong table or deleting the wrong row, by allowing you to move your database to a prior point in time without needing to restore from a backup, and it completes within seconds, even for large databases.

Hash joins can improve query performance when you need to join a large amount of data by using an equijoin.

These features are generally available on Aurora MySQL engine release 2.06 and above and you can read the Aurora Documentation to learn more. You can create an Aurora MySQL 5.7 instance with just a few clicks in the Amazon RDS Management Console or download the latest AWS SDK or CLI. 

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better throughput than standard MySQL together with increased scalability, durability, and security.