ALTER RESHARDING RULE 

ALTER RESHARDING RULE (READ(RATE_LIMITER (TYPE(NAME='QPS’,PROPERTIES(‘qps'='5000’)))))

RESHARD TABLE tableName BY rule 

RESHARD TABLE t_order BY(
    STORAGE_UNITS(ds_0, ds_1, ds_2),
    SHARDING_COLUMN=order_id,
    TYPE(NAME="hash_mod",PROPERTIES("sharding-count"="6")),
    KEY_GENERATE_STRATEGY(COLUMN=order_id,TYPE(NAME="snowflake"))
);

SHOW RESHARDING LIST;

SHOW RESHARDING LIST;
+---------------------------------------+---------+----------------------+--------+---------------------+-----------+
| id                                    | tables  | sharding_total_count | active | create_time         | stop_time |
+---------------------------------------+---------+----------------------+--------+---------------------+-----------+
| j51017f973ac82cb1edea4f5238a258c25e89 | t_order | 2                    | true   | 2022-10-25 10:10:58 | NULL      |
+---------------------------------------+---------+----------------------+--------+---------------------+-----------+

SHOW RESHARDING LIST;

SHOW RESHARDING LIST;
+---------------------------------------+---------+----------------------+--------+---------------------+-----------+
| id                                    | tables  | sharding_total_count | active | create_time         | stop_time |
+---------------------------------------+---------+----------------------+--------+---------------------+-----------+
| j51017f973ac82cb1edea4f5238a258c25e89 | t_order | 2                    | true   | 2022-10-25 10:10:58 | NULL      |
+---------------------------------------+---------+----------------------+--------+---------------------+-----------+

SHOW RESHARDING STATUS jobId;

SHOW RESHARDING STATUS 'j51017f973ac82cb1edea4f5238a258c25e89';
+------+-------------+--------------------------+--------+-------------------------+-------------------------------+-------------------+--------------------------+---------------+
| item | data_source | status                   | active | processed_records_count | inventory_finished_percentage | remaining_seconds | incremental_idle_seconds | error_message |
+------+-------------+--------------------------+--------+-------------------------+-------------------------------+-------------------+--------------------------+---------------+
| 0    | ds_0        | EXECUTE_INCREMENTAL_TASK | true   | 3                       | 100                           | 0                 | 92                       |               |
| 1    | ds_1        | EXECUTE_INCREMENTAL_TASK | true   | 3                       | 100                           | 0                 | 92                       |               |
+------+-------------+--------------------------+--------+-------------------------+-------------------------------+-------------------+--------------------------+---------------+

START RESHARDING jobId

START RESHARDING 'j51017f973ac82cb1edea4f5238a258c25e89';

STOP RESHARDING jobId

STOP RESHARDING 'j51017f973ac82cb1edea4f5238a258c25e89';

CHECK RESHARDING jobId

CHECK RESHARDING 'j01016e501b498ed1bdb2c373a2e85e2529a6' BY TYPE (NAME='CRC32_MATCH');
Query OK, 0 rows affected (0.09 sec)

CHECK RESHARDING 'j01016e501b498ed1bdb2c373a2e85e2529a6';
Query OK, 0 rows affected (0.09 sec)

START RESHARDING CHECK jobId

START RESHARDING CHECK  'j51017f973ac82cb1edea4f5238a258c25e89';

STOP RESHARDING CHECK jobId

STOP RESHARDING CHECK  'j51017f973ac82cb1edea4f5238a258c25e89';

DROP RESHARDING CHECK jobId

DROP RESHARDING CHECK 'j51017f973ac82cb1edea4f5238a258c25e89';

COMMIT RESHARDING jobId

COMMIT RESHARDING 'j51017f973ac82cb1edea4f5238a258c25e89';

FORCE COMMIT RESHARDING jobId

FORCE COMMIT RESHARDING 'j51017f973ac82cb1edea4f5238a258c25e89';

ROLLBACK RESHARDING jobId

ROLLBACK RESHARDING 'j51017f973ac82cb1edea4f5238a258c25e89';

APPLY RESHARDING jobId

APPLY RESHARDING 'j51017f973ac82cb1edea4f5238a258c25e89';

FORCE APPLY RESHARDING jobId

FORCE APPLY RESHARDING 'j51017f973ac82cb1edea4f5238a258c25e89';

SHOW RESHARDING CHECK ALGORITHMS;

SHOW RESHARDING CHECK ALGORITHMS;
+-------------+--------------------------------------------------------------+----------------------------+
| type        | supported_database_types                                     | description                |
+-------------+--------------------------------------------------------------+----------------------------+
| CRC32_MATCH | MySQL                                                        | Match CRC32 of records.    |
| DATA_MATCH  | SQL92,MySQL,MariaDB,PostgreSQL,openGauss,Oracle,SQLServer,H2 | Match raw data of records. |
+-------------+--------------------------------------------------------------+----------------------------+

STOP RESHARDING SOURCE WRITING jobId

STOP RESHARDING SOURCE WRITING 'j51017f973ac82cb1edea4f5238a258c25e89';

RESTORE RESHARDING SOURCE WRITING jobId

RESTORE RESHARDING SOURCE WRITING 'j51017f973ac82cb1edea4f5238a258c25e89';

AUTO RESHARD TABLE tableName BY rule

AUTO RESHARD TABLE t_order BY(
    STORAGE_UNITS(ds_0, ds_1, ds_2),
    SHARDING_COLUMN=order_id,
    TYPE(NAME="hash_mod",PROPERTIES("sharding-count"="6")),
    KEY_GENERATE_STRATEGY(COLUMN=order_id,TYPE(NAME="snowflake"))
);

AUTO RESHARD TABLE tableName BY rule

AUTO RESHARD TABLE t_order BY(
    STORAGE_UNITS(ds_0, ds_1, ds_2),
    SHARDING_COLUMN=order_id,
    TYPE(NAME="hash_mod",PROPERTIES("sharding-count"="6")),
    KEY_GENERATE_STRATEGY(COLUMN=order_id,TYPE(NAME="snowflake"))
);