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.28 to 8.0.32.
Topics
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.
MySQL engine version | Community release date | RDS release date | RDS end of standard support date |
---|---|---|---|
8.0 | |||
8.0.34 |
18 July 2023 |
9 August 2023 |
September 2024 |
8.0.33 |
18 April 2023 |
15 June 2023 |
September 2024 |
8.0.32 |
17 January 2023 |
7 February 2023 |
March 2024 |
8.0.31 |
11 October 2022 |
10 November 2022 |
March 2024 |
8.0.30 |
26 July 2022 |
9 September 2022 |
September 2023 |
8.0.28 |
18 January 2022 |
11 March 2022 |
March 2024 |
5.7 | |||
5.7.44* |
Not yet released |
Not yet released |
February 2024 |
5.7.43 |
18 July 2023 |
9 August 2023 |
February 2024 |
5.7.42 |
18 April 2023 |
15 June 2023 |
December 2023 |
5.7.41 |
17 January 2023 |
7 February 2023 |
December 2023 |
5.7.40 |
11 October 2022 |
11 November 2022 |
December 2023 |
5.7.39 |
26 July 2022 |
29 September 2022 |
December 2023 |
5.7.38 |
26 April 2022 |
6 June 2022 |
December 2023 |
5.7.37 |
18 January 2022 |
11 March 2022 |
December 2023 |
* Amazon RDS Extended Support eligible minor engine version. For more information, see Using Amazon RDS Extended Support.
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.
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.6 |
5 February 2013 |
1 July 2013 |
5 February 2021 |
1 March 2022 |
N/A |
N/A |
N/A |
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