REMOVE AGGREGATOR
Removes a child aggregator from a cluster.
Syntax
REMOVE AGGREGATOR 'host':port;
Remarks
This command can only be used to remove child aggregators from a cluster; the master aggregator cannot be removed by using this command.
Example
SHOW AGGREGATORS; +-----------+------+--------+--------------------+------------------------------+-------------------+ | Host | Port | State | Opened_Connections | Average_Roundtrip_Latency_ms | Master_Aggregator | +-----------+------+--------+--------------------+------------------------------+-------------------+ | 10.0.2.15 | 3306 | online | 0 | NULL | 1 | | 10.0.2.16 | 3306 | online | 1 | 0.322 | 0 | +-----------+------+--------+--------------------+------------------------------+-------------------+ 2 rows in set (0.00 sec) REMOVE AGGREGATOR '10.0.2.16':3306; Query OK, 0 rows affected (0.00 sec) SHOW AGGREGATORS; +-----------+------+--------+--------------------+------------------------------+-------------------+ | Host | Port | State | Opened_Connections | Average_Roundtrip_Latency_ms | Master_Aggregator | +-----------+------+--------+--------------------+------------------------------+-------------------+ | 10.0.2.15 | 3306 | online | 1 | NULL | 1 | +-----------+------+--------+--------------------+------------------------------+-------------------+ 1 row in set (0.00 sec)
Related Topics