Details of the MySQL Cluster Manager 1.4.0 release

MySQL_Cluster_ManagerWe just announced availability of MySQL Cluster Manager 1.4.0! In this post we’ll highlight some details of the MCM 1.4.0 release.

Based on MySQL 5.6
MySQL Cluster Manager is part of the commercial MySQL Cluster offering from Oracle. MCM 1.4.0 is now based on the tried and tested MySQL 5.6 release. Earlier releases of MCM were based on MySQL 5.5. Another noteworthy point is we have updated the version of glib to a more recent 2.44.

MySQL Cluster 7.4.8 bundled
As with any MCM release, we bundle the latest commercial MySQL Cluster release. For MCM 1.4.0 this was MySQL Cluster 7.4.8.

Retrying failed upgrades
Most importantly we’ve relaxed the criteria for when to allow a upgrade cluster command. There are also two new options available, –retry and –nodeid.
With –retry you can rerun an upgrade, even for completed nodes should you need to.  Issuing “upgrade cluster –retry –package=x.y.z mycluster” will rerun the upgrade, for all nodes, from the beginning. Using the –nodeid option you can specify the list of nodes for which to retry the upgrade. This is useful in case an upgrade failed for whatever reason, such as a mysqld that did not start properly,  or the mysql_upgrade script execution failed.

Wildcards on get command
With MCM 1.4.0 you can now use wildcards in the get command. There are lots of knobs and dials available in MySQL and MySQL Cluster, so you’re excused for not remembering or knowing the name of all of them.
The wildcards are perfect for the case when you can’t really remember the full name of the config attribute. Using the wildcard character ‘*’ (asterisk), you can match none, one, or more characters or patterns of the config attribute.  Please note that the wildcards only apply for get, not for the set command.

Example 1: “It was something with max and indexes“:

Example 2: “It was something with wait and time”:
Quite helpful, if we may!

Autotuning MySQL Cluster
MCM 1.4.0 has a new autotune command that will automatically tune certain cluster config attributes according to the selected use-case, writeload, and certain other existing settings.
The available tuning templates, and the tuning rules applied, are the same as in the MySQL Cluster auto-installer (MCC) that ships with MySQL Cluster. Further details and examples are available in the autotune doc entry.

Bugfixes
We’ve also fixed bugs in this release. For a more detailed list, please have a look at the

Want to know more?
You can read more about MCM on the documentation page, and there is also a recently refreshed MCM whitepaper. MCM binaries are available for download from either My Oracle Support or eDelivery.

About Thomas Nielsen

Thomas Nielsen is a software engineer, and the Team Lead for MySQL Cluster Manager, at Oracle. He has worked on different high availability products and technologies in databases, as well as JavaDB, before joining the MySQL Cluster team. He holds an engineering degree from the Norwegian University of Science and Technology, and his past-time passion is gliding instruction and cross country soaring.

Leave a Reply

Your email address will not be published. Required fields are marked *

Please enter. * Time limit is exhausted. Please reload CAPTCHA.