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.
This command causes implicit commits. See COMMIT for more information.
See the Permission Matrix for the required permission.
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