SYS.REBALANCE_ALL_BUCKETS

Rebalance partitioned table data on available SnappyData members.

Syntax

SYS.REBALANCE_ALL_BUCKETS()

Rebalancing is a SnappyData member operation that affects partitioned tables created in the cluster. Rebalancing performs two tasks:

  1. If the partitioned table's redundancy setting is not satisfied, rebalancing does what it can to recover redundancy.

  2. Rebalancing moves the partitioned table's data buckets between host members as needed to establish the best balance of data across the distributed system.

For efficiency, when starting multiple members, trigger the rebalance a single time, after you have added all members.

Example

snappy> call sys.rebalance_all_buckets();