Make sure you understand the release model for MySQL innovation and long-term support (LTS) versions before you proceed with an upgrade.
Monthly Rapid Updates (MRUs) and hotfixes also count as "releases" in the following discussions.
It is necessary to upgrade to the latest innovation releases (for example, from MySQL 8.1 to 8.2) regularly to keep up with the latest bug fixes and security patches.
We use "8.4.x LTS" as an example for an LTS release only for illustrative purposes.
The supported upgrade paths for MySQL Server are listed in Table 2.14, “Upgrade Paths for MySQL Server” below:
Table 2.14 Upgrade Paths for MySQL Server
|Upgrade Path||Path Examples||Upgrade Methods||Notes|
|Within an LTS or bugfix release series||
8.0.34 to 8.0.36
8.4.x LTS to 8.4.x+1 LTS
|in-place upgrade, logical upgrade, asynchronous replication, MySQL Clone|
|From an LTS or bugfix release to the next LTS or bugfix release||8.0.34 to 8.4.x LTS||in-place upgrade, logical upgrade, asynchronous replication, MySQL Clone|
|From an LTS or bugfix release to an innovation release before the next LTS series||8.0.34 to 8.2.0||in-place upgrade, logical upgrade, asynchronous replication|
|From an innovation release series to another one before the next LTS series||8.1.0 to 8.2.0||in-place upgrade, logical upgrade, asynchronous replication|
|From MySQL 5.7 to an LTS or Innovation release||MySQL 5.7 to 8.x||Upgrade first to a MySQL 8.0 bugfix release (8.0.34 or later), then to an innovation release||See upgrade paths for MySQL 8.0 for upgrade instructions for MySQL 5.7.|