shardingsphere icon indicating copy to clipboard operation
shardingsphere copied to clipboard

Properties of VolumeBasedRangeShardingAlgorithm VOLUME_RANGE is not clear

Open TeslaCN opened this issue 1 year ago • 0 comments

Question

My scenario is range sharding.

ID distributes in [1, 32]

Range sharding into 4 data sources: ds_0: [1, 8] ds_1: [9, 16] ds_2: [17, 24] ds_3: [25, 32]

I thought the configuration was:

    shardingAlgorithms:
      warehouse:
        type: VOLUME_RANGE
        props:
          range-lower: 1
          range-upper: 33
          sharding-volume: 8

But the proper configuration is the following:

    shardingAlgorithms:
      warehouse:
        type: VOLUME_RANGE
        props:
          range-lower: 9
          range-upper: 25
          sharding-volume: 8

The properties may confuse users.

TeslaCN avatar Aug 10 '22 10:08 TeslaCN