being interrupted in the middleThe sharding will not be triggered when the job is executed sh ar di ng :r aw ‐l at ex :ˋ p ro ce ss in gˋ Y E S The node held by the master node during sharding.If there alue Description jobName St ri ng Job name shar dingTotalCount i nt Sharding total count cron St ri ng CRON expression, control the job trigger time timeZone St ri ng time zone of CRON sharding ItemParame‐ ItemParame‐ ters St ri ng Sharding item param‐ eters jobParameter St ri ng Job parameter mo nitorExecution b oo le an true Monitor job execution status failover b oo le an f alse Enable or disable

tab le‐st rateg y‐ref A t t r i b u t e Table strategy name for stan‐ dard sharding table s hardi ng‐st rateg y‐ref A t t r i b u t e sharding strategy name for auto sharding table key‐g enera te‐st Name T ype Description id A ttri bute Complex sharding strategy name shardi ng‐ columns A ttri bute Sharding column names, multiple columns separated with comma alg orithm‐ref attributes include: • {table}.SHARDING_DATABASE_VALUE: used to add the data source shardi ng val ue correspondi ng to{table}tabl e, mul ti pl e attri butes are separated by commas; 4.1. ShardingSphere-JDBC

1 Apache ShardingSphere document 1.2 Product Features F ea tu re Definition Da ta Sh ar di ng Data sharding is an effective way to deal with massive data storage and computing. Shard‐ ingSphere standalone databases, enabling data security across underlying data sources. Re ad /w ri te S pl it ti ng Read/write splitting can be used to cope with business access with high stress. Sharding‐ Sphere Based Range Sharding Algorithm Type: BOUNDARY_RANGE Attributes: Name Dat aType Description shardi ng‐ ranges String Range of sharding border, multiple boundaries separated by commas Auto Interval Sharding

Description t ype St ri ng Cluster mode typ, such as: Zookeeper, Etcd nam esp ace St ri ng Cluster mode instance namespace, such as: cluster‐ sharding‐mode ser ver ‐li sts St ri ng Zookeeper or Etcd server Name T ype Description id A ttri bute Complex sharding strategy name shardi ng‐ columns A ttri bute Sharding column names, multiple columns separated with comma alg orithm‐ref Based Range Sharding Algorithm Type: BOUNDARY_RANGE Attributes: Name Data Type Description shardi ng‐ ranges S tring Range of sharding border, multiple boundaries separated by commas Auto Interval

1 Apache ShardingSphere document 1.2 Product Features F ea tu re Definition Da ta Sh ar di ng Data sharding is an effective way to deal with massive data storage and computing. Shard‐ ingSphere standalone databases, enabling data security across underlying data sources. Re ad /w ri te S pl it ti ng Read/write splitting can be used to cope with business access with high stress. Sharding‐ Sphere Based Range Sharding Algorithm Type: BOUNDARY_RANGE Attributes: Name Dat aType Description shardi ng‐ ranges String Range of sharding border, multiple boundaries separated by commas Auto Interval Sharding

der St ri ng 元数据存储类型，可选 值为 H2，MySQL H2 jd bc_ url St ri ng JDBC URL jdbc:h2:mem:config ;DB_CLOSE_ DELAY=‐ 1;DATABASE_TO_UPPER=false;MODE=MYSQL us ern ame St ri ng 账号 sa pa ssw ord St ri ng 密码 ZooKeeper * 说明 uppercase ‐letter‐codes St ri ng 大 写 字 母 码 表 （以 英 文 逗 号 分 隔， 默 认 值：A,B,C, D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z） lowercase ‐letter‐codes St ri ng 小 写 字 母 码 表 （以 英 文 逗 号 分 隔， 默 认 值：a d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z） digital‐codes St ri ng 数字码表（以英文逗号分隔，默 认值：0,1,2,3,4,5,6,7,8,9） special‐codes St ri ng 特 殊 字 符 码 表 （以 英 文 逗 号 分 隔， 默 认 值： ~,!,@,#,$,%,^,&,*,:,<,>,¦） 操作步骤

der St ri ng 元数据存储类型，可选 值为 H2，MySQL H2 jd bc_ url St ri ng JDBC URL jdbc:h2:mem:config ;DB_CLOSE_ DELAY=‐ 1;DATABASE_TO_UPPER=false;MODE=MYSQL us ern ame St ri ng 账号 sa pa ssw ord St ri ng 密码 ZooKeeper * 说明 uppercase ‐letter‐codes St ri ng 大 写 字 母 码 表 （以 英 文 逗 号 分 隔， 默 认 值：A,B,C, D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z） lowercase ‐letter‐codes St ri ng 小 写 字 母 码 表 （以 英 文 逗 号 分 隔， 默 认 值：a d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z） digital‐codes St ri ng 数字码表（以英文逗号分隔，默 认值：0,1,2,3,4,5,6,7,8,9） special‐codes St ri ng 特 殊 字 符 码 表 （以 英 文 逗 号 分 隔， 默 认 值： ~,!,@,#,$,%,^,&,*,:,<,>,¦） 操作步骤

der St ri ng 元数据存储类型，可选 值为 H2，MySQL H2 jd bc_ url St ri ng JDBC URL jdbc:h2:mem:config ;DB_CLOSE_ DELAY=‐ 1;DATABASE_TO_UPPER=false;MODE=MYSQL us ern ame St ri ng 账号 sa pa ssw ord St ri ng 密码 9.3 * 说明 uppercase ‐letter‐codes St ri ng 大 写 字 母 码 表 （以 英 文 逗 号 分 隔， 默 认 值：A,B,C, D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z） lowercase ‐letter‐codes St ri ng 小 写 字 母 码 表 （以 英 文 逗 号 分 隔， 默 认 值：a d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z） digital‐codes St ri ng 数字码表（以英文逗号分隔，默 认值：0,1,2,3,4,5,6,7,8,9） special‐codes St ri ng 特 殊 字 符 码 表 （以 英 文 逗 号 分 隔， 默 认 值： ~,!,@,#,$,%,^,&,*,:,<,>,¦） 统一信用码随机替换

数据类型 * 说明 datetim e‐lower St ri ng 分片的起始时间范围，时间戳格 式：yyyy‐MM‐dd HH:mm:ss datetim e‐upper St ri ng 分片的结束时间范围，时间戳格 式：yyyy‐MM‐dd HH:mm:ss sh arding‐ seconds lo ng 单一分片所能承载的最大时间， 单位：秒，允许分片键的时间戳 格式的秒带有时间精度，但秒后 dedShard‐ ingRuleConfiguration 用于将基于算法的分片用户配 置转化为分片规则对象 org. apac he.s hard ings pher e.sh ardi ng.r ule. buil der. Algo rith mPro vide dSha rdin gRul eBui lder Readwri teSplittingRuleConfig‐ uration edRangeShard ingAl‐ gorithm AUTO _INTERVAL Y 基于可变时间范围的分 片算法 org.apac he.shardings phere.shardi ng.algorithm .shard‐ ing.da tetime.AutoI ntervalShard ingAlgo‐ rithm INTERVAL N 基于固定时间范围的分 片算法 org