UUID, SNOWFLAKE. Besides, we have also extracted a key generator interface to make users implement self‐defined key generator. Built-In Key Generator UUID Use UUID.randomUUID() to generate the distributed millisecond. If the number generated in that millisecond exceeds 4,096 (2 to the power of 12), the generator will wait till the next millisecond to continue. Please refer to the following picture for the distributed sequence generator has provided a maximum clock‐back millisecond. If the clock‐back time has exceeded it, the program will report error. If it is within the tolerance range, the generator will wait

UUID, SNOWFLAKE. Besides, we have also extracted a key generator interface to make users implement self‐defined key generator. Built-In Key Generator UUID Use UUID.randomUUID() to generate the distributed millisecond. If the number generated in that millisecond exceeds 4,096 (2 to the power of 12), the generator will wait till the next millisecond to continue. Please refer to the following picture for the distributed sequence generator has provided a maximum clock‐back millisecond. If the clock‐back time has exceeded it, the program will report error. If it is within the tolerance range, the generator will wait

UUID, SNOWFLAKE. Besides, we have also extracted a key generator interface to make users implement self‐defined key generator. Built-In Key Generator UUID Use UUID.randomUUID() to generate the distributed millisecond. If the number generated in that millisecond exceeds 4,096 (2 to the power of 12), the generator will wait till the next millisecond to continue. Please refer to the following picture for the distributed sequence generator has provided a maximum clock‐back millisecond. If the clock‐back time has exceeded it, the program will report error. If it is within the tolerance range, the generator will wait

primary key generator） • REPLACE INTO tbl_name (col1, col2, ⋯) SELECT * FROM tbl_name WHERE col3 = ?（The SELECT clause does not support * and the built‐in distributed primary key generator） • SELECT database sharding strategy keyGenerateStrategy: # Key generator strategy column: # Column name of key generator keyGeneratorName: # Key generator name autoTables: # Auto Sharding table configuration defaultTableStrategy: # Default strategy for table sharding defaultKeyGenerateStrategy: # Default Key generator strategy defaultShardingColumn: # Default sharding column name # Sharding algorithm configuration

primary key generator） • REPLACE INTO tbl_name (col1, col2, ⋯) SELECT * FROM tbl_name WHERE col3 = ?（The SELECT clause does not support * and the built‐in distributed primary key generator） • SELECT database sharding strategy keyGenerateStrategy: # Key generator strategy column: # Column name of key generator keyGeneratorName: # Key generator name auditStrategy: # Sharding audit strategy auditorNames: defaultTableStrategy: # Default strategy for table sharding defaultKeyGenerateStrategy: # Default Key generator strategy defaultShardingColumn: # Default sharding column name # Sharding algorithm configuration

also extracted a key generator interface to make users implement self‐defined key generator. 3.1. Sharding 19 Apache ShardingSphere document, v5.0.0-beta Built-In Key Generator UUID Use UUID.randomUUID() millisecond. If the number generated in that millisecond exceeds 4,096 (2 to the power of 12), the generator will wait till the next millisecond to continue. Please refer to the following picture for the distributed sequence generator has provided a maximum clock‐back millisecond. If the clock‐back time has exceeded it, the program will report error. If it is within the tolerance range, the generator will wait

interface of JDBC specification to return auto‐increment key, it is necessary to use a distributed key generator that supports auto‐increment, and does not support other types of distributed key generators Unsupported primary key generator） • REPLACE INTO tbl_name (col1, col2, ⋯) SELECT * FROM tbl_name WHERE col3 = ?（The SELECT clause does not support * and the built‐in distributed primary key generator） 8.1. Sharding database sharding strategy keyGenerateStrategy: # Key generator strategy column: # Column name of key generator keyGeneratorName: # Key generator name auditStrategy: # Sharding audit strategy auditorNames:

interface of JDBC specification to return auto‐increment key, it is necessary to use a distributed key generator that supports auto‐increment, and does not support other types of distributed key generators Unsupported primary key generator） • REPLACE INTO tbl_name (col1, col2, ⋯) SELECT * FROM tbl_name WHERE col3 = ?（The SELECT clause does not support * and the built‐in distributed primary key generator） 8.1. Sharding database sharding strategy keyGenerateStrategy: # Key generator strategy column: # Column name of key generator keyGeneratorName: # Key generator name auditStrategy: # Sharding audit strategy auditorNames:

分布式序列列名称 spring.shardingsphere.rules.sharding.tables..key-generate-strategy.key- generator-name= # 分布式序列算法名称 spring.shardingsphere.rules.sharding.binding-tables[0]= # 绑定表规则列表 spring.shardingsphere column=user_id spring.shardingsphere.rules.sharding.tables.t_user.key-generate-strategy.key- generator-name=snowflake # 分片算法配置 spring.shardingsphere.rules.sharding.sharding-algorithms.default-database-strategy- 分布式序列列名称 spring.shardingsphere.rules.sharding.tables..key-generate-strategy.key- generator-name= # 分布式序列算法名称 spring.shardingsphere.rules.sharding.binding-tables[0]= # 绑定表规则列表 spring.shardingsphere

分布式序列列名称 spring.shardingsphere.rules.sharding.tables..key-generate-strategy.key- generator-name= # 分布式序列算法名称 spring.shardingsphere.rules.sharding.binding-tables[0]= # 绑定表规则列表 spring.shardingsphere column=user_id spring.shardingsphere.rules.sharding.tables.t_user.key-generate-strategy.key- generator-name=snowflake # 分片算法配置 spring.shardingsphere.rules.sharding.sharding-algorithms.default-database-strategy- SHARDING KEY GENERATOR keyGeneratorDefinition [, keyGeneratorDefinition] ... ALTER SHARDING KEY GENERATOR keyGeneratorDefinition [, keyGeneratorDefinition] ... DROP SHARDING KEY GENERATOR keyGeneratorName