In MySQL, the version number consists of version = X.Y.Z. In NHN Cloud's RDS for MySQL, X.Y represents the major version and Z represents the minor version.
The versions specified below are available. New DB instance creation and read replicas are supported only for the top 7 minor versions per major version. Support for MySQL versions below 8.0.34 has ended in accordance with the MySQL LTS policy. We recommend upgrading your DB instances to the latest version.
| Version | Note |
|---|---|
| 8.4 | |
| MySQL 8.4.7 | |
| MySQL 8.4.6 | |
| MySQL 8.4.5 | |
| 8.0 | |
| MySQL 8.0.44 | |
| MySQL 8.0.43 | |
| MySQL 8.0.42 | |
| MySQL 8.0.41 | |
| MySQL 8.0.40 | |
| MySQL 8.0.36 | |
| MySQL 8.0.35 | |
| MySQL 8.0.34 | Creation and read replicas unsupported |
| MySQL 8.0.33 | Creation and read replicas unsupported |
| MySQL 8.0.32 | Creation and read replicas unsupported |
| MySQL 8.0.28 | Creation and read replicas unsupported |
| MySQL 8.0.23 | Creation and read replicas unsupported |
| MySQL 8.0.18 | Creation and read replicas unsupported |
| 5.7 | |
| MySQL 5.7.37 | |
| MySQL 5.7.33 | You cannot restore a DB instance from an external backup. |
| MySQL 5.7.26 | |
| MySQL 5.7.19 | |
| MySQL 5.7.15 | |
| 5.6 | |
| MySQL 5.6.33 | This version is no longer supported. |
After creating the DB instance, you can change the DB engine version and modify the DB instance.
[Caution] When attempting to change the DB version, only an upgrade is supported. a downgrade is not supported.
When upgrading the database engine version, a major version upgrade occurs if only the major version number is changed, and a minor version upgrade occurs if only the minor version number is changed. When attempting to upgrade the DB engine major version, you can upgrade to the next major version of the DB engine.
MySQL 8.0 and MySQL 5.7 contain a number of incompatibilities. So if you are doing a major version DB engine upgrade from 5.7 to version 8.0, you may run into issues. Therefore, a pre-inspection process is required for some items that are expected to cause problems. The following items require prior inspection.
mysqlcheck.INFORMATION_SCHEMA.VIEWS, the column name must not exceed 64 characters.lower_case_table_names setting to 1, make sure the schema names are lower case.lower_case_table_names setting to 1, make sure the table names are lower case.For DB version upgrade pre-check, you can check the result in the following ways.
- Check for the detailed checklist for upgrading from 5.7 to 8.0(https://static.toastoven.net/prod_rds/mysql/23.08.17/Check_5.7_to_8.0_en.xlsx)
- When attempting to upgrade the DB version in the console, check the result using the DB Engine Upgrade Pre-Check button.
- Check the results of DB version upgrade attempts
For the results of DB Engine upgrade pre-checkin the console and the results of DB version upgrade attempts, you can check the details through db_version_upgrade_compatibility.loggenerated on the Log tab of each DB instance. The detailed history items have the following meanings, respectively.
- CHECK_BY_MYSQL_CHECK: There must be no version upgrade disqualifications via mysqlcheck.
- COLUMN_LENGHT_LIMIT_CHECK: When checked through INFORMATION_SCHEMA.VIEWS, the column name must not exceed 64 characters.
- DUPLICATE_NAME_WITH_DATA_DICT: No table should have the same name as a table used in the data dictionary.
- ENUM_SET_SIZE_CHECK: There must be no tables or stored procedures with individual ENUM, SET column elements that exceed 255 characters or 1020 bytes in length.
- FOREIGN_KEY_LENGTH_LIMIT_CHECK: No table should have a foreign key constraint name longer than 64 characters.
- LOWER_CASE_SCHEMAS_NAMES_CHECK: If you want to change the lower_case_table_names setting to 1, make sure the schema names are lower case.
- LOWER_CASE_TABLE_NAMES_CHECK: If you want to change the lower_case_table_names setting to 1, make sure the table names are lower case.
- PARTITION_TABLE_CHECK: There must be no partition table extracted through a specific partition check.
- PROPERTY_LENGTH_LIMIT_CHECK: No table partitions must reside in shared tablespaces, including the InnoDB system tablespace and regular tablespaces.
Also, you must check items that have been removed or changed in 8.0. - Changes in SQL - Features Removed in MySQL8.0
To upgrade to MySQL 8.4, you must have already upgraded to MySQL 8.0. When upgrading a major version of the DB engine from 8.0 to 8.4, a pre-check process is required for some items that are expected to cause problems.
You can check the items detected by the upgrade checker through DB Engine Upgrade Pre-Check in the console, and any items detected as errors must be addressed. For more details, please refer to the MySQL homepage.
- Upgrade Checker Guide
Also, you must check what has been removed or changed in 8.4. - Guide to Incompatible Changes - Guide to Features Removed in 8.4
Direct upgrade from version 8.0.18 to MySQL 8.4 is not supported. The following conditions must be met to upgrade from 8.0.18 to 8.4:
Upgrade Path 1. First, upgrade to MySQL 8.0.23 or higher 2. Then, upgrade to MySQL 8.4
This is because MySQL 8.4 requires at least version 8.0.23 for metadata and internal schema compatibility. Upgrading from versions below 8.0.23 is not supported.
When trying to change the DB engine version in the Modify DB Instance window, you can select whether to use a dummy DB instance to ensure high availability during the version upgrade process. If you choose to use a dummy DB instance, a candidate master for DB version upgrade is created.
[Caution] For dummy DB instances, a temporary candidate master is created during the upgrade process, so this option is only available for non-high-availability configurations.
When a DB instance is configured for high availability, the engine version of the candidate master is upgraded first, and then failover is used to promote the candidate master to master. Because failover briefly interrupts the service on the master, you can initiate failover at any time. The manual control of failover during version upgrade allows you to initiate failover directly from the console.
For DB instances created before May 10, 2022, the DB instance will be replaced when the internal operating system is outdated so the DB version is upgraded. During the replacement process, the DB instance's identifier and internal IP address will be changed. The monitored instances in notification groups and event sources in event subscriptions are automatically replaced with the changed identifiers. For a single DB instance, you must use a dummy DB instance when changing DB versions. For high-availability DB instances, the roles of the master and spare master are changed using failover during the DB instance replacement process. Failover may fail if the master is heavily loaded, so it is recommended that you perform DB version change during off-peak hours.
[Caution] Be careful when using the internal IP of an existing DB instance directly in an IP ACL or security group.
[Caution] This plugin may not be supported by all versions of MySQL and will be unavailable when upgrading to an unsupported version.
| MySQL version | Whether to support server audit plugins |
|---|---|
| 8.4 | |
| MySQL 8.4.7 | O |
| MySQL 8.4.6 | O |
| MySQL 8.4.5 | O |
| 8.0 | |
| MySQL 8.0.44 | O |
| MySQL 8.0.43 | O |
| MySQL 8.0.42 | O |
| MySQL 8.0.41 | O |
| MySQL 8.0.40 | O |
| MySQL 8.0.36 | O |
| MySQL 8.0.35 | O |
| MySQL 8.0.34 | O |
| MySQL 8.0.33 | O |
| MySQL 8.0.32 | O |
| MySQL 8.0.28 | O |
| MySQL 8.0.23 | O |
| MySQL 8.0.18 | X |
| 5.7 | |
| MySQL 5.7.37 | X |
| MySQL 5.7.33 | O |
| MySQL 5.7.26 | O |
| MySQL 5.7.19 | O |
| MySQL 5.7.15 | X |
| 5.6 | |
| MySQL 5.6.33 | O |