18.2.8 Upgrading and Downgrading MySQL Cluster

This section provides information about MySQL Cluster software and table file compatibility between different MySQL Cluster NDB 7.3 releases with regard to performing upgrades and downgrades as well as compatibility matrices and notes. You are expected already to be familiar with installing and configuring a MySQL Cluster prior to attempting an upgrade or downgrade. See Section 18.3, “Configuration of MySQL Cluster”.

Important

Only compatibility between MySQL versions with regard to NDBCLUSTER is taken into account in this section, and there are likely other issues to be considered. As with any other MySQL software upgrade or downgrade, you are strongly encouraged to review the relevant portions of the MySQL Manual for the MySQL versions from which and to which you intend to migrate, before attempting an upgrade or downgrade of the MySQL Cluster software. See Section 2.11.1, “Upgrading MySQL”.

The tables shown here provide information on MySQL Cluster upgrade and downgrade compatibility among different releases of MySQL Cluster NDB 7.3 and of MySQL Cluster NDB 7.4, respectively. Additional notes about upgrades and downgrades to, from, or within the MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4 release series can be found following the tables.

Upgrades and Downgrades, MySQL Cluster NDB 7.4

MySQL Cluster NDB 7.4.x upgrade/downgrade compatibility

Version support.  The following versions of MySQL Cluster are supported for upgrades to MySQL Cluster NDB 7.4 (7.4.4 and later):

Known Issues.  Prior to MySQL Cluster NDB 7.4.4, when upgrading from NDB 7.3 to NDB 7.4, the first new data node binary to be started caused the master node (still running NDB 7.3) to fail, then itself failed. (Bug #20608889)

Prior to MySQL Cluster 7.4.3, mysql_upgrade failed to drop and recreate ndbinfo. (Bug #74863, Bug #20031425) In addition, when running mysql_upgrade on a MySQL Cluster SQL node, the expected drop of the performance_schema database on this node was instead performed on all SQL nodes connected to the cluster. (Bug #200328691)

Upgrades and Downgrades, MySQL Cluster NDB 7.3

MySQL Cluster NDB 7.3.x upgrade/downgrade compatibility

Version support.  The following versions of MySQL Cluster are supported for upgrades to MySQL Cluster NDB 7.3 (7.3.2 and later):

Known Issues.  Prior to MySQL Cluster NDB 7.3.8, mysql_upgrade failed to drop and recreate ndbinfo. (Bug #74863, Bug #20031425) In addition, when running mysql_upgrade on a MySQL Cluster SQL node, the expected drop of the performance_schema database on this node was instead performed on all SQL nodes connected to the cluster. (Bug #200328691)

NDB API, ClusterJ, and other applications used with recent releases of MySQL Cluster NDB 6.3 and later should continue to work with MySQL Cluster NDB 7.3.2 and later without rewriting or recompiling.

It is not possible to downgrade online to MySQL Cluster NDB 7.3.2 or earlier from MySQL Cluster NDB 7.3.3 or later. Online upgrades from MySQL Cluster NDB 7.3.2 to later MySQL Cluster NDB 7.3 releases are supported.

For information about upgrades and downgrades in previous MySQL Cluster release series, see http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-upgrade-downgrade-compatibility-6.x.html, http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-upgrade-downgrade-compatibility-7.x.html, and Upgrading and Downgrading MySQL Cluster NDB 7.2