REBALANCE ALL DATABASES

On this page

Rebalances the partitions on all databases in the cluster.

Syntax

SQL

REBALANCE ALL DATABASES[KILL];

Remarks

This command runs REBALANCE PARTITIONS ... FULL on each database in the cluster, in alphabetical order of the database name. When REBALANCE PARTITIONS ... FULL runs on a database d, it first considers the placement of the partitions of the other databases in the cluster before rebalancing the partitions of d. Refer to REBALANCE PARTITIONS for an example of REBALANCE PARTITIONS ... FULL.
KILL prevents persistent long running write queries from blocking a clustering option for an arbitrarily long time (for example, a scale up or scale down or even an upgrade). Auto-rebalances automatically use the KILL mode if the auto-rebalance fails to run after three attempts.
To see the status of running this command, run SHOW REBALANCE ALL DATABASES STATUS. You can also run EXPLAIN REBALANCE ALL DATABASES to see the series of steps that the command REBALANCE ALL DATABASES would run, if you executed it.

Last modified: December 2, 2024

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