You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by pa...@apache.org on 2022/10/13 06:14:23 UTC
[shardingsphere] branch master updated: Update migration doc for 5.2.1 (#21544)
This is an automated email from the ASF dual-hosted git repository.
panjuan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new cac5844c3f2 Update migration doc for 5.2.1 (#21544)
cac5844c3f2 is described below
commit cac5844c3f2122f818f98fadbf85cfecd6da9dd3
Author: Hongsheng Zhong <zh...@apache.org>
AuthorDate: Thu Oct 13 14:14:14 2022 +0800
Update migration doc for 5.2.1 (#21544)
* Update migration usage doc
* Update migration limitations doc
---
.../content/features/migration/limitations.cn.md | 7 +-
.../content/features/migration/limitations.en.md | 5 +-
.../shardingsphere-proxy/migration/usage.cn.md | 129 +++++++++++---------
.../shardingsphere-proxy/migration/usage.en.md | 135 ++++++++++++---------
4 files changed, 158 insertions(+), 118 deletions(-)
diff --git a/docs/document/content/features/migration/limitations.cn.md b/docs/document/content/features/migration/limitations.cn.md
index 5670369fc8d..ae3a7739b73 100644
--- a/docs/document/content/features/migration/limitations.cn.md
+++ b/docs/document/content/features/migration/limitations.cn.md
@@ -6,10 +6,11 @@ weight = 2
## 支持项
* 将外围数据迁移至 Apache ShardingSphere 所管理的数据库；
-* 整型或字符串主键表迁移。
+* 迁移含整型唯一键或字符串唯一键的表；
+* 迁移含整型主键或字符串主键的表。
## 不支持项
-* 无主键表迁移；
-* 复合主键表迁移；
+* 迁移无主键且无唯一键的表；
+* 迁移复合主键或复合唯一键的表；
* 不支持在当前存储节点之上做迁移，需要准备一个全新的数据库集群作为迁移目标库。
diff --git a/docs/document/content/features/migration/limitations.en.md b/docs/document/content/features/migration/limitations.en.md
index 962d34a6d54..6f46480a79f 100644
--- a/docs/document/content/features/migration/limitations.en.md
+++ b/docs/document/content/features/migration/limitations.en.md
@@ -6,10 +6,11 @@ weight = 2
## Procedures Supported
* Migration of peripheral data to databases managed by Apache ShardingSphere.
+* Migration of integer or string unique key tables.
* Migration of integer or string primary key tables.
## Procedures not supported
-* Migration without primary key tables.
-* Migration of composite primary key tables.
+* Migration without primary key and unique key tables.
+* Migration of composite primary key or composite unique key tables.
* Migration on top of the current storage node is not supported, so a brand new database cluster needs to be prepared as the migration target cluster.
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/migration/usage.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/migration/usage.cn.md
index dda4f59e7a7..5f31e5fda7e 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/migration/usage.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/migration/usage.cn.md
@@ -7,7 +7,7 @@ weight = 2
### 环境要求
-支持的 MySQL 版本：5.1.15 ~ 5.7.x。
+支持的 MySQL 版本：5.1.15 ~ 8.0.x。
### 权限要求
@@ -164,33 +164,29 @@ SHOW MIGRATION LIST;
示例结果：
```sql
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| id | tables | sharding_total_count | active | create_time | stop_time |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| j015d4ee1b8a5e7f95df19babb2794395e8 | t_order | 1 | true | 2022-08-22 16:37:01 | NULL |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| id | tables | sharding_total_count | active | create_time | stop_time |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| j01016e501b498ed1bdb2c373a2e85e2529a6 | t_order | 1 | true | 2022-10-13 11:16:01 | NULL |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
```
5. 查看数据迁移详情。
```sql
-SHOW MIGRATION STATUS 'j015d4ee1b8a5e7f95df19babb2794395e8';
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| item | data_source | status | active | inventory_finished_percentage | incremental_idle_seconds |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 100 | 141 |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
+SHOW MIGRATION STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| item | data_source | status | active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 6 | 100 | 81 | |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
```
6. 执行数据一致性校验。
```sql
-CHECK MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8' BY TYPE (NAME='CRC32_MATCH');
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| table_name | source_records_count | target_records_count | records_count_matched | records_content_matched |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| t_order | 6 | 6 | true | true |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
+CHECK MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6' BY TYPE (NAME='CRC32_MATCH');
+Query OK, 0 rows affected (0.09 sec)
```
数据一致性校验算法类型来自：
@@ -208,10 +204,20 @@ SHOW MIGRATION CHECK ALGORITHMS;
异构迁移需要使用`DATA_MATCH`。
+查询数据一致性校验进度：
+```sql
+SHOW MIGRATION CHECK STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| tables | result | finished_percentage | remaining_seconds | check_begin_time | check_end_time | duration_seconds | error_message |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| t_order | true | 100 | 0 | 2022-10-13 11:18:15.171 | 2022-10-13 11:18:15.878 | 0 | |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+```
+
7. 完成作业。
```sql
-COMMIT MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8';
+COMMIT MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6';
```
8. 刷新元数据。
@@ -239,6 +245,7 @@ REFRESH TABLE METADATA;
wal_level = logical
max_wal_senders = 10
max_replication_slots = 10
+wal_sender_timeout = 0
max_connections = 600
```
@@ -357,39 +364,45 @@ SHOW MIGRATION LIST;
示例结果：
```sql
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| id | tables | sharding_total_count | active | create_time | stop_time |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| j015d4ee1b8a5e7f95df19babb2794395e8 | t_order | 1 | true | 2022-08-22 16:37:01 | NULL |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| id | tables | sharding_total_count | active | create_time | stop_time |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| j01016e501b498ed1bdb2c373a2e85e2529a6 | t_order | 1 | true | 2022-10-13 11:16:01 | NULL |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
```
5. 查看数据迁移详情。
```sql
-SHOW MIGRATION STATUS 'j015d4ee1b8a5e7f95df19babb2794395e8';
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| item | data_source | status | active | inventory_finished_percentage | incremental_idle_seconds |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 100 | 141 |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
+SHOW MIGRATION STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| item | data_source | status | active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 6 | 100 | 81 | |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
```
6. 执行数据一致性校验。
```sql
-CHECK MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8';
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| table_name | source_records_count | target_records_count | records_count_matched | records_content_matched |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| t_order | 6 | 6 | true | true |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
+CHECK MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6';
+Query OK, 0 rows affected (0.09 sec)
+```
+
+查询数据一致性校验进度：
+```sql
+SHOW MIGRATION CHECK STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| tables | result | finished_percentage | remaining_seconds | check_begin_time | check_end_time | duration_seconds | error_message |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| t_order | true | 100 | 0 | 2022-10-13 11:18:15.171 | 2022-10-13 11:18:15.878 | 0 | |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
```
7. 完成作业。
```sql
-COMMIT MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8';
+COMMIT MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6';
```
8. 刷新元数据。
@@ -534,39 +547,45 @@ SHOW MIGRATION LIST;
示例结果：
```sql
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| id | tables | sharding_total_count | active | create_time | stop_time |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| j015d4ee1b8a5e7f95df19babb2794395e8 | t_order | 1 | true | 2022-08-22 16:37:01 | NULL |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| id | tables | sharding_total_count | active | create_time | stop_time |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| j01016e501b498ed1bdb2c373a2e85e2529a6 | t_order | 1 | true | 2022-10-13 11:16:01 | NULL |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
```
5. 查看数据迁移详情。
```sql
-SHOW MIGRATION STATUS 'j015d4ee1b8a5e7f95df19babb2794395e8';
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| item | data_source | status | active | inventory_finished_percentage | incremental_idle_seconds |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 100 | 141 |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
+SHOW MIGRATION STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| item | data_source | status | active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 6 | 100 | 81 | |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
```
6. 执行数据一致性校验。
```sql
-CHECK MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8';
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| table_name | source_records_count | target_records_count | records_count_matched | records_content_matched |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| t_order | 6 | 6 | true | true |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
+CHECK MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6';
+Query OK, 0 rows affected (0.09 sec)
+```
+
+查询数据一致性校验进度：
+```sql
+SHOW MIGRATION CHECK STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| tables | result | finished_percentage | remaining_seconds | check_begin_time | check_end_time | duration_seconds | error_message |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| t_order | true | 100 | 0 | 2022-10-13 11:18:15.171 | 2022-10-13 11:18:15.878 | 0 | |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
```
7. 完成作业。
```sql
-COMMIT MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8';
+COMMIT MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6';
```
8. 刷新元数据。
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/migration/usage.en.md b/docs/document/content/user-manual/shardingsphere-proxy/migration/usage.en.md
index e8cc18e8353..4b1a10808e8 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/migration/usage.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/migration/usage.en.md
@@ -7,7 +7,7 @@ weight = 2
### Environment
-Supported MySQL versions: 5.1.15 to 5.7.x.
+Supported MySQL versions: 5.1.15 to 8.0.x.
### Authority required
@@ -160,33 +160,29 @@ SHOW MIGRATION LIST;
Result example:
```
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| id | tables | sharding_total_count | active | create_time | stop_time |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| j015d4ee1b8a5e7f95df19babb2794395e8 | t_order | 1 | true | 2022-08-22 16:37:01 | NULL |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| id | tables | sharding_total_count | active | create_time | stop_time |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| j01016e501b498ed1bdb2c373a2e85e2529a6 | t_order | 1 | true | 2022-10-13 11:16:01 | NULL |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
```
5. View the data migration details.
```
-SHOW MIGRATION STATUS 'j015d4ee1b8a5e7f95df19babb2794395e8';
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| item | data_source | status | active | inventory_finished_percentage | incremental_idle_seconds |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 100 | 141 |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
+SHOW MIGRATION STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| item | data_source | status | active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 6 | 100 | 81 | |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
```
6. Verify data consistency.
```
-CHECK MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8' BY TYPE (NAME='CRC32_MATCH');
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| table_name | source_records_count | target_records_count | records_count_matched | records_content_matched |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| t_order | 6 | 6 | true | true |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
+CHECK MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6' BY TYPE (NAME='CRC32_MATCH');
+Query OK, 0 rows affected (0.09 sec)
```
Data consistency check algorithm list:
@@ -205,10 +201,20 @@ If encrypt rule is configured in target proxy, then `DATA_MATCH` could be used.
If you are migrating to a heterogeneous database, then `DATA_MATCH` could be used.
+Query data consistency check progress:
+```sql
+SHOW MIGRATION CHECK STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| tables | result | finished_percentage | remaining_seconds | check_begin_time | check_end_time | duration_seconds | error_message |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| t_order | true | 100 | 0 | 2022-10-13 11:18:15.171 | 2022-10-13 11:18:15.878 | 0 | |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+```
+
7. Commit the job.
```sql
-COMMIT MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8';
+COMMIT MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6';
```
8. Refresh table metadata.
@@ -231,11 +237,12 @@ Supported PostgreSQL version: 9.4 or later.
2. Modify WAL Configuration.
-`postgresql.conf` configuration sample:
+`postgresql.conf` configuration sample:
```
wal_level = logical
max_wal_senders = 10
max_replication_slots = 10
+wal_sender_timeout = 0
max_connections = 600
```
@@ -351,42 +358,48 @@ MIGRATE TABLE ds_0.public.t_order INTO sharding_db.t_order;
SHOW MIGRATION LIST;
```
-Result sample:
+Result example:
```
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| id | tables | sharding_total_count | active | create_time | stop_time |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| j015d4ee1b8a5e7f95df19babb2794395e8 | t_order | 1 | true | 2022-08-22 16:37:01 | NULL |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| id | tables | sharding_total_count | active | create_time | stop_time |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| j01016e501b498ed1bdb2c373a2e85e2529a6 | t_order | 1 | true | 2022-10-13 11:16:01 | NULL |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
```
5. View the data migration details.
```
-SHOW MIGRATION STATUS 'j015d4ee1b8a5e7f95df19babb2794395e8';
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| item | data_source | status | active | inventory_finished_percentage | incremental_idle_seconds |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 100 | 141 |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
+SHOW MIGRATION STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| item | data_source | status | active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 6 | 100 | 81 | |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
```
6. Verify data consistency.
```
-CHECK MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8';
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| table_name | source_records_count | target_records_count | records_count_matched | records_content_matched |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| t_order | 6 | 6 | true | true |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
+CHECK MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6';
+Query OK, 0 rows affected (0.09 sec)
+```
+
+Query data consistency check progress:
+```sql
+SHOW MIGRATION CHECK STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| tables | result | finished_percentage | remaining_seconds | check_begin_time | check_end_time | duration_seconds | error_message |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| t_order | true | 100 | 0 | 2022-10-13 11:18:15.171 | 2022-10-13 11:18:15.878 | 0 | |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
```
7. Commit the job.
```sql
-COMMIT MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8';
+COMMIT MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6';
```
8. Refresh table metadata.
@@ -528,42 +541,48 @@ MIGRATE TABLE ds_0.public.t_order INTO sharding_db.t_order;
SHOW MIGRATION LIST;
```
-Result example:
+Result example:
```
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| id | tables | sharding_total_count | active | create_time | stop_time |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
-| j015d4ee1b8a5e7f95df19babb2794395e8 | t_order | 1 | true | 2022-08-22 16:37:01 | NULL |
-+-------------------------------------+---------+----------------------+--------+---------------------+-----------+
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| id | tables | sharding_total_count | active | create_time | stop_time |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
+| j01016e501b498ed1bdb2c373a2e85e2529a6 | t_order | 1 | true | 2022-10-13 11:16:01 | NULL |
++---------------------------------------+---------+----------------------+--------+---------------------+-----------+
```
5. View the data migration details.
```
-SHOW MIGRATION STATUS 'j015d4ee1b8a5e7f95df19babb2794395e8';
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| item | data_source | status | active | inventory_finished_percentage | incremental_idle_seconds |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
-| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 100 | 141 |
-+------+-------------+--------------------------+--------+-------------------------------+--------------------------+
+SHOW MIGRATION STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| item | data_source | status | active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
+| 0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 6 | 100 | 81 | |
++------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
```
6. Verify data consistency.
```
-CHECK MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8';
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| table_name | source_records_count | target_records_count | records_count_matched | records_content_matched |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
-| t_order | 6 | 6 | true | true |
-+------------+----------------------+----------------------+-----------------------+-------------------------+
+CHECK MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6';
+Query OK, 0 rows affected (0.09 sec)
+```
+
+Query data consistency check progress:
+```sql
+SHOW MIGRATION CHECK STATUS 'j01016e501b498ed1bdb2c373a2e85e2529a6';
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| tables | result | finished_percentage | remaining_seconds | check_begin_time | check_end_time | duration_seconds | error_message |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
+| t_order | true | 100 | 0 | 2022-10-13 11:18:15.171 | 2022-10-13 11:18:15.878 | 0 | |
++---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
```
7. Commit the job.
```sql
-COMMIT MIGRATION 'j015d4ee1b8a5e7f95df19babb2794395e8';
+COMMIT MIGRATION 'j01016e501b498ed1bdb2c373a2e85e2529a6';
```
8. Refresh table metadata.