MySQL 8.4 has been released, but MHA and Orchestrator are not available
This is Onkai Yuta (@fat47) from the Service Reliability Group (SRG) of the Media 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 summarizes the release of MySQL 8.4, the first LTS version of MySQL 8, and the functional changes that have resulted in MHA becoming unavailable.
I hope this helps in some way.
MySQL 8.4, the first LTS release for the MySQL 8 seriesThings I noticed in the MySQL 8.4 release notesMHA is not available?What about Orchestrator?Conclusion
MySQL 8.4, the first LTS release for the MySQL 8 series
MySQL 8.4 was released on April 30, 2024.
MySQL 8.4 support period is 5 years of Premier Support and 3 years of Extended Support
It is expected to be available until 2032 at the latest. Long!
Things I noticed in the MySQL 8.4 release notes
[mysqld]mysql_native_password=ON SHOW MASTER LOGSCommands containing MASTER or SLAVEAll have been replaced and are no longer available。
An example:
| Old Commands | New Commands |
|---|---|
| START SLAVE | START REPLICA |
| SHOW SLAVE STATUS | SHOW REPLICA STATUS |
| CHANGE MASTER TO | CHANGE REPLICATION SOURCE TO |
| RESET MASTER | RESET BINALY LOGS AND GTIDS |
MHA is not available?
MySQL MHA is a third-party tool that allows you to create HA configurations, but it has not been updated since version 0.58 in 2018.
CHANGE MASTERI tried replacing the SLAVE and MASTER strings in a very rough way, but it no longer recognized the replica server properly.
It seems like there's a bug somewhere, but even if it works, I'm not sure if it's really okay.
What about Orchestrator?
Orchestrator is also a third-party tool that can be used to set up HA configurations, but it has not been released since 2021.
This is also not currently supported and cannot be executed.
It seems that this version is currently being used in more environments, so I think we can expect a corrected version to be released.
Conclusion
In MySQL 8.4, the words SLAVE and MASTER have finally been removed.
As a result, it seems likely that there are other cases where various tools that were previously working are no longer usable, so it will be difficult to upgrade immediately.
I'd like to investigate this a little more carefully.
SRG is looking for people to work with us.
If you're interested, please contact us here.