Skip to main content

SingleStoreDB v8.1

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

In this section: