enable_ls_leader_balance

Description

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

Privilege requirements

• Query the parameter

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

• Modify the parameter

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

Attributes

Considerations

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

• When this parameter is disabled (False), automatic leader switching at the log stream level is disabled, but leader switching at the partition level may still occur 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 user 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 and replication: enable_rereplication

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