Aurora MySQL database engine updates 2022-04-15 (version 3.01.1, compatible with MySQL 8.0.23) - 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.

Aurora MySQL database engine updates 2022-04-15 (version 3.01.1, compatible with MySQL 8.0.23)

Version: 3.01.1

Aurora MySQL 3.01.1 is generally available. Aurora MySQL 3.01 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.01.1.

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.

To create a cluster with an older version of Aurora MySQL, specify the engine version through the Amazon Web Services Management Console, the Amazon CLI, or the Amazon RDS API.

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.01.1 is generally available and generally compatible with community MySQL 8.0.23.

Aurora MySQL version 3.01.1 is recommended for upgrades and migrations to a MySQL 8.0 compatible Aurora database.

Fixed security issues and CVEs listed below:

Availability improvements:

  • 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.

General improvements:

  • Fixed an issue where the volume status was not shown when using the SHOW VOLUME STATUS command. For more information, see AuroraMySQL.Managing.VolumeStatus.

  • Fixed an issue that caused calls to mysql_rds_import_binlog_ssl_material to fail with MySQL server ERROR 3512.

  • Fixed an issue where Aurora replica lag is incorrectly reported for deleted Aurora reader instances.

  • The fast insert cache optimization has been disabled in Aurora MySQL versions 3.01.0 and 3.01.1 due to an issue that can cause inconsistencies when executing queries like INSERT INTO, SELECT, and FROM. This feature will be re-enabled in a future Aurora MySQL version 3 release after it is fixed. For more information on the fast insert optimization please see Overview of Amazon Aurora MySQL.

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

  • 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)