mysql将数据全量导入到tidb,算是静态数据可以用mysqldump吗

可以用官方的dumpling工具,测试过,没问题

执行备份 (使用 tiup dumpling)

tiup dumpling
-h ${MYSQL_HOST}
–port ${MYSQL_PORT}
-u ${MYSQL_USER}
-p ${MYSQL_PASS}
-B 数据库名
-T 表1,表2,表3
–threads 5
–rows 200000
-F 256MiB
–output “${BACKUP_DIR}/${BACKUP_DB}_${BACKUP_TIMESTAMP}” >> $LOG_FILE 2>&1

执行恢复tiup tidb-lightning -config tidb-lightning.toml

vim tidb-lightning.toml
[lightning]
level = “info”
file = “tidb-lightning.log”

[tikv-importer]
backend = “local”
sorted-kv-dir = “/app/tmp/” – 磁盘大一点的路径

[mydumper]
data-source-dir = “备份文件路径”

[tidb]
host = “127.0.0.1”
port = 4000
user = “”
password = “”
status-port = 10080
pd-addr = “1.6.0.1:2379,1.6.0.2:2379,1.6.0.3:2379” – pd地址