Aurora MySQL database engine updates 2022-04-20 (version 3.02.0, compatible with MySQL 8.0.23) The end of standard support is January 15, 2024. Upgrades to this version aren't supported. - Amazon Aurora
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Aurora MySQL database engine updates 2022-04-20 (version 3.02.0, compatible with MySQL 8.0.23) The end of standard support is January 15, 2024. Upgrades to this version aren't supported.

Version: 3.02.0

Aurora MySQL 3.02.0 is generally available. Aurora MySQL 3.02 versions are compatible with MySQL 8.0.23, Aurora MySQL 2.x versions are compatible with MySQL 5.7, and Aurora MySQL 1.x versions are compatible with MySQL 5.6.

For details of new features in Aurora MySQL version 3 and differences between Aurora MySQL version 3 and Aurora MySQL version 2 or community MySQL 8.0, see Comparison of Aurora MySQL version 2 and Aurora MySQL version 3 in the Amazon Aurora User Guide.

Currently supported Aurora MySQL releases are 1.19.5, 1.19.6, 1.22.*, 1.23.*, 2.04.*, 2.07.*, 2.08.*, 2.09.*, 2.10.*, 3.01.* and 3.02.*.

You can restore a snapshot from any currently supported Aurora MySQL version 2 cluster into Aurora MySQL 3.02.0.

For information on planning an upgrade to Aurora MySQL version 3, see Upgrade planning for Aurora MySQL version 3 in the Amazon Aurora User Guide. For the upgrade procedure itself, see Upgrading to Aurora MySQL version 3 in the Amazon Aurora User Guide. For general information about Aurora MySQL upgrades, see Upgrading Amazon Aurora MySQL DB clusters in the Amazon Aurora User Guide.

For troubleshooting information, see Troubleshooting upgrade issues with Aurora MySQL version 3.

If you have any questions or concerns, Amazon Support is available on the community forums and through Amazon Support. For more information, see Maintaining an Amazon Aurora DB cluster in the Amazon Aurora User Guide.

Improvements

Aurora MySQL version 3.02.0 is generally available and generally compatible with community MySQL 8.0.23.

Fixed security issues and CVEs listed below:

Fixes and other enhancements to fine-tune handling in a managed environment. Additional CVE fixes below:

New features:

  • Amazon Aurora Serverless v2 is generally available. For more information, see the Amazon Aurora Serverless overview, blog, and Using Aurora Serverless v2 documentation. Get started today by creating an Aurora Serverless v2 database using only a few steps in the Amazon Web Services Management Console.

Availability improvements:

  • Fixed an issue that can cause the server to potentially go into a restart loop and cause unavailability while deleting a record or dropping a table containing two or more variable-length columns (VARCHAR, VARBINARY, BLOB, and TEXT types). For more details about column types, see innodb-row-format.

  • Fixed an issue where existing connections timeout and new connections could not be established on a cluster with Binary Log turned on and has at least one Binary Log consumer attached that results in resource contention between the application and the consumer(s).

  • Freeable memory is indicated by the FreeableMemory CloudWatch metric. For more information, see Amazon CloudWatch metrics for Amazon Aurora.

    • Fixed an issue that can cause a DB instance restart or a failover due to a decrease in freeable memory when binary log replication is enabled.

    • Fixed an issue that can cause a DB instance restart or a failover due to a decrease in freeable memory when setting session variables.

    • Fixed an issue that can cause a DB instance restart or a failover due to a decrease in freeable memory when the database process opens an existing file.

  • Fixed an issue which, in rare conditions, can cause a duplicate entry error when inserting new rows into a table containing an AUTO_INCREMENT column on a cluster restored from snapshot.

  • Fast insert isn't enabled in this Aurora MySQL version, due to an issue that can cause inconsistencies when running queries such as INSERT INTO, SELECT, and FROM. For more information on the fast insert optimization, see Amazon Aurora MySQL performance enhancements.

General improvements:

Upgrades/Migration:

  • Fixed an issue that can cause migration failures of MySQL 8.0.x databases to Aurora MySQL version 3 due to an issue in copying ibdata files and tablespaces to Aurora storage.

  • Fixed an issue which can cause upgrades of clusters from Aurora MySQL version 2 to Aurora MySQL version 3 to fail when database tables contained a large amount of data.

  • Fixed an issue that can cause failures when restoring clusters from Aurora MySQL version 2 to Aurora MySQL version 3 due to a failure in creating serialized data dictionary information (SDI) for a table.

  • Fixed an issue that can cause upgrade failures from Aurora MySQL version 2 to Aurora MySQL version 3 due to schema inconsistency errors reported by upgrade prechecks for RDS system tables.

  • Fixed an issue that can cause failures when migrating or restoring from RDS for MySQL 8.0 or Aurora MySQL version 2 to Aurora MySQL version 3 databases due to invalid syntax in an RDS managed stored procedure.

  • Fixed an issue that can cause upgrade failures from Aurora MySQL 2 to Aurora MySQL 3 due to schema inconsistency errors reported by upgrade prechecks for the general log and slow log tables.

Integration of MySQL community edition bug fixes

This release includes all community bug fixes up to and including 8.0.23, in addition to the below. For more information, see MySQL bugs fixed by Aurora MySQL 3.x database engine updates.

  • Fixed the improper handling of temporary tables used for cursors within stored procedures that could result in unexpected server behavior, mysqld-8-0-24-bug. (Bug #32416811)