Note
This parameter is available since OceanBase Database V4.2.1.
Description
enable_transfer specifies whether to allow transfer within a tenant. This parameter is invalid when enable_rebalance is set to False.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | True |
| Value range |
|
| Effective upon OBServer node restart | No |
Considerations
You can dynamically adjust the number of log streams for a tenant based on the load balancing algorithm and enable automatic leader balancing and partition balancing in the tenant as follows:
enable_rebalance=true; enable_transfer=true;You can balance existing log streams without transfer or dynamic changes in the number of log streams as follows:
enable_rebalance=true; enable_transfer=false;You can disable all O&M commands and operations related to load balancing as follows:
enable_rebalance=false;
Examples
Disable transfer for all tenants:
ALTER SYSTEM SET enable_transfer = false TENANT = all_user;Enable transfer for the
MySQLtenant:ALTER SYSTEM SET enable_rebalace = true TENANT='MySQL';