TiDB
UDTS supports TiDB as a data transfer source/target, supporting version 3.* and above.
TiDB Form Filling
| Parameter Name | Description |
|---|---|
| IP | For intranet addresses, you need to fill in VPC and subnet information. |
| Port | Connection port |
| Username | Connection username |
| Password | Password corresponding to the username |
| Database Name | If it is a single database, please fill in the database name; if it is multiple databases, fill in the database list separated by commas; if it is all databases, please fill in * |
| Table Name | The name of the table to transfer, only valid when migrating a single database. If it is a single table, please fill in the table name; if it is multiple tables, fill in the comma-separated list; if not filled or filled with *, the entire database will be migrated |
Pre-check Items
When using TiDB as the source database, it is suggested that the TiDB parameter tikv_gc_life_time be greater than 1 hour to avoid migration failures caused by GC during the migration process.
Query method:
select VARIABLE_NAME, VARIABLE_VALUE from mysql.tidb where VARIABLE_NAME = "tikv_gc_life_time"Setting method:
set global tidb_gc_life_time = '24h';