3.1.2.2 Server Upgrades

HeatWave on AWS supports the most recent release versions of MySQL, and the following kinds of upgrades are supported:

• Patch version upgrades, such as from 9.x.N to 9.x.N+1: These upgrades must be performed manually (except when there is an automatic upgrade due to version removal). See Upgrade MySQL Version for information.
• HeatWave-specific version upgrades, such as from 9.x.y. to 9.x.y-uN: These upgrades are performed automatically and according to the maintenance window defined on the DB System.
• Major version upgrades, such as from 8.0.x to 8.N.y, or from 8.x.y to 9.N.M: These upgrades must be performed manually. Only the following upgrade paths are supported:

  • Upgrade from a BugFix or LTS release to an Innovation release before the next LTS series.

    Note:

    You cannot upgrade directly from a BugFix or LTS release to an Innovation release after the next LTS. For example, to upgrade from MySQL 8.0 to 9.x, you must first upgrade from MySQL 8.0 to MySQL 8.4, then upgrade from MySQL 8.4 to MySQL 9.x.
  • Upgrade from a BugFix or LTS release to the next LTS series.
  • Upgrade from an Innovation release to the next LTS series.

  Note:

  If your major version upgrade does not fall under one of the paths above, it will fail.

  Each major version of MySQL servers is likely to introduce some new features and remove some deprecated features. You should first identify the changes between the current version and the new version, and then verify that these changes do not affect how you use the MySQL database server. Some major changes that you should be aware of before upgrading are listed in the sections to follow (see links below).

To perform a server upgrade, follow the instructions given in Upgrade MySQL Version.

For more information about MySQL Server versioning, see Server Versioning.

• Upgrading MySQL 8.0 BugFix to MySQL 8.4 LTS
  
• Upgrading MySQL 8.4 LTS to MySQL 9.x Innovation
  

Parent topic: MySQL Server