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.
Topics
- Supported MySQL minor versions on Amazon RDS
- Supported MySQL major versions on Amazon RDS
- Amazon RDS Extended Support versions for RDS for MySQL
- Working with the Database Preview environment
- MySQL version 8.4 in the Database Preview environment
- MySQL version 8.3 in the Database Preview environment
- MySQL version 8.2 in the Database Preview environment
- MySQL version 8.1 in the Database Preview environment
- Deprecated versions for Amazon RDS for MySQL
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.39 |
23 July 2024 |
12 August 2024 |
September 2025 |
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 are available under Amazon RDS Extended Support.
MySQL engine version | Community release date | RDS release date | RDS end of Extended Support date |
---|---|---|---|
5.7.44-RDS.20240529* |
Not applicable | 25 June 2024 | September 2025 |
5.7.44-RDS.20240408* |
Not applicable | 17 May 2024 |
September 2025 |
5.7.44 |
25 October 2023 | 2 November 2023 | March 2025 |
* MySQL Community retired major version 5.7 and won't be releasing new minor versions. This is a minor version that Amazon RDS released with critical security patches and bug fixes for MySQL 5.7 databases that are covered under RDS Extended Support. For more information about these minor versions, see Amazon RDS Extended Support versions for RDS for MySQL. For more information about RDS Extended Support, 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
Amazon 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 Amazon Web Services 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 Amazon Web Services Region using the following Amazon CLI command:
aws rds describe-db-engine-versions --default-only --engine mysql --engine-version
major-engine-version
--regionregion
--query "*[].{Engine:Engine,EngineVersion:EngineVersion}" --output text
Replace major-engine-version
with the major engine version,
and replace region
with the Amazon Web Services Region. For example, the
following Amazon CLI command returns the default MySQL minor engine version for the 5.7 major
version and the US West (Oregon) Amazon Web Services 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.39
MySQL version 8.0.39 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 that prevented
sql_log_off
from working properly with theSESSION_VARIABLES_ADMIN
privilege.Fixed a bug that prevented the master user from being able to grant the
SESSION_VARIABLE_ADMIN
privilege other database users.Fixed a bug that caused an illegal mix of collation while executing RDS-provided stored procedures.
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.
Releases
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 implementingfix_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 Amazon Web Services Support with DB instances.
-
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
MySQL version 8.4 in the Database Preview environment
MySQL version 8.4 is now available in the Amazon RDS Database Preview environment. MySQL
version 8.4 is the latest LTS release from the community, and contains several
improvements that are described in Changes in
MySQL 8.4.0
MySQL version 8.4 in the Database Preview environment might differ from what Amazon RDS releases in all Amazon Web Services Regions for production workloads. The following list includes features that could change. This list isn't exhaustive.
-
The RDS for MySQL 8.4 parameter group definition. For example, Amazon RDS might add, remove, or rename parameters, and might change the parameter default values.
-
The privilege model.
-
The TLS library.
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.amazonaws.cn/rds-preview/
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.amazonaws.cn/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.amazonaws.cn/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.amazonaws.cn/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