The table shown here provides information on MySQL Cluster upgrade and downgrade compatibility among different releases of MySQL Cluster NDB 7.0 and 7.1. Additional notes about upgrades and downgrades to, from, or within the MySQL Cluster NDB 7.x release series can be found immediately following the table.
Versions supported. Online upgrades from any MySQL Cluster NDB 7.0 release up to and including MySQL Cluster NDB 7.0.4 (as well as all early releases numbered NDB 6.4.x) to MySQL Cluster NDB 7.0.5 or later are not possible. Upgrades to MySQL Cluster NDB 7.0.6 or later from MySQL Cluster NDB 6.3.8 or a later MySQL Cluster NDB 6.3 release, or from MySQL Cluster NDB 7.0.5 or later, are supported. (Bug #44294)
Upgrading ndbd to ndbmtd. When upgrading online from a MySQL Cluster NDB 6.3 release to a MySQL Cluster NDB 7.0 (or later) release, you should not try to upgrade the data nodes from ndbd to ndbmtd at the same time. Instead, perform the upgrade using the new ndbd executable (from the MySQL Cluster NDB 7.0 or later distribution to which you are upgrading) to replace the one in use on the data nodes. Once the version upgrade is complete, you can perform a second (online) upgrade to replace the data node executables with ndbmtd from the newer distribution. Changing the data node binary type should not be an issue when upgrading from MySQL Cluster NDB 7.0 or later version.
Changes in default values.
In MySQL Cluster NDB 7.0.4, the default values for a number of
MySQL Cluster configuration parameters relating to memory
usage and buffering changed (see
for a list of the parameters whose defaults changed). For this
reason, you may encounter issues if you try to use a
configuration that does not explicitly define each of these
buffers (because it was developed for a previous version of
Other known issues include the following:
Prior to MySQL Cluster NDB 7.0.7, DML statements failed if executed while performing an online upgrade from a MySQL Cluster NDB 6.3 release. (Bug #45917)
Following an upgrade from any MySQL Cluster NDB 6.3.x release to MySQL Cluster NDB 7.0.6, DDL and backup operations failed. This issue was resolved in MySQL Cluster NDB 7.0.7. (Bug #46494, Bug #46563)
In some cases, there could be problems with online upgrades from MySQL Cluster NDB 6.3 releases to MySQL Cluster NDB 7.0 releases due to a previous change in the signalling format used between nodes. This issue was corrected in MySQL Cluster NDB 7.0.9.
NDB table had an
TABLE operation performed on it using a MySQL
Cluster NDB 6.3.x release, it could not be upgraded online
to MySQL Cluster NDB 7.0. This issue was resolved in MySQL
Cluster NDB 7.0.8. (See Bug #47542.)
Following an upgrade from MySQL Cluster NDB 6.3 to MySQL
Cluster NDB 7.0, if there were any tables having unique
indexes prior to the upgrade, attempts to create unique
indexes failed. This could also occur when performing
operations on tables having indexes that were not dropped as
a result of the
This issue was due to a change in the way that
NDB tracked unique indexes
internally, and was resolved in MySQL Cluster NDB 7.0.9.
For upgrades to MySQL Cluster NDB 7.0 releases prior to
version 7.0.9, a workaround is available: Following the
upgrade, execute a second rolling
restart of the cluster before before performing any
ALTER TABLE operations
Due to an issue discovered after the release of MySQL Cluster NDB 7.0.10 (Bug #50433), it is not possible to perform an online upgrade from MySQL Cluster NDB 7.0.9b and earlier MySQL Cluster NDB 7.0 releases to MySQL Cluster NDB 7.0.10. Instead, you should upgrade your MySQL Cluster NDB 7.0 installation directly to MySQL Cluster NDB 7.0.11 or later.
This issue did not appear to affect MySQL Cluster NDB 6.3, and it should be possible to upgrade online from MySQL Cluster NDB 6.3 to MySQL Cluster NDB 7.0.10 without any problems other than those noted previously.
It was not possible to perform an online upgrade from a MySQL Cluster NDB 6.3 or 7.0 release to MySQL Cluster NDB 7.1.0 or 7.1.1. This issue was fixed in MySQL Cluster NDB 7.1.2 (see Bug #51429).
Following an upgrade to MySQL Cluster NDB 7.0.15 or later
(MySQL Cluster NDB 7.0), or to MySQL Cluster NDB 7.1.4 or
later (MySQL Cluster NDB 7.1), a table created in a previous
version of MySQL Cluster does not
NDB-native default values. Such
a table continues to use default values supplied by the
MySQL server until it is upgraded by performing an offline
ALTER TABLE on it.
When upgrading to a MySQL Cluster release that supports native default values from a MySQL Cluster release that does not, you should not attempt to create any new tables until all data nodes are using the new ndbd or ndbmtd binaries. This is because the older binaries do not provide support for native default values.
Tables created with native default value support cannot be used with versions of MySQL Cluster that do not support native default values.
NDB API changes in MySQL Cluster NDB 7.1.16 and MySQL Cluster NDB 7.0.27 are not backward compatible. Due to these changes the version of the included NDB client library was increased from 4.0.0 to 5.0.0; NDB API applications must be recompiled as part of any upgrade to these or later MySQL Cluster releases.
In addition, NDB API programs should be updated as part of
such an upgrade, in order to take into account changes in
the default behavior and values for the
Due to issues discovered shortly after release, MySQL Cluster NDB 7.0.20 was withdrawn and replaced with MySQL Cluster NDB 7.0.20a. Users of MySQL Cluster NDB 7.0.19 and previous MySQL Cluster NDB 7.0 releases should upgrade to MySQL Cluster NDB 7.0.20a, or to a later MySQL Cluster NDB 7.0 release. See http://dev.mysql.com/doc/relnotes/mysql-cluster/7.1/en/mysql-cluster-news-5-1-51-ndb-7-0-20a.html, for more information.
Due to issues discovered following release, MySQL Cluster NDB 7.1.15 was withdrawn and replaced with MySQL Cluster NDB 7.1.15a. Users of MySQL Cluster NDB 7.1.14 and previous MySQL Cluster NDB 7.1 releases should upgrade to MySQL Cluster NDB 7.1.15a, or to a later MySQL Cluster NDB 7.1 release. See http://dev.mysql.com/doc/relnotes/mysql-cluster/7.1/en/mysql-cluster-news-5-1-56-ndb-7-1-15a.html, for more information.
Due to issues discovered shortly after release, MySQL Cluster NDB 7.1.9 was withdrawn and replaced with MySQL Cluster NDB 7.1.9a. Users of MySQL Cluster NDB 7.1.8 and previous MySQL Cluster NDB 7.1 releases should upgrade to MySQL Cluster NDB 7.1.14 (the last release directly upgrade-compatible with MySQL Cluster 7.1.18 and earlier) before upgrading to MySQL Cluster 7.1.15a or later. See http://dev.mysql.com/doc/relnotes/mysql-cluster/7.1/en/mysql-cluster-news-5-1-51-ndb-7-1-9a.html, for more information.
When performing an online upgrade or downgrade between MySQL
Cluster NDB 7.1.8 or earlier and a later release up to and
including MySQL Cluster NDB 7.1.14, you must upgrade or
downgrade the data nodes before upgrading or downgrading any
SQL nodes; otherwise mysql_upgrade fails
on the SQL nodes due to differences between
ndbinfo tables used in the
“old” and “new” versions of the
MySQL Cluster software. You should also upgrade or downgrade
the data nodes prior to the SQL nodes when performing an
online upgrade or downgrade between MySQL Cluster NDB 7.1
releases where either of the versions involved is MySQL
Cluster NDB 7.1.14 or earlier, and where one or more
ndbinfo tables has more,
fewer, or differing columns between the two versions.
This issue is resolved in MySQL Cluster NDB 7.1.15. (Bug #11885602)
It was not possible to downgrade online to MySQL Cluster NDB
7.1 from some later versions of MySQL Cluster due to a
change in the size used for table hash maps by
NDB. (Bug #14645319) This issue
was resolved in MySQL Cluster NDB 7.1.26, where the size is
made configurable using the
parameter. (Bug #14800539) See the description of this
parameter for more information.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices