About SRGArticlesRecruitment Information
About SRGArticlesRecruitment Information
HOME/Articles/What we know now about the MySQL 8.1 Innovation Release and existing MySQL 8.0.x and Long-Term Support (LTS) versions

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) mainly provides cross-sectional support for the infrastructure of our media services, improving existing services, launching new ones, contributing to OSS, etc.
This article is located in SRGDBWGWe will publish materials regarding the database that the (DB Working Group) provides to the entire company.
I hope this helps in some way.
 

overview

July 18, 2023MySQL8.1andMySQL8.0.34has been released.
Up until now, even though MySQL 8.0 releases have been minor versions, features have been added and removed frequently, making it difficult to keep up with the versions.
 
Starting with this release, there are Innovation Releases, which add or remove features, and Releases that only fix bugs.
In addition,Long-Term Support(LTS)It was announced that MySQL will be released.
 
I have summarized the characteristics of each and what we currently know about them.
However, the following article covers most of the content, so you might want to read that instead.
 
On this page, I will focus on the EOL and upgrade-related issues that our team will be dealing with.

Summary of each version

For the time being, MySQL will have three different versions.
VersionremarksEOL
MySQL 8.x ( Innovation ) Innovation Release adds new featuresUntil the next MySQL8.y is released (approximately 3 months)
MySQL 8.0.xBug fixes onlyApril 2026
MySQL 8.x (LTS) *Not yet releasedLTS released every two years8 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.
Although you will need to upgrade each time, in return you will be able to take advantage of the latest features and improvements.
MySQL 8.1 has currently been released, 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 the EOL of the conventional MySQL 8.0 series in April 2026.
There is a grace period of approximately two years or more from the current date.

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 are released every three months, then MySQL 8.4 will be released as an LTS.
 
When an LTS is released, the major version number of the Innovation Release is incremented, so the next Innovation Release will be MySQL 9.0.0.
Oracle MySQL Blog [MySQLの Innovation と Long-Term Support (LTS) バージョンのご紹介]より引用
Oracle MySQL Blog [Excerpt from Introducing MySQL Innovation and Long-Term Support (LTS) Versions

Upgrade Possibility

Basically, like previous MySQL versions, upgrades up to one generation are supported.
It may be a little confusing since multiple versions are mixed together from now on, but here is an example.

Upgradeable Patterns

 

Patterns that are not suitable for upgrade

 

Downgrade with asynchronous replication for fallback

 

Conclusion

I took a look back at MySQL versions before the LTS was released.
The EOL for MySQL 5.7 is October 2023.
Before that, think about how you will upgrade your version.
 
SRG is looking for people to work with us. If you are interested, please contact us here.