可以用官方的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地址