CANCEL REBALANCE DISK

Description

The CANCEL REBALANCE DISK statement is used to cancel the high-priority disk data balancing for Backend (BE) nodes. This statement has the following functionalities:

• It can cancel the high-priority disk balancing for specified BE nodes.
• It can cancel the high-priority disk balancing for all BE nodes in the entire cluster.
• After cancellation, the system will still balance the disk data of BE nodes using the default scheduling method.

Syntax

ADMIN CANCEL REBALANCE DISK [ ON ( "<host>:<port>" [, ... ] ) ];

Optional Parameters

1. "<host>:<port>"

Specifies the list of BE nodes for which the high-priority disk balancing needs to be canceled.

Each node consists of a hostname (or IP address) and a heartbeat port.

If this parameter is not specified, it will cancel the high-priority disk balancing for all BE nodes.

Access Control Requirements

Users executing this SQL command must have at least the following permissions:

Privilege	Object	Notes
ADMIN	System	The user must have ADMIN privileges to execute this command.

Usage Notes

• This statement only indicates that the system will no longer prioritize balancing the disk data of specified BEs; however, the system will still balance BE's disk data using the default scheduling method.
• After executing this command, any previously set high-priority balancing strategy will become immediately invalid.

Examples

• Cancel high-priority disk balancing for all BEs in the cluster:

  ADMIN CANCEL REBALANCE DISK;

• Cancel high-priority disk balancing for specified BEs:

ADMIN CANCEL REBALANCE DISK ON ("192.168.1.1:1234", "192.168.1.2:1234");