You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

REMOVE AGGREGATOR

Info

MemSQL Helios 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

memsql> 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)

memsql> REMOVE AGGREGATOR '10.0.2.16':3306;
Query OK, 0 rows affected (0.00 sec)

memsql> 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