Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

REMOVE AGGREGATOR

Info

SingleStore Managed Service does not support this 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.

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