enable_ls_leader_balance

Description

enable_ls_leader_balance specifies whether to enable automatic leader balancing for log streams.

Privilege requirements

• Query the parameter

  The sys tenant and all user tenants can use the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view to query this parameter.

• Modify the parameter

  The sys tenant and user tenants can use the ALTER SYSTEM SET statement to modify this parameter.

Attributes

Considerations

• When enable_rebalance is enabled (value is True), you can disable automatic leader balancing for log streams by setting enable_ls_leader_balance to False.

• When this parameter is disabled (value is False), automatic leader balancing for log streams is disabled. However, leader transfer may still occur at the partition level due to log stream transfers between different leaders.

Examples

• Disable automatic leader balancing for log streams in the user tenant.

  obclient> ALTER SYSTEM SET enable_ls_leader_balance = False;
  

• Disable automatic leader balancing for log streams in the mysql tenant in the system tenant.

  obclient> ALTER SYSTEM SET enable_ls_leader_balance = False TENANT = 'mysql';
  

References

• Control whether to enable automatic load balancing: enable_rebalance

• Control whether to allow automatic log stream transfer: enable_transfer

• Enable or disable automatic log stream replica migration: enable_rereplication

• For more information about leader balancing for log streams, see Intra-tenant balancing.