Movatterモバイル変換

stop processnodespeccluster_namenodespec:    {nodetype |process_id_list}process_id_list:process_id[,process_id[, ...]]

This command stops the MySQL NDB Cluster processes specified bynodespec in the cluster namedcluster_name. The status of the processes to be stopped, as shown byshow status--process, must berunning.

Suppose that the process ID of a data node in the cluster namedmycluster is3. 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)

Instead of a single node, you can also specify the type of nodes or a list of nodes (must be of the same type) to be stopped. For example:

mcm> stop process mysqld mycluster;+------------------------------+| Command result               |+------------------------------+| Process stopped successfully |+------------------------------+1 row in set (15.70 sec)

mcm> stop process 146,147 mycluster;+------------------------------+| Command result               |+------------------------------+| Process stopped successfully |+------------------------------+1 row in set (3.82 sec)

You can useshow status--process orlist processes 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, ifStopOnError is 0, the MySQL Cluster Manager agent restarts the data node process automatically; ifStopOnError is 1 (the default), then you must execute thestart process command manually.

This command does not work with processes in a cluster created for import where the import has not yet actually been completed. SeeSection 5.4.1, “Thecreate cluster Command”, andSection 4.5, “Importing MySQL NDB Clusters into MySQL Cluster Manager”, for more information.