topology of physical data nodes. It includes lots of implementation for Mod, Hash, Range and Time Interval etc. 4.3. Sharding 30 Apache ShardingSphere document, v5.1.2 User-Defined Sharding Algorithm Attributes: Name Type Description Default Value retryInte rvalMilliseconds int Milliseconds of retry interval 500 maxRetries int Max retries of client connection 3 t imeToLiveSeconds int Seconds of ephemeral tring Range of sharding border, multiple boundaries separated by commas Auto Interval Sharding Algorithm Type: AUTO_INTERVAL Attributes: Na me • D a t a T y p e * Description da tet ime ‐lo wer S

allocation will be adjusted through resharding. For example, if the job is executed at an hourly interval, each execution will take 30 minutes. As shown below. The figure shows that the jobs are executed scenario that takes a long time to run and has a long interval, failover is an effective means to improve the real‐time operation of the job; For short‐interval jobs, a large number of network communi‐ cations the registry will be generated, which will affect the performance of the cluster; Moreover, short‐interval jobs do not necessarily pay attention to the real‐time performance of a single job. You 5.3. Failover

topology of physical data nodes. It includes lots of implementation for Mod, Hash, Range and Time Interval etc. User-Defined Sharding Algorithm It provides interfaces for developers to implement the sharding Attributes: Name Type Description Default Value retryInte rvalMilliseconds int Milliseconds of retry interval 500 maxRetries int Max retries of client connection 3 t imeToLiveSeconds int Seconds of ephemeral tring Range of sharding border, multiple boundaries separated by commas Auto Interval Sharding Algorithm Type: AUTO_INTERVAL Attributes: Na me • D a t a T y p e * Description da tet ime ‐lo wer S

supported by Groovy are sup‐ ported by row expressions. For example: ${begin..end} denotes the range interval ${[unit1, unit2, unit_x]} denotes the enumeration value If there are multiple ${ expression } @param compute.serverConfig.mode.repository.props.retryIntervalMilliseconds Milliseconds of retry interval ## @param compute.serverConfig.mode.repository.props.timeToLiveSeconds Seconds of ephemeral data AutoIntervalShardingAlgorithm | AUTO_INTERVAL | org.apache.shardingsphere. sharding.algorithm.sharding.datetime.AutoIntervalShardingAlgorithm | | IntervalShardingAlgorithm | INTERVAL | org.apache.shardingsphere

supported by Groovy are sup‐ ported by row expressions. For example: ${begin..end} denotes the range interval ${[unit1, unit2, unit_x]} denotes the enumeration value If there are multiple ${ expression } @param compute.serverConfig.mode.repository.props.retryIntervalMilliseconds Milliseconds of retry interval ## @param compute.serverConfig.mode.repository.props.timeToLiveSeconds Seconds of ephemeral data + | MOD | | | | HASH_MOD | | | | VOLUME_RANGE | | | | BOUNDARY_RANGE | | | | AUTO_INTERVAL | | | | INTERVAL | | | | CLASS_BASED | | | | INLINE | | | | COMPLEX_INLINE | | | | HINT_INLINE | | |

JAEGER_SAMPLER_TYPE:“const”JAEGER_SAMPLER_PARAM:“1”JAEGER_REPORTER_LOG_SPANS: “true”JAEGER_REPORTER_FLUSH_INTERVAL: “1”Zipkin: host: “localhost”#zipkin host port: 9411 #zipkin prot props: SERVICE_NAME: “shardi user=root --mysql-password='root' --mysql-db=sbtest --tables=10 --table- size=1000000 --report-interval=10 --time=3600 --threads=10 --max-requests=0 -- percentile=99 --mysql-ignore-errors="all" --rand-type=uniform user=root --mysql-password='root' --mysql-db=sbtest --tables=10 --table- size=1000000 --report-interval=10 --time=3600 --threads=10 --max-requests=0 -- percentile=99 --mysql-ignore-errors="all" --rand-type=uniform

supported by Groovy are sup‐ ported by row expressions. For example: ${begin..end} denotes the range interval ${[unit1, unit2, unit_x]} denotes the enumeration value If there are multiple ${ expression } @param compute.serverConfig.mode.repository.props.retryIntervalMilliseconds Milliseconds of retry interval ## @param compute.serverConfig.mode.repository.props.timeToLiveSeconds Seconds of ephemeral data Attributes: Name Type Description Default Value retryInte rvalMilliseconds int Milliseconds of retry interval 500 maxRetries int Max retries of client connection 3 t imeToLiveSeconds int Seconds of ephemeral

topology of physical data nodes. It includes lots of implementation for Mod, Hash, Range and Time Interval etc. User-Defined Sharding Algorithm It provides interfaces for developers to implement the sharding JAEGER_SAMPLER_TYPE: "const" JAEGER_SAMPLER_PARAM: "1" JAEGER_REPORTER_LOG_SPANS: "true" JAEGER_REPORTER_FLUSH_INTERVAL: "1" Zipkin: host: "localhost" #zipkin host port: 9411 #zipkin prot props: SERVICE_NAME: " maxRetries (?) int The maximum retry count 3 retryInt ervalMillisec‐ onds (?) int The retry interval mil‐ liseconds 500 mi lliseconds timeToLiveSeconds (?) int Time to live seconds for ephemeral

supported by Groovy are sup‐ ported by row expressions. For example: ${begin..end} denotes the range interval ${[unit1, unit2, unit_x]} denotes the enumeration value If there are multiple ${ expression } @param compute.serverConfig.mode.repository.props.retryIntervalMilliseconds Milliseconds of retry interval ## @param compute.serverConfig.mode.repository.props.timeToLiveSeconds Seconds of ephemeral data Attributes: Name Type Description Default Value retryInte rvalMilliseconds int Milliseconds of retry interval 500 maxRetries int Max retries of client connection 3 t imeToLiveSeconds int Seconds of ephemeral

@param compute.serverConfig.mode.repository.props.retryIntervalMilliseconds Milliseconds of retry interval ## @param compute.serverConfig.mode.repository.props.timeToLiveSeconds Seconds of ephemeral data AutoIntervalShardingAlgorithm | AUTO_INTERVAL | org.apache.shardingsphere. sharding.algorithm.sharding.datetime.AutoIntervalShardingAlgorithm | | IntervalShardingAlgorithm | INTERVAL | org.apache.shardingsphere AutoIntervalShardingAlgorithm | AUTO_INTERVAL | org.apache.shardingsphere. sharding.algorithm.sharding.datetime.AutoIntervalShardingAlgorithm | | IntervalShardingAlgorithm | INTERVAL | org.apache.shardingsphere