mysql作为tidb从库配置

前提：已部署好pump
1.搭建好mysql
2.全量备份导入导出
3.部署 Drainer
进入导出数据的文件夹，查看initial_commit_ts

[root@mylinux]# cat metadata
Started dump at: 2019-08-02 15:00:21
SHOW MASTER STATUS:
        Log: tidb-binlog
        Pos: 409951888810442753
        GTID:

Finished dump at: 2019-08-02 15:11:20

取CommitTS 的值409951888810442753作为 Drainer 初次启动使用的 initial-commit-ts 参数
修改inventory.ini，drainer可以和tidb部署在同一台
vi inventory.ini

[drainer_servers]
drainer_mysql ansible_host=192.168.0.1 initial_commit_ts="409951888810442753"

修改drainer参数文件，填写下游mysql信息
cd /home/tidb/tidb-ansible/conf
cp drainer.toml drainer_mysql_drainer.toml
vi drainer_mysql_drainer.toml
[syncer]

# downstream storage, equal to --dest-db-type
# Valid values are "mysql", "file", "kafka", "flash".
db-type = "mysql"

# the downstream MySQL protocol database
[syncer.to]
host = "192.168.0.2"
user = "root"
password = "123456"
port = 3306
# time-limit = "30s"
# size-limit = "100000"

ansible-playbook deploy_drainer.yml
4.启动Drainer
ansible-playbook start_drainer.yml