The data migration process described in this document uses TiDB Lightning. The steps are as follows.
Before you start the migration, deploy TiDB Lightning.
This document takes the TiDB-backend as an example. Create the
tidb-lightning.toml configuration file and add the following major configurations in the file:
[mydumper]to the path of the MySQL SQL file.[mydumper] # Data source directory data-source-dir = "/data/export"
Add the configuration of the target TiDB cluster.[tidb] # The target cluster information. Fill in one address of tidb-server. host = "172.16.31.1" port = 4000 user = "root" password = ""
For other configurations, see TiDB Lightning Configuration.
Run TiDB Lightning to start the import operation. If you start TiDB Lightning by using
nohup directly in the command line, the program might exit because of the
SIGHUP signal. Therefore, it is recommended to write
nohup in a script. For example:
# !/bin/bash nohup ./tidb-lightning -config tidb-lightning.toml > nohup.out &
When the import operation is started, view the progress by the following two ways:
progressin logs, which is updated every 5 minutes by default.
- Access the monitoring dashboard. See Monitor TiDB Lightning for details.