Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
REMOVE AGGREGATOR
On this page
The REMOVE AGGREGATOR command 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.
Refer to COMMIT for more information. -
Refer to the Permissions Matrix for the required permissions.
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
Last modified: