TIDB扩容--binlog

1、编辑扩容文件

cat scale_out_binlog.yaml 
pump_servers:
- host: 192.168.10.32	# 指定要在那台服务器部署
  ssh_port: 22
  port: 8250	# 启动端口
  deploy_dir: /erp/tidb-deploy/pump-8250 
  data_dir: /erp/tidb-data/pump-8250
  log_dir: /erp/tidb-deploy/pump-8250/logs
  config:
    gc: 180 # 日志保留天数
    log-file: /erp/tidb-deploy/pump-8250/logs
    pd-urls: http://192.168.10.31:2379,http://192.168.10.32:2379,http://192.168.10.33:2379 # 连接pd集群

drainer_servers:
- host: 192.168.10.33	# 指定要在那台服务器部署
  ssh_port: 22
  port: 8249
  deploy_dir: /erp/tidb-deploy/drainer-8249
  data_dir: /erp/tidb-data/drainer-8249
  log_dir: /erp/tidb-deploy/drainer-8249/logs
  config:
    pd-urls: http://192.168.10.31:2379,http://192.168.10.32:2379,http://192.168.10.33:2379
    syncer.db-type: file    # 同步类型
    syncer.to.host: 192.168.10.30	# tidb连接IP
    syncer.to.password: ""			# tidb连接密码
    syncer.to.port: 4000			# tidb连接端口
    syncer.to.user: root			# tidb连接用户名
    syncer.ignore-schemas: INFORMATION_SCHEMA,PERFORMANCE_SCHEMA,mysql  # 不同步哪些库
    syncer.ignore-table:    # 忽略那些表
      - db-name: "*"		# 所有库中以sc开头的表忽略同步
        tbl-name: "~^sc.*"
      - db-name: "*"		
        tbl-name: "~^tmp.*"	# 所有库中以tmp开头的表忽略同步
      - db-name: "*"
        tbl-name: "~^dim.*"	# 所有库中以dim开头的表忽略同步
      - db-name: "*"
        tbl-name: "~^sync_table_batch"

2、tiup 扩容

tiup cluster scale-out tidb-集群名称 scale_out_binlog.yaml --user root -p # 指定用户名密码可选

> 修改集群配置

tiup cluster edit-config tidb-集群名称

server_configs:
  tidb:
    binlog.enable: true
    binlog.ignore-error: true

> 重启

tiup cluster reload tidb-v1 -R tidb
tiup cluster reload tidb-v1 -R pump
tiup cluster reload tidb-v1 -R drainer

MySQL [(none)]> show global variables like "log_bin";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | 1     |
+---------------+-------+
1 row in set (0.02 sec)

MySQL [(none)]> show pump status;
+--------------------+--------------------+--------+--------------------+---------------------+
| NodeID             | Address            | State  | Max_Commit_Ts      | Update_Time         |
+--------------------+--------------------+--------+--------------------+---------------------+
| 192.168.10.32:8250 | 192.168.10.32:8250 | online | 436050664160755713 | 2022-09-17 15:54:36 |
+--------------------+--------------------+--------+--------------------+---------------------+
1 row in set (0.00 sec)

MySQL [(none)]> show drainer status;
+--------------------+--------------------+--------+--------------------+---------------------+
| NodeID             | Address            | State  | Max_Commit_Ts      | Update_Time         |
+--------------------+--------------------+--------+--------------------+---------------------+
| 192.168.10.33:8249 | 192.168.10.33:8249 | online | 436050665733619716 | 2022-09-17 15:54:42 |
+--------------------+--------------------+--------+--------------------+---------------------+
1 row in set (0.01 sec)