# Cluster Management Commands ## Node Requirements for SingleStore Commands SingleStore commands must be run on the appropriate type(s) of node in a SingleStore cluster. When `sync_permissions` and `enable_query_forwarding` are set to `ON`, all Data Definition Language (DDL) commands can be forwarded from child aggregator to master. This list of requirements reflects this behavior. For more information about these variables, see the [Sync Variables Lists](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables/list-of-engine-variables/#sync-variables-lists.md). * X = recommended to run on this type of node * P = possible (but not recommended) to run on this type of node * blank = cannot run on this type of node | SingleStoreCommand | Master Aggregator | Child Aggregator | Leaf | | ---------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------- | ---------------- | ---- | | [ADD AGGREGATOR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/add-aggregator.md) | X | X | | | [AGGREGATOR SET AS MASTER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/aggregator-set-as-master.md) | | X | | | [ANALYZE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/analyze.md) | X | X | | | [ADD LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/add-leaf.md) | X | | | | [ALTER DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/alter-database.md) | X | X | | | [ALTER RESOURCE POOL](https://docs.singlestore.com/db/v9.1/reference/sql-reference/resource-pool-commands/alter-resource-pool.md) | X | X | | | [ALTER TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/alter-table.md) | X | X | P | | [ALTER VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/alter-view.md) | X | X | P | | [ALTER USER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/alter-user.md) | X | X | | | [ATTACH LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/attach-leaf.md) | X | X | | | [ALTER PIPELINE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/alter-pipeline.md) | X | X | | | [BACKUP DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/backup-database.md) | X | X | | | [BEGIN](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/begin.md) | X | X | P | | [BOOTSTRAP AGGREGATOR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/bootstrap-aggregator.md) | X | X | | | [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) | X | X | P | | [CONTINUE REPLICATING](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/continue-replicating.md) | P | P | P | | [CREATE AGGREGATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/create-aggregate.md) | X | X | | | [CREATE DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-database.md) | X | X | P | | [CREATE FUNCTION](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/create-function-udf.md) | X | X | | | [CREATE GROUP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/create-group.md) | X | X | | | [CREATE INDEX](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-index.md) | X | X | P | | [CREATE PIPELINE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/create-pipeline.md) | X | X | | | [CREATE PROCEDURE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/create-procedure.md) | X | X | | | [CREATE RESOURCE POOL](https://docs.singlestore.com/db/v9.1/reference/sql-reference/resource-pool-commands/create-resource-pool.md) | X | X | | | [CREATE ROLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/create-role.md) | X | X | | | [CREATE TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-table.md) | X | X | P | | [CREATE USER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/create-user.md) | X | X | | | [CREATE VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-view.md) | X | X | | | [DELETE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/delete.md) | X | X | P | | [DESCRIBE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/describe.md) | X | X | X | | [DETACH LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/detach-leaf.md) | X | X | | | [DROP AGGREGATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/drop-aggregate.md) | X | X | | | [DROP DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-database.md) | X | X | P | | [DROP FUNCTION](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/drop-function.md) | X | X | | | [DROP GROUP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/drop-group.md) | X | X | | | [DROP INDEX](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-index.md) | X | X | P | | [DROP PIPELINE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/drop-pipeline.md) | X | X | | | [DROP PROCEDURE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/drop-procedure.md) | X | X | | | [DROP RESOURCE POOL](https://docs.singlestore.com/db/v9.1/reference/sql-reference/resource-pool-commands/drop-resource-pool.md) | X | X | | | [DROP ROLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/drop-role.md) | X | X | | | [DROP TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-table.md) | X | X | P | | [DROP RESULT TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-result-table.md) | X | X | | | [DROP USER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/drop-user.md) | X | X | X | | [DROP VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-view.md) | X | X | P | | [DROP … FROM PLANCACHE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-from-plancache.md) | X | X | P | | [EXPLAIN](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/explain.md) | X | X | X | | [EXTRACT PIPELINE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/extract-pipeline-into-outfile.md) | X | X | | | [FLUSH TABLES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/flush-tables.md) | X | | P | | [GRANT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/grant.md) | X | X | X | | [GRANT GROUP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/grant-group.md) | X | X | X | | [GRANT ROLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/grant-role.md) | X | X | X | | [INSERT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/insert.md) | X | X | P | | [KILL CONNECTION](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/kill-connection-and-kill-query.md) | X | X | P | | [KILLALL QUERIES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/killall-queries.md) | X | X | P | | [LOAD DATA](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/load-data.md) | X | X | P | | [OPTIMIZE TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/optimize-table.md) | X | X | P | | [PAUSE REPLICATING](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/pause-replicating.md) | P | P | P | | [PROMOTE AGGREGATOR … TO MASTER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/promote-aggregator-to-master.md) | X | X | | | [PROFILE PIPELINE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/profile-pipeline.md) | X | X | | | [REBALANCE PARTITIONS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/rebalance-partitions.md) | X | X | | | [REMOVE AGGREGATOR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/remove-aggregator.md) | X | X | | | [REMOVE LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/remove-leaf.md) | X | X | | | [REPAIR DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/repair-database.md) | X | X | X | | [REPLACE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/replace.md) | X | X | P | | [REPLICATE DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/replicate-database.md) | P | P | P | | [RESTORE DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/restore-database.md) | X | X | | | [RESTORE REDUNDANCY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/restore-redundancy.md) | X | X | | | [ROLLBACK](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/rollback.md) | X | X | P | | [REVOKE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/revoke.md) | X | X | | | [REVOKE GROUP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/revoke-group.md) | X | X | | | [REVOKE ROLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/revoke-role.md) | X | X | | | [SELECT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/select.md) | X | X | P | | [SET GLOBAL](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/set-global.md) | X | X | P | | [SHOW AGGREGATORS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/show-aggregators.md) | X | X | | | [SHOW COLUMNS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-columns.md) | X | X | | | [SHOW CREATE TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-create-table.md) | X | X | P | | [SHOW DATABASES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-databases.md) | X | X | P | | [SHOW GRANTS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-grants.md) | X | X | X | | [SHOW INDEX](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-index-show-indexes-show-keys.md) | X | X | P | | [SHOW INDEXES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-index-show-indexes-show-keys.md) | X | X | P | | [SHOW KEYS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-index-show-indexes-show-keys.md) | X | X | | | [SHOW LEAVES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/show-leaves.md) | X | X | | | [SHOW PLANCACHE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-plancache.md) | X | X | X | | [SHOW PROCESSLIST](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-processlist.md) | X | X | X | | [SHOW REPLICATION STATUS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/show-replication-status.md) | X | X | X | | [SHOW SCHEMAS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-schemas.md) | X | X | P | | [SHOW GLOBAL STATUS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-global-status.md) | X | X | X | | [SHOW GLOBAL VARIABLES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-variables.md) | X | X | X | | [SHOW RESOURCE POOLS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/resource-pool-commands/show-resource-pools.md) | X | X | P | | [SHOW SESSION STATUS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-session-status.md) | X | X | X | | [SHOW SESSION VARIABLES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-variables.md) | X | X | X | | [SHOW STATUS EXTENDED](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-status-extended.md) | X | X | X | | [SHOW TABLE STATUS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-table-status.md) | X | X | X | | [SHOW TABLES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-tables.md) | X | X | X | | [SHOW VARIABLES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-variables.md) | X | X | X | | [SHOW WARNINGS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-warnings.md) | X | X | X | | [SHOW ERRORS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-errors.md) | X | X | X | | [START PIPELINE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/start-pipeline.md) | X | X | | | [STOP PIPELINE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/stop-pipeline.md) | X | X | | | [STOP REPLICATING](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/stop-replicating.md) | X | X | X | | [TRUNCATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/truncate.md) | X | X | | | [UNLOCK TABLES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/unlock-tables.md) | X | | | | [UPDATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/update.md) | X | X | P | | [USE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/use.md) | X | X | P | ## Leaf States Each leaf is in one of the following states: | State | Description | | ------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `Unknown` | In this state, a leaf is not part of thecluster.This is the state before you run[ADD LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/add-leaf.md)to introduce the leaf into the system. A leaf that is unknown will not show up in[SHOW LEAVES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/show-leaves.md). The[REMOVE LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/remove-leaf.md)command will transition a leaf into the`unknown`state. | | `Online` | This is the default, healthy state of a leaf. In the`online`state, the leaf is an active member of the distributed system and is either currently serving or ready to serve data to the aggregators. | | `Offline` | The master aggregator periodically sends a heartbeat (ping) to all the nodes in aclusterto determine if they are responsive and online. A leaf enters the`offline`state if the master aggregator cannot reach it. The heartbeat frequency is based on typical network latencies and node responsiveness. It is set to a default of 150ms which has been empirically determined.If theclusteris in redundancy 2 any partitions on the`offline`node will be failed over to the leaves pair. The master aggregator continues to ping`offline`nodes to detect when they should be moved into the`attaching`state.See[How Failover is Triggered in HA](https://docs.singlestore.com/db/v9.1/reference/troubleshooting-reference/how-failover-is-triggered-in-ha.md)for failover cases. | | `Recovering` | Not online, and not available for read or write queries. A leaf in`recovering`state has been restarted and is replaying data back into memory. | | `Detached` | In this state, the leaf is detached from thecluster.A leaf transitions from`online`to`detached`when[DETACH LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/detach-leaf.md)is run. You can reintroduce the leaf into the`online`state with the[ATTACH LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/attach-leaf.md)command. This command will automatically try to reuse the data present on the leaf; this is especially important in redundancy-1. DETACH LEAF is the same as REMOVE LEAF except that after rebalancing away a leaf’s partitions, it transitions it to`detached`instead of`unknown`. | | `Attaching` | A leaf transitions from`offline`to`attaching`when it is once again reachable by heartbeats.The master aggregator will automatically run[ATTACH LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/attach-leaf.md)to attach any partitions on the leaf back into thecluster. While the attach is running the leaf will stay in the`attaching`state. When the attach is finished the leaf will move to the`online`state. | The following diagram summarizes the leaf states and the transitions between them. ![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blt4f2b0cf749e87065/6a354939da0ad41c6853542a/16083b57986b1b-Dh05TG.png) ## In this section * [ADD AGGREGATOR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/add-aggregator.md) * [ADD LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/add-leaf.md) * [AGGREGATOR SET AS MASTER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/aggregator-set-as-master.md) * [ATTACH LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/attach-leaf.md) * [ATTACH LEAF ALL](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/attach-leaf-all.md) * [BOOTSTRAP AGGREGATOR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/bootstrap-aggregator.md) * [DETACH LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/detach-leaf.md) * [EXPLAIN REBALANCE ALL DATABASES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/explain-rebalance-all-databases.md) * [EXPLAIN REBALANCE PARTITIONS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/explain-rebalance-partitions.md) * [EXPLAIN RESTORE REDUNDANCY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/explain-restore-redundancy.md) * [FILL and FLUSH CONNECTION POOLS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/fill-and-flush-connection-pools.md) * [FLUSH EXTRACTOR POOLS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/flush-extractor-pools.md) * [FLUSH HOSTS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/flush-hosts.md) * [PROMOTE AGGREGATOR … TO MASTER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/promote-aggregator-to-master.md) * [REBALANCE ALL DATABASES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/rebalance-all-databases.md) * [REBALANCE PARTITIONS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/rebalance-partitions.md) * [REMOVE AGGREGATOR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/remove-aggregator.md) * [REMOVE LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/remove-leaf.md) * [RESTORE REDUNDANCY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/restore-redundancy.md) * [SHOW AGGREGATORS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/show-aggregators.md) * [SHOW LEAVES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/show-leaves.md) * [SHOW CLUSTER STATUS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/show-cluster-status.md) * [SHOW REBALANCE ALL DATABASES STATUS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/show-rebalance-all-databases-status.md) * [SHOW REBALANCE STATUS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/show-rebalance-status.md) * [TRIGGER GC](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/trigger-gc.md) *** Modified at: November 18, 2025 Source: [/db/v9.1/reference/sql-reference/cluster-management-commands/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/) (An index of the documentation is available at /llms.txt)