Documentation Home
MySQL Cluster Manager 1.4 User Manual
Related Documentation Download this Manual
PDF (US Ltr) - 1.8Mb
PDF (A4) - 1.8Mb


4.6.4 Thestart process Command

start process {[--initial|-i]process_id | --added}cluster_name

This command starts the MySQL NDB Cluster process having the process IDprocess_id in the cluster namedcluster_name. The status of the process to be started, as shown byshow status --process, must beadded,stopped, orfailed (only if the failed process has exited properly can it be restarted with the command).

This example demonstrates how to start the process having the process ID1 belonging to the clustermycluster:

mcm> start process 1 mycluster;+------------------------------+| Command result               |+------------------------------+| Process started successfully |+------------------------------+1 row in set (13.93 sec)

You can obtain process IDs for all processes in a given cluster usingshow status --process orlist processes. These are the same as the node IDs for these processes as shown in the output of othermcm client commands such asget or in the output ofndb_mgm -e "show" (seendb_mgm — The NDB Cluster Management Client).

When the--initial option (short form:-i) is used, the following happens:

  • For a data node process, MySQL Cluster Manager starts it with the--initial option, causing the data node to rebuild its file system.

  • For an SQL node process (only for MySQL Cluster Manager 1.4.2 and later), MySQL Cluster Manager rebuilds themysqld data directory with themysqld--initialize-insecure command for MySQL 5.7 and with themysql_install_db command for MySQL 5.6. The node's data directory must be empty, or the reinitialization will not be attempted.

Invoking this command with the--added option rather than with a process ID starts all nodes that were added previously to the cluster usingadd process but not yet started. For the added data andmysqld nodes, the use of the--added option also implies the use of the--initial option, meaning thatmcmd will attempt to initialize the added nodes (see description for the--initial option above). Also, when the--added option is used, once all the added nodes are running, aCREATE NODEGROUP command is issued to the management node for the creation of new nodegroups.

You cannot use this command to start amysqld process in a stopped or unavailable cluster—trying to do so will cause an error. This applies, for example, to the case in which a cluster has been created for a cluster import, but the import is not yet completed (seeSection 4.4.1, “Thecreate cluster Command”, andSection 3.5, “Importing MySQL NDB Clusters into MySQL Cluster Manager”).