MySQL 8.4 has been released, but MHA and Orchestrator cannot be used
This is Onkai Yuta (@fat47) from the Service Reliability Group (SRG) of the Media 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 summarizes the release of MySQL 8.4, the first LTS version of the MySQL 8 series, and the changes in its functionality that have resulted in MHA no longer being available.
I hope this helps in some way.
MySQL 8.4 released as the first LTS version of MySQL 8Things I noticed in the MySQL 8.4 release notesMHA is not available?What about Orchestrator?Conclusion
MySQL 8.4 released as the first LTS version of MySQL 8
MySQL 8.4 was released on April 30, 2024.
MySQL 8.4 support period is 5 years Premier Support and 3 years Extended Support
It is expected to be available until 2032. That's 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 set up 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 careless way, but the replica server was no longer recognized properly.
It seems like there's a fix I missed somewhere, but even if it does work, 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 also has not had a release 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, there are likely other cases where various tools that were previously working are no longer usable, so it may be difficult to upgrade immediately.
I'd like to investigate this a bit more carefully.
SRG is looking for people to work with us. If you are interested, please contact us here.