ATTACH LEAF ALL

On this page

Attaches all leaves in a cluster that are currently in the detached state.

Syntax

SQL

ATTACH LEAF ALL [FORCE] [NO REBALANCE]

Remarks

ATTACH LEAF ALL is equivalent to running ATTACH LEAF on every leaf in a cluster that is currently in the detached state. If you want the leaves to fully rebalance after reattaching, you must run REBALANCE PARTITIONS afterward. This will rebalance and synchronize all partitions in one operation.

To avoid the partial rebalance that is run automatically (after attach_rebalance_delay_seconds), use ATTACH LEAF ALL NO REBALANCE.
FORCE is optional. Using FORCE overrides any conflicts that would prevent ATTACH LEAF ALL from running. In practice, this happens when the data on the leaf has diverged away from the current state of the cluster (for example, a database was recreated while the leaf was down).
Detached leaves automatically reattach. To disable this feature, set the global variable auto_attach to false. For more information see SET GLOBAL .
This command must be run on the master aggregator node (see Node Requirements for SingleStore Commands ).
This command causes implicit commits. Refer to COMMIT for more information.
Refer to the Permission Matrix for the required permissions.

Example

SQL

ATTACH LEAF ALL;

Query OK, 1 row affected (0.99 sec)

Related Topics

ATTACH LEAF

Last modified: July 31, 2023

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

(Optional) Run the following command to view the associated signature files.
Shell
```
curl undefined
```
Download the signature file from the SingleStore release server.
- Option 1: Click the Download Signature button next to the SingleStore file.
- Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.
- Option 3: Run the following command to download the signature file.
  Shell
```
curl -O undefined
```

After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

Shell

echo -n undefined |
    cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
      --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
      --bundle undefined \
      --new-bundle-format -

Verified OK