3.8.3. The stop process Command

stop process process_id cluster_name

This command stops the running MySQL Cluster process with the process ID process_id in the cluster named cluster_name. The status of the process as shown by show status --process must be running (see Section 3.6, “The show status Command”).

For example, suppose that the process ID of a data node in the cluster named mycluster is 3. Then this data node can be stopped as shown here:

mcm> stop process 3 mycluster;
| Command result               |
| Process stopped successfully |
1 row in set (33.07 sec)

You can use show status --process or list processes (see Section 3.8.5, “The list processes Command”) to obtain process IDs for all processes in a given cluster.

In the event of a disk failure where MySQL Cluster Manager loses its manager directory (including its repository), the agent is able to recover information from other agents, but it does not actually control processes any longer, although it can detect them. This is due to the fact that the MySQL Cluster Manager agent cannot access the PID files. In this case, stop process no longer works, and you must kill such processes manually. Keep in mind that, if StopOnError is set to 0, the MySQL Cluster Manager agent restarts the data node process automatically; if StopOnError is 1 (the default), then you must execute the start process command manually.