2个集群都是 v3.0.5
tidb-docker-compose 中启动了 一个 pump0 和 drainer 。 查看日志发现 如下错误，不知道这么解决，求助。
==> logs/drainer.log <==
[2020/05/11 10:26:26.892 +00:00] [FATAL] [main.go:50] ["create drainer server failed"] [error="initialize tidb type checkpoint with config &{CheckpointType:tidb Db:0xc000128780 Schema:tidb_binlog Table:checkpoint ClusterID:6709749656914679167 InitialCommitTS:416596763571388418 CheckPointFile:/data/data.drainer/savepoint}: exec failed, sql: create schema if not exists tidb_binlog: dial tcp 10.0.0.15:4000: connect: connection timed out"] [errorVerbose="dial tcp 10.0.0.15:4000: connect: connection timed out\
exec failed, sql: create schema if not exists tidb_binlog\
github.com/pingcap/tidb-binlog/drainer/checkpoint.newMysql\
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb-binlog/drainer/checkpoint/mysql.go:69\
github.com/pingcap/tidb-binlog/drainer/checkpoint.NewCheckPoint\
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb-binlog/drainer/checkpoint/checkpoint.go:54\
github.com/pingcap/tidb-binlog/drainer.NewServer\
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb-binlog/drainer/server.go:136\
main.main\
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb-binlog/cmd/drainer/main.go:48\
runtime.main\
\t/usr/local/go/src/runtime/proc.go:203\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1357\
initialize tidb type checkpoint with config &{CheckpointType:tidb Db:0xc000128780 Schema:tidb_binlog Table:checkpoint ClusterID:6709749656914679167 InitialCommitTS:416596763571388418 CheckPointFile:/data/data.drainer/savepoint}"] [stack="github.com/pingcap/log.Fatal\
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/pkg/mod/github.com/pingcap/log@v0.0.0-20190715063458-479153f07ebd/global.go:59\
main.main\
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb-binlog/cmd/drainer/main.go:50\
runtime.main\
\t/usr/local/go/src/runtime/proc.go:203"]
[2020/05/11 10:26:27.408 +00:00] [INFO] [version.go:50] ["Welcome to Drainer"] ["Release Version"=v3.0.12] ["Git Commit Hash"=e4f2ba252977385faa32a0553808cc564d22929a] ["Build TS"="2020-03-16 12:36:21"] ["Go Version"=go1.13] ["Go OS/Arch"=linux/amd64]
[2020/05/11 10:26:27.410 +00:00] [INFO] [main.go:46] ["start drainer..."] [config="{\"log-level\":\"info\",\"node-id\":\"\",\"addr\":\"http://0.0.0.0:8249\",\"advertise-addr\":\"http://0.0.0.0:8249\",\"data-dir\":\"/data/data.drainer\",\"detect-interval\":10,\"pd-urls\":\"http://pd0:2379,http://pd1:2379,http://pd2:2379\",\"log-file\":\"/logs/drainer.log\",\"initial-commit-ts\":416596763571388418,\"sycner\":{\"sql-mode\":null,\"ignore-txn-commit-ts\":null,\"ignore-schemas\":\"INFORMATION_SCHEMA,PERFORMANCE_SCHEMA,mysql\",\"ignore-table\":null,\"txn-batch\":20,\"loopback-control\":false,\"sync-ddl\":true,\"channel-id\":0,\"worker-count\":16,\"to\":{\"host\":\"10.0.0.15\",\"user\":\"root\",\"password\":\"\",\"encrypted_password\":\"\",\"sync-mode\":0,\"port\":4000,\"checkpoint\":{\"type\":\"\",\"schema\":\"\",\"host\":\"\",\"user\":\"\",\"password\":\"\",\"encrypted_password\":\"\",\"port\":0},\"dir\":\"\",\"zookeeper-addrs\":\"\",\"kafka-addrs\":\"\",\"kafka-version\":\"\",\"kafka-max-messages\":0,\"kafka-client-id\":\"\",\"topic-name\":\"\"},\"replicate-do-table\":null,\"replicate-do-db\":null,\"db-type\":\"tidb\",\"disable-dispatch\":false,\"relay\":{\"log-dir\":\"\",\"max-file-size\":10485760},\"safe-mode\":false,\"disable-detect\":false},\"security\":{\"ssl-ca\":\"\",\"ssl-cert\":\"\",\"ssl-key\":\"\"},\"synced-check-time\":5,\"compressor\":\"\",\"EtcdTimeout\":5000000000,\"MetricsAddr\":\"\",\"MetricsInterval\":15}"]
[2020/05/11 10:26:27.410 +00:00] [INFO] [client.go:144] ["[pd] create pd client with endpoints"] [pd-address="[http://pd0:2379,http://pd1:2379,http://pd2:2379]"]
[2020/05/11 10:26:27.413 +00:00] [INFO] [client.go:252] ["[pd] switch leader"] [new-leader=http://pd0:2379] [old-leader=]
[2020/05/11 10:26:27.413 +00:00] [INFO] [client.go:163] ["[pd] init cluster id"] [cluster-id=6709749656914679167]
[2020/05/11 10:26:27.413 +00:00] [INFO] [server.go:115] ["get cluster id from pd"] [id=6709749656914679167]
==> logs/pump0.log <==
[2020/05/11 10:26:29.701 +00:00] [INFO] [storage.go:384] [DBStats] [DBStats="{\"WriteDelayCount\":0,\"WriteDelayDuration\":0,\"WritePaused\":false,\"AliveSnapshots\":0,\"AliveIterators\":0,\"IOWrite\":11280,\"IORead\":34224,\"BlockCacheSize\":48355,\"OpenedTablesCount\":7,\"LevelSizes\":[110621],\"LevelTablesCounts\":[7],\"LevelRead\":[0],\"LevelWrite\":[0],\"LevelDurations\":[0]}"]
[2020/05/11 10:26:29.704 +00:00] [INFO] [server.go:544] ["server info tick"] [writeBinlogCount=0] [alivePullerCount=0] [MaxCommitTS=416597354508451841]
[2020/05/11 10:26:39.701 +00:00] [INFO] [storage.go:384] [DBStats] [DBStats="{\"WriteDelayCount\":0,\"WriteDelayDuration\":0,\"WritePaused\":false,\"AliveSnapshots\":0,\"AliveIterators\":0,\"IOWrite\":11857,\"IORead\":34224,\"BlockCacheSize\":48355,\"OpenedTablesCount\":7,\"LevelSizes\":[110621],\"LevelTablesCounts\":[7],\"LevelRead\":[0],\"LevelWrite\":[0],\"LevelDurations\":[0]}"]
[2020/05/11 10:26:39.704 +00:00] [INFO] [server.go:544] ["server info tick"] [writeBinlogCount=0] [alivePullerCount=0] [MaxCommitTS=416597356867747841]
配置如下：
drainer
[root@VM_0_3_centos tidb-docker-compose]# cat config/drainer.toml | egrep -v "#|^$"
detect-interval = 10
data-dir = "data.drainer"
pd-urls = "http://pd0:2379"
compressor = ""
[syncer]
txn-batch = 20
worker-count = 16
disable-dispatch = false
safe-mode = false
db-type = "tidb"
ignore-schemas = "INFORMATION_SCHEMA,PERFORMANCE_SCHEMA,mysql"
[syncer.to]
host = "10.0.0.15"
user = "root"
port = 4000
[syncer.to.checkpoint]
pump
[root@VM_0_3_centos tidb-docker-compose]# cat config/pump.toml | egrep -v "#|^$"
addr = "127.0.0.1:8250"
advertise-addr = ""
gc = 7
data-dir = "data.pump"
heartbeat-interval = 2
pd-urls = "http://pd0:2379"