What we know now about the MySQL 8.1 Innovation Release and existing MySQL 8.0.x and Long-Term Support (LTS) versions
This is Oniumi (@fat47) from the Service Reliability Group (SRG) of the Technology Headquarters.
#SRG(Service Reliability Group) is a group that mainly provides cross-sectional support for the infrastructure of our media services, improving existing services, launching new ones, and contributing to OSS.
This article is located in SRGDBWGWe will publish materials regarding the database provided by the DB Working Group for the entire company.
I hope this helps in some way.
overviewSummary of each versionMySQL 8.x (Innovation Release)MySQL 8.0.xMySQL 8.x(LTS)Upgrade possibilityUpgradeable PatternsPatterns that are not suitable for upgradeDowngrade for rollback using asynchronous replicationConclusion
overview
July 18, 2023MySQL8.1andMySQL8.0.34has been released.
Previous MySQL 8.0 releases have been minor versions, but features have been added and removed frequently, making it difficult to keep up with the latest versions.
Starting with this release, there are now two types of releases: Innovation Releases, which add or remove features, and bug fixes only.
In addition, in the futureLong-Term Support(LTS)It was announced that MySQL will be released.
Here's a summary of each feature and what we know so far.
However, the article below covers most of the content, so you might want to read that instead.
On this page, I will focus on the EOL and upgrade issues that our team will be dealing with.
Summary of each version
For the time being, MySQL will have a mix of three versions.
| 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 released every two years | 8 years from release (Extended Support) |
MySQL 8.x (Innovation Release)
The support period is only about three months until the next Innovation Release is released.
You will need to upgrade each time, but in return you will be able to take advantage of the latest features and improvements.
MySQL 8.1 has been released so far, and the version numbers will go up from 8.2 to 8.3 to 8.4.
MySQL 8.0.x
Only bug fixes will be released until April 2026, which is the end of life for the previous MySQL 8.0 series.
There is a grace period of approximately two years or more from the current date and time.
MySQL 8.x(LTS)
It is currently unreleased, with a target release date of about a year.
For example, if MySQL 8.1 → 8.2 → 8.3 → 8.4 is released every three months, MySQL 8.4 will be released as an LTS.
When an LTS is released, the major version number of the Innovation Release will be incremented, 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 possibility
Basically, just like previous MySQL versions, upgrades up to one generation are supported.
It may be a little confusing as there are multiple versions mixed together from now on, but here is an example:
Upgradeable Patterns
Patterns that are not suitable for upgrade
Downgrade for rollback using asynchronous replication
Conclusion
I looked back at MySQL versions before the LTS was released.
The EOL date for MySQL 5.7 is October 2023.
Let's think about how we will upgrade the version until then.
SRG is looking for people to work with us.
If you're interested, please contact us here.