4.2 MySQL Cluster Manager Site and Agent Commands

4.2.1 The add hosts Command

4.2.2 The remove hosts Command

4.2.3 The change log-level Command

4.2.4 The rotate log Command

4.2.5 The collect logs Command

4.2.6 The create site Command

4.2.7 The delete site Command

4.2.8 The list sites Command

4.2.9 The list hosts Command

4.2.10 The show settings Command

4.2.11 The stop agents Command

4.2.12 The version Command

4.2.13 The show warnings Command

In this section, we discuss commands used to work with MySQL Cluster Manager management sites. In addition, the stop agents, show settings, version, and show warnings commands, which relate to management agents, are also covered in this section.

A site, in terms of MySQL NDB Cluster and MySQL Cluster Manager, is a collection of one or more host computers where MySQL Cluster Manager agents are running. Each agent is identified by the combination of two pieces of information:

• The hostname or IP address of the machine where the agent is running

• The number of the port used by the agent for communications

Note

MySQL NDB Cluster makes extremely intensive use of network connections, and DNS lookups can contend with MySQL NDB Cluster and MySQL Cluster Manager for bandwidth, resulting in a negative impact on the performance of MySQL NDB Cluster and the applications using it. For this reason, we recommend that you use numeric IP addresses rather than hostnames for MySQL NDB Cluster and MySQL Cluster Manager host computers whenever feasible.