4.2.1 The add hosts Command

add hosts  --hosts=host_list site_name

host_list:
    host[, host[, ...]]

This command adds one or more hosts to an existing management site. Agents using the same port as the management site must be running on any hosts added using this command. It takes as arguments a required option --hosts, whose value is a comma-separated list of one or more hosts to be added to the site, and the name of the site to which the hosts are to be added.

For example, the following command adds two hosts named torsk and kolja to management site mysite:

mcm> add hosts --hosts=torsk,kolja mysite;
+--------------------------+
| Command result           |
+--------------------------+
| Hosts added successfully |
+--------------------------+
1 row in set (0.48 sec)

None of the hosts added by this command may already be members of management site site_name.

It is not currently possible using MySQL Cluster Manager to drop or delete hosts from a management site.

Notes
  • This command does not support the --force option.

  • Do not use localhost in the host list, as MySQL Cluster Manager relies on the operating system for host name resolution, and localhost might be resolved differently on different systems. Use proper host names for the host list or, preferably, use the IP addresses for the hosts instead.

  • When IPv6-enabled Windows systems are used as MySQL Cluster hosts under MySQL Cluster Manager, you must reference these hosts using IPv4 addresses. Otherwise, MySQL Cluster Manager will be unable to connect to the agent processes on those hosts. See Section 5.1, “MySQL Cluster Manager Usage and Design Limitations”.