prise Notification Strategy Send wechat message notifica‐ tion and do not interrupt job Yes Dingtalk Notifica‐ tion Strategy Send dingtalk message notifica‐ tion and do not interrupt job Yes prise Notification Strategy Send wechat message notifica‐ tion and do not interrupt job Yes Dingtalk Notifica‐ tion Strategy Send dingtalk message notifica‐ tion and do not interrupt job Yes host port: 465 username: username password: password useSsl: true subject: ElasticJob error message from: from@xxx.xx to: to1@xxx.xx,to2@xxx.xx 6.1. Usage 35 Apache ShardingSphere ElasticJob document

finished percentage of migration job incremental_idle_seconds incremental idle time error_message error message Example • Query migration job status SHOW MIGRATION STATUS 'j010180026753ef0e25d3932d94d1673ba551'; active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message | +------+-------------+--------------------------+--------+------------------------- 9.2. ShardingSphere-Proxy check remaining time check_begin_time check begin time check_end_time check end time error_message error message Example • Query migration check status SHOW MIGRATION CHECK STATUS 'j010180026753ef0e2

finished percentage of migration job incremental_idle_seconds incremental idle time error_message error message Example • Query migration job status SHOW MIGRATION STATUS 'j010180026753ef0e25d3932d94d1673ba551'; active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message | +------+-------------+--------------------------+--------+------------------------- 9.2. ShardingSphere-Proxy check remaining time check_begin_time check begin time check_end_time check end time error_message error message Example • Query migration check status SHOW MIGRATION CHECK STATUS 'j010180026753ef0e2

processed_records_count 处理数据行数 inventory_finished_percentage 数据迁移作业完成度 incremental_idle_seconds 增量闲置时间 error_message 错误信息提示 示例 • 查询指定数据迁移作业的详细情况 SHOW MIGRATION STATUS 'j010180026753ef0e25d3932d94d1673ba551'; mysql> active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message | +------+-------------+--------------------------+--------+------------------------- +------- finished_percentage 校验完成度 remaining_seconds 剩余时间 check_begin_time 校验开始时间 check_end_time 校验结束时间 error_message 错误信息提示 9.2. ShardingSphere-Proxy 325 Apache ShardingSphere document 示例 • 查询指定数据迁移作业的数据校验情况 SHOW

processed_records_count 处理数据行数 inventory_finished_percentage 数据迁移作业完成度 incremental_idle_seconds 增量闲置时间 error_message 错误信息提示 9.2. ShardingSphere-Proxy 302 Apache ShardingSphere document 示例 • 查询指定数据迁移作业的详细情况 SHOW active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message | +------+-------------+--------------------------+--------+------------------------- +------- finished_percentage 校验完成度 remaining_seconds 剩余时间 check_begin_time 校验开始时间 check_end_time 校验结束时间 error_message 错误信息提示 示例 • 查询指定数据迁移作业的数据校验情况 SHOW MIGRATION CHECK STATUS 'j010180026753ef0e25d3932d94d1673ba551';

processed_records_count 处理数据行数 inventory_finished_percentage 数据迁移作业完成度 incremental_idle_seconds 增量闲置时间 error_message 错误信息提示 9.2. ShardingSphere-Proxy 296 Apache ShardingSphere document 示例 • 查询指定数据迁移作业的详细情况 SHOW active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message | +------+-------------+--------------------------+--------+------------------------- +------- finished_percentage 校验完成度 remaining_seconds 剩余时间 check_begin_time 校验开始时间 check_end_time 校验结束时间 error_message 错误信息提示 示例 • 查询指定数据迁移作业的数据校验情况 SHOW MIGRATION CHECK STATUS 'j010180026753ef0e25d3932d94d1673ba551';

active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message | +------+-------------+--------------------------+--------+------------------------- +------- finished_percentage | remaining_seconds | check_begin_time | check_end_time | duration_seconds | error_message | +---------+--------+---------------------+-------------------+--------------------- ----+--- active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message | +------+-------------+--------------------------+--------+------------------------- +-------

host port: 465 username: username password: password useSsl: true subject: ElasticJob error message from: from@xxx.xx to: to1@xxx.xx,to2@xxx.xx cc: cc@xxx.xx bcc: bcc@xxx.xx debug: false 6.1

process, such as starting, successful and failed execution events. Execution engine only focuses on message send‐ ing rather than subscribers of the event. Other ShardingSphere modules, such as distributed may not be noticed by users. • Eventually consistent feature of systems is usually guaranteed by message availability. There is a high requirement for isolation in ACID transactions: all the resources

may not be noticed by users. • Eventually consistent feature of systems is usually guaranteed by message availability. 4.3. Distributed Transaction 41 Apache ShardingSphere document, v5.0.0 There is process, such as starting, successful and failed execution events. Execution engine only focuses on message send‐ ing rather than subscribers of the event. Other ShardingSphere modules, such as distributed