tidb dm同步数据

1.部署集群:
tiup dm deploy dm-test v6.2.0 ./topology.yaml
tiup dm start dm-test


2.创建数据源

tiup dmctl --master-addr 192.168.1.133:8261 operate-source create source-mysql-01.yaml

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES,
EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER
on xxx.* to test_dm@'%';

3.任务检查

tiup dmctl --master-addr 192.168.1.133:8261 check-task ./task.yaml

4.启动任务
tiup dmctl --master-addr 192.168.1.133:8261 start-task ./task.yaml
数据同步完成

posted @ 2022-09-26 15:51  东哥加油!!!  阅读(63)  评论(0编辑  收藏  举报