根据TiDB Binlog 教程安装时报错

🪐 TiDB 技术问题
1

image
image740×85 3.13 KB

image
image1280×244 22.2 KB

2

[root@tidb tidb-v3.0.14-linux-amd64]# for f in *.toml; do echo “$f:”; cat “$f”; echo; done drainer.toml:

log-file="drainer.log"
[syncer]
db-type="mysql"
[syncer.to]
host="127.0.0.1"
user="root"
password="root"
port=3456

pd.toml:
log-file="pd.log"
data-dir="pd.data"

pump.toml:
log-file="pump.log"
data-dir="pump.data"
addr="127.0.0.1:8250"
advertise-addr="127.0.0.1:8250"
pd-urls="http://127.0.0.1:2379"

tidb.toml:
store="tikv"
path="127.0.0.1:2379"
[log.file]
filename="tidb.log"
[binlog]
enable=true

tikv.toml:
log-file="tikv.log"
[storage]
data-dir="tikv.data"
[pd]
endpoints=["127.0.0.1:2379"]
[rocksdb]
max-open-files=1024
[raftdb]
max-open-files=1024
3
  1. 请问是单机docker环境搭建binlog吗？
  2. 请检查防火墙是否都关闭了，端口是否放通。

https://pingcap.com/docs-cn/stable/online-deployment-using-ansible/

4

不是docker环境，没有firewalld防火墙
image

5

[root@tidb tidb-v3.0.14-linux-amd64]# netstat -lantu | grep 2379 tcp 0 0 127.0.0.1:2379 0.0.0.0:* LISTEN
tcp 0 0 10.186.61.51:2379 0.0.0.0:* LISTEN
tcp 0 0 10.186.61.51:57322 10.186.61.51:2379 ESTABLISHED tcp 0 0 127.0.0.1:43552 127.0.0.1:2379 ESTABLISHED tcp 0 0 127.0.0.1:43394 127.0.0.1:2379 ESTABLISHED tcp 0 17 10.186.61.51:2379 10.186.61.51:55372 ESTABLISHED tcp 0 0 127.0.0.1:2379 127.0.0.1:43290 ESTABLISHED tcp 0 0 127.0.0.1:2379 127.0.0.1:43390 ESTABLISHED tcp 0 17 127.0.0.1:2379 127.0.0.1:43396 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.51:55606 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.42:54086 ESTABLISHED tcp 0 0 127.0.0.1:2379 127.0.0.1:55484 ESTABLISHED tcp 0 0 127.0.0.1:43400 127.0.0.1:2379 ESTABLISHED tcp 0 0 10.186.61.51:57324 10.186.61.51:2379 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.51:55378 ESTABLISHED tcp 0 0 10.186.61.51:56688 10.186.61.51:2379 TIME_WAIT
tcp 0 0 10.186.61.51:2379 10.186.61.39:42754 ESTABLISHED tcp 0 0 127.0.0.1:43396 127.0.0.1:2379 ESTABLISHED tcp 0 0 127.0.0.1:2379 127.0.0.1:43392 ESTABLISHED tcp 0 0 127.0.0.1:43390 127.0.0.1:2379 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.37:56188 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.51:57322 ESTABLISHED tcp 0 0 10.186.61.51:55372 10.186.61.51:2379 ESTABLISHED tcp 0 0 10.186.61.51:55378 10.186.61.51:2379 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.51:56668 TIME_WAIT
tcp 0 0 10.186.61.51:2379 10.186.61.51:57830 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.51:55610 ESTABLISHED tcp 0 0 127.0.0.1:2379 127.0.0.1:43400 ESTABLISHED tcp 0 0 127.0.0.1:43290 127.0.0.1:2379 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.51:56742 TIME_WAIT
tcp 0 0 10.186.61.51:2379 10.186.61.51:56634 TIME_WAIT
tcp 0 0 127.0.0.1:2379 127.0.0.1:43552 ESTABLISHED tcp 0 0 127.0.0.1:2379 127.0.0.1:43288 ESTABLISHED tcp 0 0 127.0.0.1:2379 127.0.0.1:43394 ESTABLISHED tcp 0 0 10.186.61.51:55606 10.186.61.51:2379 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.51:56684 TIME_WAIT
tcp 0 0 10.186.61.51:57830 10.186.61.51:2379 ESTABLISHED tcp 0 0 10.186.61.51:56602 10.186.61.51:2379 TIME_WAIT
tcp 0 0 127.0.0.1:43288 127.0.0.1:2379 ESTABLISHED tcp 0 0 10.186.61.51:55610 10.186.61.51:2379 ESTABLISHED tcp 0 0 127.0.0.1:43392 127.0.0.1:2379 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.51:57324 ESTABLISHED tcp 0 0 10.186.61.51:2379 10.186.61.51:56558 TIME_WAIT
tcp6 0 0 127.0.0.1:55484 127.0.0.1:2379 ESTABLISHED tcp6 0 0 127.0.0.1:55302 127.0.0.1:2379 TIME_WAIT
tcp6 0 0 10.186.61.51:56704 10.186.61.51:2379 TIME_WAIT
tcp6 0 0 10.186.61.51:56702 10.186.61.51:2379 TIME_WAIT
tcp6 0 0 10.186.61.51:56652 10.186.61.51:2379 TIME_WAIT
tcp6 0 0 10.186.61.51:56696 10.186.61.51:2379 TIME_WAIT
tcp6 0 0 10.186.61.51:56654 10.186.61.51:2379 TIME_WAIT
tcp6 0 0 10.186.61.51:56480 10.186.61.51:2379 TIME_WAIT
tcp6 0 0 10.186.61.51:56700 10.186.61.51:2379 TIME_WAIT
tcp6 0 0 10.186.61.51:56648 10.186.61.51:2379 TIME_WAIT
tcp6 0 0 10.186.61.51:56656 10.186.61.51:2379 TIME_WAIT
tcp6 0 0 10.186.61.51:56472 10.186.61.51:2379 TIME_WAIT

6
  1. 请问参考哪个文档安装的，使用的什么方式 ansible 还是 tiup
  2. 当前给的是tidb的日志，具体哪一步报错了？ 启动时候吗？ 如果是请反馈 pump 和drainer 的状态
  3. 如果已经安装完成，请上传 pump 和 drainer 的日志。
7

1、集群部署方式：https://pingcap.com/docs-cn/dev/production-deployment-using-tiup/
binlog部署方式：https://pingcap.com/docs-cn/dev/get-started-with-tidb-binlog/
2、使用： ```
sleep 3 &&
./bin/tidb-server --config=tidb.toml &>tidb.out &
命令启动时，自动退出

image
image842×83 2.96 KB

pump日志
image
image1283×209 18.6 KB

pump状态
image
image725×77 3.48 KB

drainer状态
image

8
  1. 没找到您的启动方式
  2. 如果是使用tiup 安装，在部署阶段可以参考文档直接部署 binlog，使用tiup直接启动，不需要手工启动

https://pingcap.com/docs-cn/dev/production-deployment-using-tiup/

  1. 如果是使用tiup 扩容方式安装binlog，参考文档

https://pingcap.com/docs-cn/dev/scale-tidb-using-tiup/

9

请问哪一步是部署binlog的

image
image813×590 33.2 KB

10

image
image1239×243 19.6 KB

11

我尝试一下

12

好的，有问题麻烦再反馈，多谢