18.4.5 ndb_mgm — The MySQL Cluster Management Client

The ndb_mgm management client process is actually not needed to run the cluster. Its value lies in providing a set of commands for checking the cluster's status, starting backups, and performing other administrative functions. The management client accesses the management server using a C API. Advanced users can also employ this API for programming dedicated management processes to perform tasks similar to those performed by ndb_mgm.

To start the management client, it is necessary to supply the host name and port number of the management server:

shell> ndb_mgm [host_name [port_num]]

For example:

shell> ndb_mgm ndb_mgmd.mysql.com 1186

The default host name and port number are localhost and 1186, respectively.

The following table includes options that are specific to the MySQL Cluster management client program ndb_mgm. Additional descriptions follow the table. For options common to most MySQL Cluster programs (including ndb_mgm), see Section 18.4.27, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”.

Table 18.80  This table describes command-line options for the ndb_mgm program

Format Description Added or Removed

--try-reconnect=#,

-t

Specify number of tries for connecting to ndb_mgmd (0 = infinite)

All MySQL 5.6 based releases

--execute=name,

-e

Execute command and exit

All MySQL 5.6 based releases


Additional information about using ndb_mgm can be found in Section 18.5.2, “Commands in the MySQL Cluster Management Client”.