SHARD_ROW_ID_BITS and AUTO_RANDOM

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: SHARD_ROW_ID_BITS和AUTO_RANDOM

| username: TiDBer_0bMAq5I8

SHARD_ROW_ID_BITS and AUTO_RANDOM are recommended for use after the version, ensuring no issues.

2
| username: 大飞哥online | Original post link

What? What did you say?

3
| username: dba远航 | Original post link

This is a technique to disperse hotspot data.

4
| username: 随缘天空 | Original post link

“SHARD_ROW_ID_BITS and AUTO_RANDOM can distribute row IDs across multiple different Regions, alleviating the write hotspot issue. This prevents a situation where one node is overloaded while other nodes have nothing to do.”

5
| username: Kongdom | Original post link

It should work normally after version v4.0.3.

Note

The AUTO_RANDOM attribute became an official feature in version v4.0.3.