MySQL's release model
Since 2023, Oracle publishes long-term support (LTS) releases with a long support period, and innovation releases in between with new features and a short life. MySQL 8.4 was the first LTS release in this model. For a business application an LTS release is the natural choice: MySQL 8.4 LTS is supported until 2032, MySQL 9.7 LTS until 2034.
Upgrade paths
- From MySQL 5.7: first to MySQL 8.0, then to 8.4. Oracle does not support going from 5.7 straight to 8.4, neither in place nor with a logical dump or replication: a release series cannot be skipped.
- From MySQL 8.0: directly to MySQL 8.4 LTS.
- From MySQL 8.4 LTS: directly to the next LTS, MySQL 9.7.
Before every step, run the upgrade checker in MySQL Shell (util.checkForServerUpgrade()). It reports many problems in advance, such as removed settings and incompatible objects. For production, a new server kept in sync with replication is often safer than an in-place upgrade: you can test it fully and switch over with little downtime.
What breaks from 5.7 to 8.0
- New reserved words such as
RANK,GROUPS,LEADandROW_NUMBER, which may be used as table or column names - The default character set becomes utf8mb4 with the utf8mb4_0900_ai_ci collation, which affects comparisons and index lengths
- The query cache has been removed, and
GROUP BYno longer sorts implicitly - The default authentication plugin becomes caching_sha2_password, which older client libraries do not understand
What breaks from 8.0 to 8.4 and 9.7
- The mysql_native_password plugin is disabled by default in 8.4 and removed in 9.0, so accounts and clients that still use it have to move to caching_sha2_password
- The old replication statements with MASTER and SLAVE (such as
CHANGE MASTER TOandSHOW SLAVE STATUS) have been removed; useCHANGE REPLICATION SOURCE TOandSHOW REPLICA STATUS - Several server settings have new defaults or have been removed, so check your configuration file against the release notes
- Features that were deprecated in 8.0 have been removed in later versions; the upgrade checker lists the ones that affect you
Managed MySQL in the cloud
If you want to stop managing servers, the upgrade is a good moment to move to a managed service. Not every service offers every version: Amazon RDS for MySQL offers 8.4 and 9.7, and 8.0 only with paid RDS Extended Support; Amazon Aurora MySQL offers 8.0 and 8.4; Azure Database for MySQL Flexible Server offers 8.0 and 8.4; Google Cloud SQL for MySQL offers 8.0, 8.4 and 9.7. Cloud providers keep older versions available for a while after the community end of life, sometimes only with paid extended support, as Amazon RDS does.
Managed services do not give you a SUPER privilege or access to the server. Code with DEFINER clauses for unknown users, functions that write to files and some replication settings may need changes.
How the free scan helps
The scan has a read-only script for MySQL and MariaDB that collects the structure of your database: tables, columns, indexes, routines and which features they use. Paste the result, choose MySQL 8.4 or 9.7 on your own server or on a managed service, and see what needs attention per target. The analysis runs in your browser and nothing is uploaded.
Questions
Can I upgrade MySQL 5.7 directly to 8.4?
No. Oracle supports only the route via 8.0: upgrade to 8.0 first and then to 8.4. That also applies to a logical dump and load or to replication.
Should I choose MySQL 8.4 or 9.7?
Both are LTS releases. 9.7 is supported longer, but check that your managed service, drivers and tools support it; several cloud services offer 8.4 but not yet 9.7.
Is MySQL 8.0 still supported?
The community end of life of MySQL 8.0 was in April 2026. Some cloud providers keep it available for longer, in some cases only with paid extended support.
Does this also apply to MariaDB?
MariaDB has its own versions and release schedule and has diverged from MySQL. The scan supports MariaDB as a source and as a target, with its own versions.
Check your MySQL database before you upgrade: run the read-only script, paste the result and pick MySQL 8.4 or 9.7 as the target. Free, and nothing leaves your browser.
Start the free scan