MySQL 8.4 has been released, but it seems that MHA and Orchestrator are not supported.
This is Yuta Kikai (@fat47) from the Service Reliability Group (SRG) of the Media 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 summarizes the changes in MySQL 8.4, the first LTS (Long-Term Support) version of MySQL 8, which have rendered MHA (MySQL Home Access) unusable.
I hope this is of some help.
MySQL 8.4, the first LTS release in the MySQL 8 series, has been released.Things that caught my attention in the MySQL 8.4 release notesMHA is unavailable!?What about Orchestrator?In conclusion
MySQL 8.4, the first LTS release in the MySQL 8 series, has been released.
MySQL 8.4 was released on April 30, 2024.
MySQL 8.4 has a support period of 5 years of Premier Support and 3 years of Extended Support.
It is expected to be available until 2032 at the latest. That's a long time!
Things that caught my attention in the MySQL 8.4 release notes
[mysqld]mysql_native_password=ON SHOW MASTER LOGSCommands that include MASTER and SLAVEAll have been replaced and are no longer usable.。
Example:
| Old command | New Command |
|---|---|
| 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 unavailable!?
MySQL MHA is a third-party tool that allows you to configure HA (High Availability) settings, but it hasn't been updated since version 0.58 in 2018.
CHANGE MASTERI tried replacing the strings "SLAVE" and "MASTER" in a very haphazard way, but now it no longer recognizes the replica server properly.
There seems to be some overlooked correction somewhere, and even if it does work, I'm skeptical about whether it's really safe.
What about Orchestrator?
Orchestrator is another third-party tool that can also be used to configure HA (High Availability) systems, but it hasn't been released since 2021.
This feature is not currently supported and cannot be executed.
Since this version seems to be used more widely these days, I think we can expect a revised version to be released.
In conclusion
In MySQL 8.4, terms like SLAVE and MASTER have finally been removed.
It seems that this will cause various tools that were working before to stop working, so upgrading immediately might be difficult.
I'd like to investigate this a bit more carefully.
SRG is looking for new team members.
If you are interested, please contact us here.