state shard to be adjusted in the Console? . . . . . . . . . . . . . . . . . 92 10.9 Why is there a task scheduling delay in the first startup? . . . . . . . . . . . . . . . . . 92 10.10 In Windows env simply adding servers. ElasticJob is a lightweight, decentralized solution that provides distributed task sharding services. 2 2 Features • Elastic Schedule – Support job sharding and high availability shards changes. • When a scheduled task is triggered, if it needs to be sharded again, it will be sharded by the main server. The sharding process is blocked, and the task can be executed after the sharding

system accurately. 4.9.2 Challenges pressure testing on production environment is a complex and huge task. Coordination and adjustments between microservices and middlewares required to cope with the transparent PROPERTIES("block-queue-size"=10000))), COMPLETION_DETECTOR(TYPE(NAME=IDLE, PROPERTIES("incremental-task-idle-seconds- threshold"=1800))), DATA_CONSISTENCY_CHECKER(TYPE(NAME=DATA_MATCH, PROPERTIES("chunk-size"=1000))) | {"type":"MEMORY","props":{"block-queue-size":"10000"}} | {"type ":"IDLE","props":{"incremental-task-idle-seconds-threshold":"1800"}} | {"type": "DATA_MATCH","props":{"chunk-size":"1000"}} | +----

system accurately. 4.9.2 Challenges pressure testing on production environment is a complex and huge task. Coordination and adjustments between microservices and middlewares required to cope with the transparent PROPERTIES("block-queue-size"=10000))), COMPLETION_DETECTOR(TYPE(NAME=IDLE, PROPERTIES("incremental-task-idle-minute- threshold"=30))), DATA_CONSISTENCY_CHECKER(TYPE(NAME=DATA_MATCH, PROPERTIES("chunk-size"=1000))) | {"type":"MEMORY","props":{"block-queue-size":"10000"}} | {"type ":"IDLE","props":{"incremental-task-idle-minute-threshold":"30"}} | {"type":"DATA_ MATCH","props":{"chunk-size":"1000"}} | +-------

system accurately. 8.9.2 Challenges pressure testing on production environment is a complex and huge task. Coordination and adjustments between microservices and middlewares required to cope with the transparent logs. f a l s e T r u e kerne l‐exe cutor ‐size (?) i n t Set the size of the thread pool for task pro‐ cessing. Each ShardingSphere‐ DataSource uses an independent thread pool, and different +-------------------------------+--------------------------+---------------+ | 0 | ds_1 | EXECUTE_INCREMENTAL_TASK | true | 6 | 100 | 25 | | +------+-------------+--------------------------+--------+-------------------------

and performance of the system. 4.8.2 Challenges Full‐link pressure testing is a complex and huge task. Coordination and adjustments between microser‐ vices and middleware required to cope with the transparent blockQueueSize: 10000 workerThread: 40 clusterAutoSwitchAlgorithm: type: IDLE props: incremental-task-idle-minute-threshold: 30 dataConsistencyCheckAlgorithm: type: DEFAULT mode: type: Cluster repository: data transmission channel 10000 wo rkerT hread Worker thread pool size, the number of migration task threads allowed to run concurrently 40 5.4. ShardingSphere-Scaling 213 Apache ShardingSphere document

PROPERTIES("block-queue-size"=10000))), COMPLETION_DETECTOR(TYPE(NAME=IDLE, PROPERTIES("incremental-task-idle-seconds- threshold"=1800))), DATA_CONSISTENCY_CHECKER(TYPE(NAME=DATA_MATCH, PROPERTIES("chunk-size"=1000))) | {"type":"MEMORY","props":{"block-queue-size":"10000"}} | {"type ":"IDLE","props":{"incremental-task-idle-seconds-threshold":"1800"}} | {"type": "DATA_MATCH","props":{"chunk-size":"1000"}} | +---- 作业是否接近完成检测算法。如果不配置则无法自动进行后续步骤，可以通 过 DistSQL 手动操作。 type: # 算法类型。可选项：IDLE props: # 算法属性 incremental-task-idle-seconds-threshold: # 如果增量同步任务不再活动超过一定时间， 那么可以认为增量同步任务接近完成。适用算法类型：IDLE dataConsistencyChecker:

PROPERTIES("block-queue-size"=10000))), COMPLETION_DETECTOR(TYPE(NAME=IDLE, PROPERTIES("incremental-task-idle-minute- 5.2. ShardingSphere-Proxy 155 Apache ShardingSphere document, v5.1.1 threshold"=30))) | {"type":"MEMORY","props":{"block-queue-size":"10000"}} | {"type ":"IDLE","props":{"incremental-task-idle-minute-threshold":"30"}} | {"type":"DATA_ MATCH","props":{"chunk-size":"1000"}} | +------- 作业是否接近完成检测算法。如果不配置则无法自动进行后续步骤，可以通 过 DistSQL 手动操作。 type: # 算法类型。可选项：IDLE props: # 算法属性 incremental-task-idle-minute-threshold: # 如果增量同步任务不再活动超过一定时间， 那么可以认为增量同步任务接近完成。适用算法类型：IDLE dataConsistencyChecker:

PROPERTIES("block-queue-size"=10000))), COMPLETION_DETECTOR(TYPE(NAME=IDLE, PROPERTIES("incremental-task-idle-minute- threshold"=30))), DATA_CONSISTENCY_CHECKER(TYPE(NAME=DATA_MATCH, PROPERTIES("chunk-size"=1000))) | {"type":"MEMORY","props":{"block-queue-size": "10000"}} | {"type":"IDLE","props":{"incremental-task-idle-minute-threshold":"30"}} | {"type":"DATA_MATCH","props":{"chunk-size":"1000"}} | +-------- 作业是否接近完成检测算法。如果不配置则无法自动进行后续步骤，可以通 过 DistSQL 手动操作。 type: # 算法类型。可选项：IDLE props: # 算法属性 incremental-task-idle-minute-threshold: # 如果增量同步任务不再活动超过一定时间， 那么可以认为增量同步任务接近完成。适用算法类型：IDLE dataConsistencyChecker:

system accurately. 8.9.2 Challenges pressure testing on production environment is a complex and huge task. Coordination and adjustments between microservices and middlewares required to cope with the transparent logs. f a l s e T r u e kerne l‐exe cutor ‐size (?) i n t Set the size of the thread pool for task pro‐ cessing. Each ShardingSphere‐ DataSource uses an independent thread pool, and different +-------------------------------+--------------------------+---------------+ | 0 | ds_1 | EXECUTE_INCREMENTAL_TASK | true | 6 | 100 | 25 | | +------+-------------+--------------------------+--------+-------------------------

system accurately. 3.9.2 Challenges pressure testing on production environment is a complex and huge task. Coordination and adjustments between microservices and middlewares required to cope with the transparent logs. f a l s e T r u e kern el‐e xecu tor‐ size (?) i n t Set the size of the thread pool for task pro‐ cessing. Each ShardingSphere‐ DataSource uses an independent thread pool，and different +-------------------------------+--------------------------+---------------+ | 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 6 | 100 | 81 | | +------+-------------+--------------------------+--------+-------------------------