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

This command starts the MySQL Cluster process having the process ID process_id in the cluster named cluster_name. The status of the process to be started, as shown by show status --process, must be added or stopped (see Section 3.6, “The show status Command”).

This example demonstrates how to start the process having the process ID 1 belonging to the cluster mycluster:

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

When the --initial option (short form: -i) is used, MySQL Cluster Manager starts a data node process with the --initial option, causing the data node to rebuild its file system.

Invoking this command with the --added option rather than with a process ID starts all nodes previously added to the cluster using add process, but not yet started.

You can obtain process IDs for all processes in a given cluster using show status --process or list processes (see Section 3.8.5, “The list processes Command”). These are the same as the node IDs for these processes as shown in the output of other mcm client commands such as get (see Section 3.5.1, “The get Command”) or in the output of ndb_mgm -e "show".