Although Aurora MySQL-Compatible Edition is compatible with the MySQL database engines, Aurora MySQL includes features and bug fixes that are specific to particular Aurora MySQL versions. Application developers can check the Aurora MySQL version in their applications by using SQL. Database administrators can check and specify Aurora MySQL versions when creating or upgrading Aurora MySQL DB clusters and DB instances. Show
Topics
Checking or specifying Aurora MySQL engine versions through AWSWhen you perform administrative tasks using the AWS Management Console, AWS CLI, or RDS API, you specify the Aurora MySQL version in a descriptive alphanumeric format. Starting with Aurora MySQL 2.03.2 and 1.17.9, Aurora engine versions have the following syntax.
The The All 1.x Aurora MySQL engine versions are wire-compatible with Community MySQL 5.6.10a. All 2.x Aurora MySQL engine versions are wire-compatible with Community MySQL 5.7.12. All 3.x Aurora MySQL engine versions are wire-compatible with MySQL 8.0.23 onwards. You can refer to release notes of specific 3.x version to find the corresponding MySQL compatible version. For example, the engine versions for Aurora MySQL 3.02.0, 2.03.2, and 1.17.9 are the following.
For Aurora MySQL 2.x, all versions 2.03.1 and lower are represented by the engine version You specify the Aurora MySQL engine version in some AWS CLI commands and RDS API operations. For example, you specify the In Aurora MySQL 1.17.9 and higher or 2.03.2 and higher, the engine version in the AWS Management Console also includes the Aurora version. Upgrading the cluster changes the displayed value. This change helps you to specify and check the precise Aurora MySQL versions, without the need to connect to the cluster or run any SQL commands. For Aurora
clusters managed through AWS CloudFormation, this change in the Before Aurora MySQL 1.17.9 and 2.03.2, the process to update the engine version is to use the Apply a
Pending Maintenance Action option for the cluster. This process doesn't change the Aurora MySQL engine version that the console displays. For example, suppose that you see an Aurora MySQL cluster with a reported engine version of Checking Aurora MySQL versions using SQL The Aurora version numbers
that you can retrieve in your application using SQL queries use the format
Those queries produce output similar to the following.
The version numbers that the console, CLI, and RDS API return by using the techniques described in
Checking or specifying Aurora MySQL engine versions through AWS are typically more descriptive. However, for versions before 2.03.2 and 1.19, AWS always returns the version numbers Aurora MySQL long-term support (LTS) releasesEach new Aurora MySQL version remains available for a certain amount of time for you to use when you create or upgrade a DB cluster. After this period, you must upgrade any clusters that use that version. You can manually upgrade your cluster before the support period ends, or Aurora can automatically upgrade it for you when its Aurora MySQL version is no longer supported. Aurora designates certain Aurora MySQL versions as long-term support (LTS) releases. DB clusters that use LTS releases can stay on the same version longer and undergo fewer upgrade cycles than clusters that use non-LTS releases. Aurora supports each LTS release for at least three years after that release becomes available. When a DB cluster that's on an LTS release is required to upgrade, Aurora upgrades it to the next LTS release. That way, the cluster doesn't need to be upgraded again for a long time. During the lifetime of an Aurora MySQL LTS release, new patch levels introduce fixes to important issues. The patch levels don't include any new features. You can choose whether to apply such patches to DB clusters running the LTS release. For certain critical fixes, Amazon might perform a managed upgrade to a patch level within the same LTS release. Such managed upgrades are performed automatically within the cluster maintenance window. We recommend that you upgrade to the latest release, instead of using the LTS release, for most of your Aurora MySQL clusters. Doing so takes advantage of Aurora as a managed service and gives you access to the latest features and bug fixes. The LTS releases are intended for clusters with the following characteristics:
The current LTS releases for Aurora MySQL are the following:
These older versions are also designated as LTS releases:
Upgrade paths between 5.6-compatible and 5.7-compatible clustersFor most Aurora MySQL 1.x and 2.x versions, you can upgrade a MySQL 5.6-compatible cluster to any version of a MySQL 5.7-compatible cluster. However, if your cluster is running Aurora MySQL 1.23 or higher, any upgrade to Aurora MySQL version 2.x must be to Aurora MySQL 2.09 or higher. This restriction applies even when you upgrade by restoring a snapshot to create a new Aurora cluster. Aurora MySQL 1.23 includes improvements in Aurora storage. For example, the maximum size of the cluster volume is larger in Aurora MySQL 1.23 and later. Aurora MySQL 2.09 is the first 2.x version that has the same storage enhancements. What is MySQL 8 deprecated?You should expect this variable and the equivalent server option --replica-parallel-type to be removed in a future MySQL release. The myisam_repair_threads system variable and myisamchk --parallel-recover option are deprecated; expect support for both to be removed in a future release of MySQL.
Why should I upgrade to MySQL 8?MySQL 8.0 increases the overall reliability of MySQL because : MySQL 8.0 stores its meta-data into InnoDB, a proven transactional storage engine. System tables such as Users and Privileges as well as Data Dictionary tables now reside in InnoDB.
What is the latest version of MySQL 2021?MySQL :: MySQL 8.0 Release Notes :: Changes in MySQL 8.0. 23 (2021-01-18, General Availability)
Is MySQL 5.7 still supported?MySQL 5.7 – Community end of life planned until October, 2023. Amazon RDS for MySQL will continue to support until the community EOL date. MySQL 8.0 – Community end of life planned until April, 2026.
|