MySQL on Amazon RDS versions - Amazon Relational Database Service

MySQL on Amazon RDS versions

For MySQL, version numbers are organized as version = X.Y.Z. In Amazon RDS terminology, X.Y denotes the major version, and Z is the minor version number. For Amazon RDS implementations, a version change is considered major if the major version number changes—for example, going from version 5.7 to 8.0. A version change is considered minor if only the minor version number changes—for example, going from version 8.0.32 to 8.0.34.

Supported MySQL minor versions on Amazon RDS

Amazon RDS currently supports the following minor versions of MySQL.

Note

Dates with only a month and a year are approximate and are updated with an exact date when it’s known.

Amazon RDS Extended Support isn't available for minor versions.

The following table shows the minor versions of MySQL 8.0 that Amazon RDS currently supports.

MySQL engine version Community release date RDS release date RDS end of standard support date

8.0.37

30 April 2024

18 June 2024

September 2025

8.0.36

16 January 2024

12 February 2024

March 2025

8.0.35

25 October 2023

9 November 2023

March 2025

8.0.34

18 July 2023

9 August 2023

March 2025

8.0.33

18 April 2023

15 June 2023

March 2025

8.0.32

17 January 2023

7 February 2023

March 2025

The following table shows the minor versions of MySQL 5.7 that Amazon RDS currently supports.

MySQL engine version Community release date RDS release date RDS end of standard support date

5.7.44*

25 October 2023 2 November 2023

29 February 2024

* This minor version will continue to be available when the major version is in Amazon RDS Extended Support. For more information, see Using Amazon RDS Extended Support.

Minor versions can reach end of standard support before major versions do. For example, minor version 8.0.28 reached its end of standard support date on March 28, 2024 while major version 8.0 will reach this date on July 31, 2026. RDS will support additional 8.0.* minor versions that the MySQL community releases between these dates.

You can specify any currently supported MySQL version when creating a new DB instance. You can specify the major version (such as MySQL 5.7), and any supported minor version for the specified major version. If no version is specified, Amazon RDS defaults to a supported version, typically the most recent version. If a major version is specified but a minor version is not, Amazon RDS defaults to a recent release of the major version you have specified. To see a list of supported versions, as well as defaults for newly created DB instances, use the describe-db-engine-versions AWS CLI command.

For example, to list the supported engine versions for RDS for MySQL, run the following CLI command:

aws rds describe-db-engine-versions --engine mysql --query "*[].{Engine:Engine,EngineVersion:EngineVersion}" --output text

The default MySQL version might vary by AWS Region. To create a DB instance with a specific minor version, specify the minor version during DB instance creation. You can determine the default minor version for an AWS Region using the following AWS CLI command:

aws rds describe-db-engine-versions --default-only --engine mysql --engine-version major-engine-version --region region --query "*[].{Engine:Engine,EngineVersion:EngineVersion}" --output text

Replace major-engine-version with the major engine version, and replace region with the AWS Region. For example, the following AWS CLI command returns the default MySQL minor engine version for the 5.7 major version and the US West (Oregon) AWS Region (us-west-2):

aws rds describe-db-engine-versions --default-only --engine mysql --engine-version 5.7 --region us-west-2 --query "*[].{Engine:Engine,EngineVersion:EngineVersion}" --output text

With Amazon RDS, you control when to upgrade your MySQL instance to a new major version supported by Amazon RDS. You can maintain compatibility with specific MySQL versions, test new versions with your application before deploying in production, and perform major version upgrades at times that best fit your schedule.

When automatic minor version upgrade is enabled, your DB instance will be upgraded automatically to new MySQL minor versions as they are supported by Amazon RDS. This patching occurs during your scheduled maintenance window. You can modify a DB instance to enable or disable automatic minor version upgrades.

If you opt out of automatically scheduled upgrades, you can manually upgrade to a supported minor version release by following the same procedure as you would for a major version update. For information, see Upgrading a DB instance engine version.

Amazon RDS currently supports the major version upgrades from MySQL version 5.6 to version 5.7, and from MySQL version 5.7 to version 8.0. Because major version upgrades involve some compatibility risk, they do not occur automatically; you must make a request to modify the DB instance. You should thoroughly test any upgrade before upgrading your production instances. For information about upgrading a MySQL DB instance, see Upgrading the MySQL DB engine.

You can test a DB instance against a new version before upgrading by creating a DB snapshot of your existing DB instance, restoring from the DB snapshot to create a new DB instance, and then initiating a version upgrade for the new DB instance. You can then experiment safely on the upgraded clone of your DB instance before deciding whether or not to upgrade your original DB instance.

MySQL minor versions on Amazon RDS

Minor versions

MySQL version 8.0.37

MySQL version 8.0.37 is now available on Amazon RDS. This release contains fixes and improvements added by the MySQL community and Amazon RDS.

New features and enhancements

Fixed a bug with executing an instant DDL statement followed by an UPDATE that lead to an assertion failure.

Supported MySQL major versions on Amazon RDS

RDS for MySQL major versions are available under standard support at least until community end of life for the corresponding community version. You can continue running a major version past its RDS end of standard support date for a fee. For more information, see Using Amazon RDS Extended Support and Amazon RDS for MySQL pricing.

You can use the following dates to plan your testing and upgrade cycles.

Note

Dates with only a month and a year are approximate and are updated with an exact date when it’s known.

MySQL major version Community release date RDS release date Community end of life date RDS end of standard support date RDS start of Extended Support year 1 pricing date RDS start of Extended Support year 3 pricing date RDS end of Extended Support date

MySQL 8.0

19 April 2018

23 October 2018

April 2026

31 July 2026

1 August 2026 1 August 2028

31 July 2029

MySQL 5.7*

21 October 2015

22 February 2016

October 2023

29 February 2024

1 March 2024 1 March 2026

28 February 2027

* MySQL 5.7 is now only available under RDS Extended Support. For more information, see Using Amazon RDS Extended Support.

Amazon RDS Extended Support versions for RDS for MySQL

The following content lists all releases of RDS Extended Support for RDS for MySQL versions.

RDS Extended Support for RDS for MySQL version 5.7.44-RDS.20240529

RDS Extended Support for RDS for MySQL version 5.7.44-RDS.20240529 is available.

Bugs fixed:

  • Fixed field.cc assertion failure by implementing fix_after_pullout.

  • Fixed a null pointer failure when returning metadata to the client for certain SQL queries. These queries contained dynamic parameters and subqueries in SELECT clauses.

  • Fixed incorrect results when using GROUP BY for loose index scans, or scans of noncontiguous ranges of an index.

  • Fixed loss of GTID information on MySQL crash during persistence.

  • Fixed a race condition that could cause an InnoDB transaction to hang indefinitely.

  • Fixed a race condition in Group Replication's certification information cleanup.

  • Fixed backward index scan issue with concurrent page operations.

  • Fixed an inconsistent full-text search (FTS) state issue in concurrent scenarios.

  • Fixed assertion issue with change buffer on deleting tables.

  • Unified behavior for calling deinit function across all plugin types.

CVEs fixed:

RDS Extended Support for RDS for MySQL version 5.7.44-RDS.20240408

RDS Extended Support for RDS for MySQL version 5.7.44-RDS.20240408 is available.

This release contains patches for the following CVEs:

Working with the Database Preview environment

In July 2023, Oracle announced a new release model for MySQL. This model includes two types of releases: Innovation Releases and LTS releases. Amazon RDS makes MySQL Innovation Releases available in the RDS Preview environment. To learn more about the MySQL Innovation releases, see Introducing MySQL Innovation and Long-Term Support (LTS) versions.

RDS for MySQL DB instances in the Database Preview environment are functionally similar to other RDS for MySQL DB instances. However, you can't use the Database Preview environment for production workloads.

Preview environments have the following limitations:

  • Amazon RDS deletes all DB instances 60 days after you create them, along with any backups and snapshots.

  • You can only use General Purpose SSD and Provisioned IOPS SSD storage.

  • You can't get help from AWS Support with DB instances. Instead, you can post your questions to the AWS‐managed Q&A community, AWS re:Post.

  • You can't copy a snapshot of a DB instance to a production environment.

The following options are supported by the preview.

  • You can create DB instances using db.m6i, db.r6i, db.m6g, db.m5, db.t3, db.r6g, and db.r5 DB instance classes. For more information about RDS instance classes, see DB instance classes.

  • You can use both single-AZ and multi-AZ deployments.

  • You can use standard MySQL dump and load functions to export databases from or import databases to the Database Preview environment.

Features not supported in the Database Preview environment

The following features aren't available in the Database Preview environment:

  • Cross-Region snapshot copy

  • Cross-Region read replicas

  • RDS Proxy

Creating a new DB instance in the Database Preview environment

You can create a DB instance in the Database Preview environment using the AWS Management Console, AWS CLI, or RDS API.

To create a DB instance in the Database Preview environment
  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. Choose Dashboard from the navigation pane.

  3. In the Dashboard page, locate the Database Preview Environment section, as shown in the following image.

    The Database Preview Environment section with link in the Amazon RDS console.

    You can navigate directly to the Database Preview environment. Before you can proceed, you must acknowledge and accept the limitations.

    The Database Preview Environment Service Agreement dialog to acknowledge limitations.
  4. To create the RDS for MySQL DB instance, follow the same process that you would for creating any Amazon RDS DB instance. For more information, see the Console procedure in Creating a DB instance.

To create a DB instance in the Database Preview environment using the AWS CLI, use the following endpoint.

rds-preview.us-east-2.amazonaws.com

To create the RDS for MySQL DB instance, follow the same process that you would for creating any Amazon RDS DB instance. For more information, see the AWS CLI procedure in Creating a DB instance.

To create a DB instance in the Database Preview environment using the RDS API, use the following endpoint.

rds-preview.us-east-2.amazonaws.com

To create the RDS for MySQL DB instance, follow the same process that you would for creating any Amazon RDS DB instance. For more information, see the RDS API procedure in Creating a DB instance.

MySQL version 8.3 in the Database Preview environment

MySQL version 8.3 is now available in the Amazon RDS Database Preview environment. MySQL version 8.3 contains several improvements that are described in Changes in MySQL 8.3.0.

For information on the Database Preview environment, see Working with the Database Preview environment. To access the Preview Environment from the console, select https://console.aws.amazon.com/rds-preview/.

MySQL version 8.2 in the Database Preview environment

MySQL version 8.2 is now available in the Amazon RDS Database Preview environment. MySQL version 8.2 contains several improvements that are described in Changes in MySQL 8.2.0.

For information on the Database Preview environment, see Working with the Database Preview environment. To access the Preview Environment from the console, select https://console.aws.amazon.com/rds-preview/.

MySQL version 8.1 in the Database Preview environment

MySQL version 8.1 is now available in the Amazon RDS Database Preview environment. MySQL version 8.1 contains several improvements that are described in Changes in MySQL 8.1.0.

For information on the Database Preview environment, see Working with the Database Preview environment. To access the Preview Environment from the console, select https://console.aws.amazon.com/rds-preview/.

Deprecated versions for Amazon RDS for MySQL

Amazon RDS for MySQL version 5.1, 5.5, and 5.6 are deprecated.

For information about the Amazon RDS deprecation policy for MySQL, see Amazon RDS FAQs.