Involved ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 13 7 Quick Start In shortest time, this chapter provides e-agent-${latest.release.version}.jar -jar test-project.jar • 3 Access to started service • 4 Check whether the corresponding plug‐in is effective 9.1. ShardingSphere-JDBC 135 Apache ShardingSphere SHOW MIGRATION CHECK ALGORITHM Description The SHOW MIGRATION RULE syntax is used to query migration check algorithm. Syntax ShowMigrationCheckAlgorithm ::= 'SHOW' 'MIGRATION' 'CHECK' 'ALGORITHMS'

Involved ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 13 7 Quick Start In shortest time, this chapter provides e-agent-${latest.release.version}.jar -jar test-project.jar • 3 Access to started service • 4 Check whether the corresponding plug‐in is effective 9.1. ShardingSphere-JDBC 151 Apache ShardingSphere SHOW MIGRATION CHECK ALGORITHM Description The SHOW MIGRATION RULE syntax is used to query migration check algorithm. Syntax ShowMigrationCheckAlgorithm ::= 'SHOW' 'MIGRATION' 'CHECK' 'ALGORITHMS'

‘file://component1’, ‘file://component2’ REPAIR TABLE t_order OPTIMIZE TABLE t_order CHECKSUM TABLE t_order CHECK TABLE t_order SET RESOURCE GROUP group_name DROP RESOURCE GROUP group_name CREATE RESOURCE GROUP manage this transaction by yourself; • When recover from a crush, you have to call XA RECOVER to check unfinished transaction, and choose to commit or rollback using xid. Or you can use ONE PHASE commit SCALING 1234 CHECK SCALING jobId Data consistency check with algo‐ rithm in server.yaml, xx: jobId CHECK SCALING 1234 SHOW SCALING CHECK ALGO‐ RITHMS Show available consistency check al‐ gorithms

‘file://component1’, ‘file://component2’ REPAIR TABLE t_order OPTIMIZE TABLE t_order CHECKSUM TABLE t_order CHECK TABLE t_order SET RESOURCE GROUP group_name DROP RESOURCE GROUP group_name CREATE RESOURCE GROUP manage this transaction by yourself; • When recover from a crush, you have to call XA RECOVER to check unfinished transaction, and choose to commit or rollback using xid. Or you can use ONE PHASE commit SCALING 1234 CHECK SCALING jobId Data consistency check with algo‐ rithm in server.yaml, xx: jobId CHECK SCALING 1234 SHOW SCALING CHECK ALGO‐ RITHMS Show available consistency check al‐ gorithms

SHOW、MIGRATION、STATUS 相关链接 • 保留字 SHOW MIGRATION CHECK ALGORITHM 描述 SHOW MIGRATION CHECK ALGORITHM 语法用于查询数据迁移一致性校验算法。### 语法 ShowMigrationCheckAlgorithm ::= 'SHOW' 'MIGRATION' 'CHECK' 'ALGORITHMS' 返回值说明 列 说明 type ShardingSphere-Proxy 303 Apache ShardingSphere document 示例 • 查询数据迁移一致性校验算法 SHOW MIGRATION CHECK ALGORITHMS; mysql> SHOW MIGRATION CHECK ALGORITHMS; +-------------+------------------------------------------------ set (0.03 sec) 保留字 SHOW、MIGRATION、CHECK、ALGORITHMS 相关链接 • 保留字 CHECK MIGRATION BY 描述 CHECK MIGRATION BY 语法用于校验数据迁移作业中的数据一致性。 语法 ShowMigrationList ::= 'CHECK' 'MIGRATION' migrationJobId 'BY' 'TYPE'

SHOW、MIGRATION、STATUS 相关链接 • 保留字 SHOW MIGRATION CHECK ALGORITHM 描述 SHOW MIGRATION CHECK ALGORITHM 语法用于查询数据迁移一致性校验算法。### 语法 ShowMigrationCheckAlgorithm ::= 'SHOW' 'MIGRATION' 'CHECK' 'ALGORITHMS' 返回值说明 列 说明 type ShardingSphere-Proxy 297 Apache ShardingSphere document 示例 • 查询数据迁移一致性校验算法 SHOW MIGRATION CHECK ALGORITHMS; mysql> SHOW MIGRATION CHECK ALGORITHMS; +-------------+------------------------------------------------ set (0.03 sec) 保留字 SHOW、MIGRATION、CHECK、ALGORITHMS 相关链接 • 保留字 CHECK MIGRATION BY 描述 CHECK MIGRATION BY 语法用于校验数据迁移作业中的数据一致性。 语法 ShowMigrationList ::= 'CHECK' 'MIGRATION' migrationJobId 'BY' 'TYPE'

ShardingSphere document SHOW MIGRATION CHECK ALGORITHM 描述 SHOW MIGRATION CHECK ALGORITHM 语法用于查询数据迁移一致性校验算法。### 语法 ShowMigrationCheckAlgorithm ::= 'SHOW' 'MIGRATION' 'CHECK' 'ALGORITHMS' 返回值说明 列 说明 type supported_database_types 支持数据库类型 description 说明 示例 • 查询数据迁移一致性校验算法 SHOW MIGRATION CHECK ALGORITHMS; mysql> SHOW MIGRATION CHECK ALGORITHMS; +-------------+------------------------------------------------ ShardingSphere document 保留字 SHOW、MIGRATION、CHECK、ALGORITHMS 相关链接 • 保留字 CHECK MIGRATION BY 描述 CHECK MIGRATION BY 语法用于校验数据迁移作业中的数据一致性。 语法 ShowMigrationList ::= 'CHECK' 'MIGRATION' migrationJobId 'BY' 'TYPE'

Involved ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 1.5. Roadmap 9 2 Quick Start In shortest time, this 1234 CHECK MIGRATION jobId Data consistency check CHECK MIGRATION 1234 SHOW MIGRATION CHECK ALGO‐ RITHMS Show available consis‐ tency check algorithms SHOW MIGRATION CHECK AL‐ GORITHMS CHECK MIGRATION MIGRATION jobId (by type(n ame=algorithmTypeName)? Data consistency check with defined algorithm CHECK MIGRATION 1234 by type (name=“DATA_MATCH”) Circuit Breaker Statement Function Example [ENABLE

‘file://component2’ SHOW CREATE USER user REPAIR TABLE t_order OPTIMIZE TABLE t_order CHECKSUM TABLE t_order CHECK TABLE t_order SET RESOURCE GROUP group_name DROP RESOURCE GROUP group_name CREATE RESOURCE GROUP each physical database allocates to each query; default value: 1 check.ta ble.metadata.enabled (?) Att rib ute Whether to check meta‐data consistency of sharding table when it initializes; default reset scaling 1234 check scaling xx Data consistency check with algo‐ rithm in server.yaml, xx: jobId check scaling 1234 show scaling check algorithms Show available consistency check al‐ gorithms show

Contribute ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 1.2 Design Philosophy ShardingSphere adopts the database number of con‐ nections that a query request can use in each database in‐ stance. 1 T r u e check‐ta ble‐ metada ta‐ enabled (?) b o o l e a n Whether shard metadata is checked for structural minimum value for JDBC driver. • 1 T r u e check‐dup licate‐ tab le‐enabled (?) b o o l e a n When the pro‐ gram is started and updated, whether to check duplicate tables. f a l s e T r u e proxy‐fr