This section describes limitations relating to MySQL NDB Cluster functionality that is unsupported or curtailed by MySQL Cluster Manager 1.4.7.
MySQL Cluster Manager and replication. MySQL Cluster Manager currently does not provide any explicit support for MySQL NDB Cluster Replication. However, you should still be able to perform manual setup of replication of a MySQL NDB Cluster that is managed by MySQL Cluster Manager.
Backup and restore operations.
MySQL Cluster Manager provides integrated backup and restore functionality. You
can back up
NDB databases and
tables using the mcm client
backup cluster command, and
restore them using the
cluster client command. MySQL Cluster Manager also supports
restoration of distributed privileges.
You can also back up
and tables using the ndb_mgm client
START BACKUP command, and restore them using
the ndb_restore program (see
ndb_restore — Restore an NDB Cluster Backup); however
MySQL Cluster Manager is not aware of backups that it was not employed to create.
Both of the programs just mentioned are supplied with the MySQL NDB Cluster
distribution; for more information, see
Online Backup of NDB Cluster, and
ndb_restore — Restore an NDB Cluster Backup.
Backups of tables using storage engines other than
NDB, as well as of all other
database objects which are not tables, cannot be made using
MySQL Cluster Manager, and must be made using some other method, such as
mysqldump. (See mysqldump — A Database Backup Program.)
Rolling restarts. Currently, all cluster nodes must be running in order to perform a rolling restart using MySQL Cluster Manager. However, MySQL NDB Cluster itself requires only that at least one management server and all data nodes are running (in other words, any mysqld processes and any additional ndb_mgmd processes can be stopped). In such cases, you can perform the rolling restart manually, after stopping the MySQL Cluster Manager agent.
When making changes in configuration attributes only those nodes
requiring a restart to make the change take effect are actually
ndbapi nodes are never restarted by
MySQL Cluster Manager.
Cluster Imports. MySQL Cluster Manager will reject an import if it cannot access the process information of the cluster being imported. Therefore, the MySQL Cluster Manager agents must be run by a sufficiently privileged user—normally the same user that runs the cluster.
Cluster configuration updates (using the
reset command) that would
trigger a rolling restart of the nodes are not executed by MySQL
Cluster Manager unless there are more than one data node defined
for each node group; to perform such updates when the
requirement is not met, a user should, using MySQL Cluster
Manager, stop the cluster, use the
reset command to change the
cluster configurations, and then start the cluster again. If,
however, your configuration changes require an
of your cluster, you will need to backup the data, recreate your
cluster form scratch with the new settings, and then restore
your old data onto it.