# remove-leaf

## Description

Removes a leaf node from the cluster without deleting its data.

This command runs the [REMOVE LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/remove-leaf.md) command on the Master Aggregator, which rebalances the leaf node’s partitions into the remaining cluster, and transitions the leaf node to the `unknown` state.

A leaf node that has been removed can be added back to the cluster, without any loss of data, by using the [sdb-admin add-leaf](https://docs.singlestore.com/db/v9.1/reference/singlestore-tools-reference/sdb-admin-commands/add-leaf.md) command.

To completely remove a leaf node and its data, refer to the [sdb-admin delete-node](https://docs.singlestore.com/db/v9.1/reference/singlestore-tools-reference/sdb-admin-commands/delete-node.md) command.

## Usage

```
Usage:
  sdb-admin remove-leaf [flags]

  For flags that can accept multiple values (indicated by VALUES after the name of the flag),
  separate each value with a comma.

Flags:
      --force                Disable automatic rebalance
  -h, --help                 Help for remove-leaf
      --host string          The cluster-addressable hostname for the leaf node
      --memsql-id MemsqlID   The node ID of the leaf node to be removed
      --port PORT            The cluster-addressable port for the leaf node

Global Flags:
      --backup-cache FILE_PATH                File path for the backup cache
      --cache-file FILE_PATH                  File path for the Toolbox node cache
  -c, --config FILE_PATH                      File path for the Toolbox configuration
      --disable-colors                        Disable color output in console, which some terminal sessions/environments may have difficulty with
      --disable-spinner                       Disable the progress spinner, which some terminal sessions/environments may have issues with
  -j, --json                                  Enable JSON output
      --parallelism POSITIVE_INTEGER          Maximum number of operations to run in parallel
      --runtime-dir DIRECTORY_PATH            Where to store Toolbox runtime data
      --ssh-control-persist SECONDS           Enable SSH ControlPersist and set it to the specified duration in seconds
      --ssh-max-sessions POSITIVE_INTEGER     Maximum number of SSH sessions to open per host, must be at least 3
      --ssh-strict-host-key-checking          Enable strict host key checking for SSH connections
      --ssh-user-known-hosts-file FILE_PATH   Path to the user known_hosts file for SSH connections. If not set, /dev/null will be used
      --state-file FILE_PATH                  Toolbox state file path
  -v, --verbosity count                       Increase logging verbosity: valid values are 1, 2, 3. Usage -v=count or --verbosity=count
  -y, --yes                                   Enable non-interactive mode and assume the user would like to move forward with the proposed actions by default

```

## Remarks

This command is interactive unless you use either `--yes` or `--json` flag to override interactive behavior.

***

Modified at: October 6, 2023

Source: [/db/v9.1/reference/singlestore-tools-reference/sdb-admin-commands/remove-leaf/](https://docs.singlestore.com/db/v9.1/reference/singlestore-tools-reference/sdb-admin-commands/remove-leaf/)

(An index of the documentation is available at /llms.txt)