What we know so far about MySQL 8.1 Innovation Release and existing MySQL 8.0.x and Long-Term Support (LTS) versions.
This is Onikai (@fat47) from the Service Reliability Group (SRG) of the Technology Division.
#SRGThe Service Reliability Group primarily provides comprehensive support for the infrastructure surrounding our media services, focusing on improving existing services, launching new ones, and contributing to open-source software (OSS).
This article is located within SRG.DBWGThe DB Working Group is releasing database-related materials that it provides to the entire company.
I hope this is of some help.
overviewSummary of each versionMySQL 8.x (Innovation Release)MySQL 8.0.xMySQL 8.x(LTS)Upgrade availabilityUpgradeable patternsPatterns where upgrading is not recommendedDowngrade for rollback using asynchronous replicationIn conclusion
overview
On July 18, 2023MySQL8.1andMySQL8.0.34It has been released.
Up until now, MySQL 8.0 releases have frequently included the addition and removal of features, even in minor versions, which has made it difficult to keep up with the latest versions.
With this release, we've separated releases into Innovation Releases, which include the addition and removal of features, and releases that only include bug fixes.
Furthermore, in the futureLong-Term Support(LTS)It has been announced that a new version of MySQL will be released.
I've summarized the characteristics of each and what we currently know about them.
However, the following article covers almost all the details, so you might be better off reading that instead.
On this page, I will focus on summarizing information related to EOL (End of Life) and upgrades, which our team will likely be dealing with.
Summary of each version
For the time being, there will be three different versions of MySQL coexisting.
| version | remarks | EOL |
|---|---|---|
| MySQL 8.x ( Innovation ) | Innovation Release adds new features. | Until the next MySQL 8.y release (approximately 3 months) |
| MySQL 8.0.x | Bug fixes only | April 2026 |
| MySQL 8.x (LTS) *Not yet released* | LTS (Long-Term Support) is released every two years. | 8 years since release (Extended Support) |
MySQL 8.x (Innovation Release)
The support period is only about three months, until the next Innovation Release is released.
While each upgrade will be required, you will be able to use the latest features and improvements.
Currently, MySQL 8.1 has been released, and the version numbers will increase from 8.2 → 8.3 → 8.4.
MySQL 8.0.x
Until the end-of-life (EOL) of the conventional MySQL 8.0 series in April 2026, releases will consist only of bug fixes.
You have more than two years from the current date.
MySQL 8.x(LTS)
It is not yet released, but we are aiming for a release in about a year.
For example, if MySQL 8.1 → 8.2 → 8.3 → 8.4 are released every three months, then MySQL 8.4 will be released as an LTS (Long Term Support) version.
When an LTS version is released, the major version number of the Innovation Release increases, so the next Innovation Release will be MySQL 9.0.0.
![Oracle MySQL Blog [MySQLの Innovation と Long-Term Support (LTS) バージョンのご紹介]より引用](https://s3.ap-northeast-1.amazonaws.com/wraptas-prod/ca-srg/2dfa2c16-4545-4dec-99de-8628a964d8b3/cab5cd0116c6cf1968758104967ffae0.png)
Upgrade availability
Basically, just like with previous versions of MySQL, it supports upgrades up to one generation.
This time, there are multiple versions mixed together, which can be a little confusing, but here's an example:
Upgradeable patterns
Patterns where upgrading is not recommended
Downgrade for rollback using asynchronous replication
In conclusion
Before the LTS release, I took a look back at MySQL versions.
The end-of-life (EOL) for MySQL 5.7 is October 2023.
Let's think about how we'll upgrade the version before then.
SRG is looking for new team members.
If you are interested, please contact us here.