4.2.9 The list hosts Command

list hosts [--verbose|-v]  site_name

The list hosts command is used to obtain a list of the hosts comprising a given management site. The command requires a single argument, the name of the site to be examined. For each host listed, the information returned includes the hostname, status, and version of the management agent software in use, as shown in this example:

mcm> list hosts mysite;
+-----------+-----------+---------+
| Host      | Status    | Version |
+-----------+-----------+---------+
| tonfisk   | Available | 1.4.8   |
+-----------+-----------+---------+
| flundra   | Available | 1.4.8   |
+-----------+-----------+---------+
2 rows in set (0.16 sec)

Status can be one of :

• Available: Agent on the host is active

• Recovery: Agent on the host is in the process of recovering itself (for MySQL Cluster Manager 1.4.7 and later)

• Unresponsive: Agent on the host rejected an attempt to connect (for MySQL Cluster Manager 1.4.7 and later).

• Unavailable: Agent on the host is unreachable

If an agent is reported persistently as Unresponsive or Unavailable, you may have to restart it.

If you omit the site_name argument, the command fails with an error, as shown here:

mcm> list hosts;
ERROR 6 (00MGR): Illegal number of operands

Using the --verbose option (short form : -v) causes the command to print additional information on the hosts:

mcm> list hosts --verbose mysite;
+---------+-----------+---------+-------+---------+-------------------------------+
| Host    | Status    | Version | Cores | Memory  | OS                            |
+---------+-----------+---------+-------+---------+-------------------------------+
| tonfisk | Available |  1.4.8  | 1     | 1819 Mb | Linux 3.13.11-100.fc19.x86_64 |
| flundra | Available |  1.4.8  | 1     | 1819 Mb | Linux 3.13.11-100.fc19.x86_64 |
+---------+-----------+---------+-------+---------+-------------------------------+
2 rows in set (0.07 sec)