【TIDB】开启tidbv5.1.1 的binlog

最新推荐文章于 2024-08-17 18:17:39 发布
最新推荐文章于 2024-08-17 18:17:39 发布
阅读量88 收藏
点赞数 1
分类专栏： 国产数据库-TIDB 文章标签： tidb
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43346403/article/details/141284393
版权

1.检查tidb 是否开启binlog; 

mysql>  show global variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | OFF   |
+---------------+-------+
1 row in set (0.02 sec)

--off表示没有开启binlog; 
mysql> show pump status;
Empty set (0.01 sec)

mysql> show drainer status;
Empty set (0.04 sec)

2.开启binlog 

(1)开启binlog 参数化 
[tidb@mysql1 soft]$ cat scale_out_binlog.yaml 
pump_servers:
- host: 192.168.1.14    # 指定要在那台服务器部署
  ssh_port: 22
  port: 8250    # 启动端口
  deploy_dir: /tidb/tidb-deploy/pump-8250 
  data_dir: /tidb/tidb-data/pump-8250
  log_dir: /tidb/tidb-deploy/pump-8250/logs
  config:
    gc: 180 # 日志保留天数
    log-file: /tidb/tidb-deploy/pump-8250/logs
    pd-urls: http://192.168.1.11:2379,http://192.168.1.12:2379,http://192.168.1.13:2379 # 连接pd集群

drainer_servers:
- host: 192.168.1.14    # 指定要在那台服务器部署
  ssh_port: 22
  port: 8249
  deploy_dir: /tidb/tidb-deploy/drainer-8249
  data_dir: /tidb/tidb-data/drainer-8249
  log_dir: /tidb/tidb-deploy/drainer-8249/logs
  config:
    pd-urls: http://192.168.1.11:2379,http://192.168.1.12:2379,http://192.168.1.13:2379
    syncer.db-type: file    # 同步类型
    syncer.to.host: 192.168.1.11        # tidb连接IP
    syncer.to.password: "rootroot"                      # 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"


--将pump_servers,drainer_servers 部署在一个空机器上:14;
--从1.11连接TIDB集群。
tiup cluster scale-out tidbcluster scale_out_binlog.yaml --user root -p'rootroot'
[tidb@mysql1 soft]$ tiup cluster scale-out tidbcluster scale_out_binlog.yaml --user root -p
Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.5.3/tiup-cluster scale-out tidbcluster scale_out_binlog.yaml --user root -p
Please confirm your topology:
Cluster type:    tidb
Cluster name:    tidbcluster
Cluster version: v5.1.1
Role     Host          Ports  OS/Arch       Directories
----     ----          -----  -------       -----------
pump     192.168.1.14  8250   linux/x86_64  /tidb/tidb-deploy/pump-8250,/tidb/tidb-data/pump-8250
drainer  192.168.1.14  8249   linux/x86_64  /tidb/tidb-deploy/drainer-8249,/tidb/tidb-data/drainer-8249
Attention:
    1. If the topology is not what you expected, check your yaml file.
    2. Please confirm there is no port/directory conflicts in same host.
Do you want to continue? [y/N]: (default=N) y
Input SSH password: 
+ [ Serial ] - SSHKeySet: privateKey=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/ssh/id_rsa, publicKey=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/ssh/id_rsa.pub

  - Download drainer:v5.1.1 (linux/amd64) ... Done
+ [ Serial ] - RootSSH: user=root, host=192.168.1.14, port=22
+ [ Serial ] - EnvInit: user=tidb, host=192.168.1.14
+ [ Serial ] - Mkdir: host=192.168.1.14, directories='/tidb/tidb-deploy','/tidb/tidb-data'
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.12
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.13
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.12
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.13
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.12
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.13
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11

+ [ Serial ] - UserSSH: user=tidb, host=192.168.1.14
+ [ Serial ] - Mkdir: host=192.168.1.14, directories='/tidb/tidb-deploy/pump-8250','/tidb/tidb-deploy/pump-8250/bin','/tidb/tidb-deploy/pump-8250/conf','/tidb/tidb-deploy/pump-8250/scripts'
+ [ Serial ] - UserSSH: user=tidb, host=192.168.1.14
+ [ Serial ] - Mkdir: host=192.168.1.14, directories='/tidb/tidb-deploy/drainer-8249','/tidb/tidb-deploy/drainer-8249/bin','/tidb/tidb-deploy/drainer-8249/conf','/tidb/tidb-deploy/drainer-8249/scripts'
  - Copy blackbox_exporter -> 192.168.1.14 ... ⠏ Mkdir: host=192.168.1.14, directories='/tidb/tidb-deploy/monitor-9100','/tidb/tidb-data/monitor-9100','/tidb/tidb-deploy/monitor-9100/log','/t...
  - Copy blackbox_exporter -> 192.168.1.14 ... ⠼ Mkdir: host=192.168.1.14, directories='/tidb/tidb-deploy/monitor-9100','/tidb/tidb-data/monitor-9100','/tidb/tidb-deploy/monitor-9100/log','/t...
  - Copy blackbox_exporter -> 192.168.1.14 ... ⠇ Mkdir: host=192.168.1.14, directories='/tidb/tidb-deploy/monitor-9100','/tidb/tidb-data/monitor-9100','/tidb/tidb-deploy/monitor-9100/log','/t...
  - Copy blackbox_exporter -> 192.168.1.14 ... ⠙ Mkdir: host=192.168.1.14, directories='/tidb/tidb-deploy/monitor-9100','/tidb/tidb-data/monitor-9100','/tidb/tidb-deploy/monitor-9100/log','/t...
  - Copy blackbox_exporter -> 192.168.1.14 ... ⠋ Mkdir: host=192.168.1.14, directories='/tidb/tidb-deploy/monitor-9100','/tidb/tidb-data/monitor-9100','/tidb/tidb-deploy/monitor-9100/log','/t...
  - Copy blackbox_exporter -> 192.168.1.14 ... ⠙ Mkdir: host=192.168.1.14, directories='/tidb/tidb-deploy/monitor-9100','/tidb/tidb-data/monitor-9100','/tidb/tidb-deploy/monitor-9100/log','/t...
  - Copy blackbox_exporter -> 192.168.1.14 ... ⠴ MonitoredConfig: cluster=tidbcluster, user=tidb, node_exporter_port=9100, blackbox_exporter_port=9115, deploy_dir=/tidb/tidb-deploy/monitor-91...
+ [ Serial ] - ScaleConfig: cluster=tidbcluster, user=tidb, host=192.168.1.14, service=pump-8250.service, deploy_dir=/tidb/tidb-deploy/pump-8250, data_dir=[/tidb/tidb-data/pump-8250], log_dir=/t
  - Copy blackbox_exporter -> 192.168.1.14 ... ⠇ MonitoredConfig: cluster=tidbcluster, user=tidb, node_exporter_port=9100, blackbox_exporter_port=9115, deploy_dir=/tidb/tidb-deploy/monitor-91...
+ [ Serial ] - ScaleConfig: cluster=tidbcluster, user=tidb, host=192.168.1.14, service=drainer-8249.service, deploy_dir=/tidb/tidb-deploy/drainer-8249, data_dir=[/tidb/tidb-data/drainer-8249], l
  - Copy node_exporter -> 192.168.1.14 ... Done
+ Check status
Enabling component pump
	Enabling instance 192.168.1.14:8250
	Enable instance 192.168.1.14:8250 success
Enabling component drainer
	Enabling instance 192.168.1.14:8249
	Enable instance 192.168.1.14:8249 success
Enabling component node_exporter
	Enabling instance 192.168.1.14
	Enable 192.168.1.14 success
Enabling component blackbox_exporter
	Enabling instance 192.168.1.14
	Enable 192.168.1.14 success
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.14
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.14
+ [ Serial ] - Save meta
+ [ Serial ] - StartCluster
Starting component pump
	Starting instance 192.168.1.14:8250
	Start instance 192.168.1.14:8250 success
Starting component drainer
	Starting instance 192.168.1.14:8249
	Start instance 192.168.1.14:8249 success
Starting component node_exporter
	Starting instance 192.168.1.14
	Start 192.168.1.14 success
Starting component blackbox_exporter
	Starting instance 192.168.1.14
	Start 192.168.1.14 success
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.11, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/tispark-worker-7078.service, deploy_dir=/tidb/tidb-deploy/tispark-worker-7078, data_dir=[], log_dir=/tidb/tidb-deploy/tispark-worker-7078/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.11, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/pd-2379.service, deploy_dir=/tidb/tidb-deploy/pd-2379, data_dir=[/tidb/tidb-data/pd-2379], log_dir=/tidb/tidb-deploy/pd-2379/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.12, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/pd-2379.service, deploy_dir=/tidb/tidb-deploy/pd-2379, data_dir=[/tidb/tidb-data/pd-2379], log_dir=/tidb/tidb-deploy/pd-2379/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.13, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/pd-2379.service, deploy_dir=/tidb/tidb-deploy/pd-2379, data_dir=[/tidb/tidb-data/pd-2379], log_dir=/tidb/tidb-deploy/pd-2379/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.11, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/tikv-20160.service, deploy_dir=/tidb/tidb-deploy/tikv-20160, data_dir=[/tidb/tidb-data/tikv-20160], log_dir=/tidb/tidb-deploy/tikv-20160/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.12, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/tikv-20161.service, deploy_dir=/tidb/tidb-deploy/tikv-20161, data_dir=[/tidb/tidb-data/tikv-20161], log_dir=/tidb/tidb-deploy/tikv-20161/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.13, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/tikv-20160.service, deploy_dir=/tidb/tidb-deploy/tikv-20160, data_dir=[/tidb/tidb-data/tikv-20160], log_dir=/tidb/tidb-deploy/tikv-20160/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.14, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/pump-8250.service, deploy_dir=/tidb/tidb-deploy/pump-8250, data_dir=[/tidb/tidb-data/pump-8250], log_dir=/tidb/tidb-deploy/pump-8250/logs, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.11, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/tidb-4000.service, deploy_dir=/tidb/tidb-deploy/tidb-4000, data_dir=[], log_dir=/tidb/tidb-deploy/tidb-4000/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.12, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/tidb-4001.service, deploy_dir=/tidb/tidb-deploy/tidb-4001, data_dir=[], log_dir=/tidb/tidb-deploy/tidb-4001/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.13, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/tidb-4000.service, deploy_dir=/tidb/tidb-deploy/tidb-4000, data_dir=[], log_dir=/tidb/tidb-deploy/tidb-4000/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.11, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/tiflash-9000.service, deploy_dir=/tidb/tidb-deploy/tiflash-9000, data_dir=[/tidb/tidb-data/tiflash-9000], log_dir=/tidb/tidb-deploy/tiflash-9000/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.14, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/drainer-8249.service, deploy_dir=/tidb/tidb-deploy/drainer-8249, data_dir=[/tidb/tidb-data/drainer-8249], log_dir=/tidb/tidb-deploy/drainer-8249/logs, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.11, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/cdc-8300.service, deploy_dir=/tidb/tidb-deploy/cdc-8300, data_dir=[/tidb/tidb-data/cdc-8300], log_dir=/tidb/tidb-deploy/cdc-8300/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.11, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/prometheus-9090.service, deploy_dir=/tidb/tidb-deploy/prometheus-9090, data_dir=[/tidb/tidb-data/prometheus-9090], log_dir=/tidb/tidb-deploy/prometheus-9090/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.11, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/grafana-3000.service, deploy_dir=/tidb/tidb-deploy/grafana-3000, data_dir=[], log_dir=/tidb/tidb-deploy/grafana-3000/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.11, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/alertmanager-9093.service, deploy_dir=/tidb/tidb-deploy/alertmanager-9093, data_dir=[/tidb/tidb-data/alertmanager-9093], log_dir=/tidb/tidb-deploy/alertmanager-9093/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - InitConfig: cluster=tidbcluster, user=tidb, host=192.168.1.11, path=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache/tispark-master-7077.service, deploy_dir=/tidb/tidb-deploy/tispark-master-7077, data_dir=[], log_dir=/tidb/tidb-deploy/tispark-master-7077/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/config-cache
+ [ Serial ] - SystemCtl: host=192.168.1.11 action=reload prometheus-9090.service
+ [ Serial ] - UpdateTopology: cluster=tidbcluster
Scaled cluster `tidbcluster` out successfully

(2)编辑配置文件 
tiup cluster edit-config tidbcluster 

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

(3)重启
tiup cluster reload tidbcluster -R tidb
--如下两个命令貌似不需要。重载集群后binlog已经开启。
--tiup cluster reload tidbcluster -R pump
--tiup cluster reload tidbcluster -R drainer

[tidb@mysql1 soft]$ tiup cluster reload tidbcluster -R tidb
Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.5.3/tiup-cluster reload tidbcluster -R tidb
Will reload the cluster tidbcluster with restart policy is true, nodes: , roles: tidb.
Do you want to continue? [y/N]:(default=N) y
+ [ Serial ] - SSHKeySet: privateKey=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/ssh/id_rsa, publicKey=/home/tidb/.tiup/storage/cluster/clusters/tidbcluster/ssh/id_rsa.pub
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.12
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.13
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.12
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.13
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.14
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.12
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.13
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.14
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [Parallel] - UserSSH: user=tidb, host=192.168.1.11
+ [ Serial ] - UpdateTopology: cluster=tidbcluster
+ Refresh instance configs
  - Regenerate config pd -> 192.168.1.11:2379 ... Done
  - Regenerate config pd -> 192.168.1.12:2379 ... Done
  - Regenerate config pd -> 192.168.1.13:2379 ... Done
  - Regenerate config tikv -> 192.168.1.11:20160 ... Done
  - Regenerate config tikv -> 192.168.1.12:20161 ... Done
  - Regenerate config tikv -> 192.168.1.13:20160 ... Done
  - Regenerate config pump -> 192.168.1.14:8250 ... Done
  - Regenerate config tidb -> 192.168.1.11:4000 ... Done
  - Regenerate config tidb -> 192.168.1.12:4001 ... Done
  - Regenerate config tidb -> 192.168.1.13:4000 ... Done
  - Regenerate config tiflash -> 192.168.1.11:9000 ... Done
  - Regenerate config drainer -> 192.168.1.14:8249 ... Done
  - Regenerate config cdc -> 192.168.1.11:8300 ... Done
  - Regenerate config prometheus -> 192.168.1.11:9090 ... Done
  - Regenerate config grafana -> 192.168.1.11:3000 ... Done
  - Regenerate config alertmanager -> 192.168.1.11:9093 ... Done
  - Regenerate config tispark -> 192.168.1.11:7077 ... Done
  - Regenerate config tispark -> 192.168.1.11:7078 ... Done
+ Refresh monitor configs
  - Refresh config node_exporter -> 192.168.1.11 ... Done
  - Refresh config node_exporter -> 192.168.1.12 ... Done
  - Refresh config node_exporter -> 192.168.1.13 ... Done
  - Refresh config node_exporter -> 192.168.1.14 ... Done
  - Refresh config blackbox_exporter -> 192.168.1.13 ... Done
  - Refresh config blackbox_exporter -> 192.168.1.14 ... Done
  - Refresh config blackbox_exporter -> 192.168.1.11 ... Done
  - Refresh config blackbox_exporter -> 192.168.1.12 ... Done
+ [ Serial ] - UpgradeCluster
Upgrading component tidb
	Restarting instance 192.168.1.11:4000
	Restart instance 192.168.1.11:4000 success
	Restarting instance 192.168.1.12:4001
	Restart instance 192.168.1.12:4001 success
	Restarting instance 192.168.1.13:4000
	Restart instance 192.168.1.13:4000 success
Reloaded cluster `tidbcluster` successfully

--检查pumper,trainer服务。
[tidb@mysql4 tidb-data]$ ps -ef |grep tidb
root      85256   2249  0 17:37 pts/0    00:00:00 su - tidb
tidb      85257  85256  0 17:37 pts/0    00:00:00 -bash
tidb      89804      1  0 17:42 ?        00:00:01 bin/pump --node-id=192.168.1.14:8250 --addr=0.0.0.0:8250 --advertise-addr=192.168.1.14:8250 --pd-urls=http://192.168.1.11:2379,http://192.168.1.12:2379,http://192.168.1.13:2379 --data-dir=/tidb/tidb-data/pump-8250 --log-file=/tidb/tidb-deploy/pump-8250/logs/pump.log --config=conf/pump.toml
tidb      89897      1  0 17:42 ?        00:00:00 bin/drainer --node-id=192.168.1.14:8249 --addr=192.168.1.14:8249 --pd-urls=http://192.168.1.11:2379,http://192.168.1.12:2379,http://192.168.1.13:2379 --data-dir=/tidb/tidb-data/drainer-8249 --log-file=/tidb/tidb-deploy/drainer-8249/logs/drainer.log --config=conf/drainer.toml --initial-commit-ts=0
tidb      89990      1  0 17:42 ?        00:00:01 bin/node_exporter/node_exporter --web.listen-address=:9100 --collector.tcpstat --collector.systemd --collector.mountstats --collector.meminfo_numa --collector.interrupts --collector.buddyinfo --collector.vmstat.fields=^.* --log.level=info
tidb      89991  89990  0 17:42 ?        00:00:00 /bin/bash /tidb/tidb-deploy/monitor-9100/scripts/run_node_exporter.sh
tidb      89994  89991  0 17:42 ?        00:00:00 tee -i -a /tidb/tidb-deploy/monitor-9100/log/node_exporter.log
tidb      90084      1  0 17:42 ?        00:00:00 bin/blackbox_exporter/blackbox_exporter --web.listen-address=:9115 --log.level=info --config.file=conf/blackbox.yml
tidb      90085  90084  0 17:42 ?        00:00:00 /bin/bash /tidb/tidb-deploy/monitor-9100/scripts/run_blackbox_exporter.sh
tidb      90088  90085  0 17:42 ?        00:00:00 tee -i -a /tidb/tidb-deploy/monitor-9100/log/blackbox_exporter.log

--当前已经开启binlog;
mysql>  show global variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |
+---------------+-------+
1 row in set (0.01 sec)

--检查已经生成的binlog; 
[tidb@mysql4 drainer-8249]$ ll
total 4
-rw------- 1 tidb tidb  0 Aug 17 17:42 binlog-0000000000000000-20240817174214
-rw-r--r-- 1 tidb tidb 68 Aug 17 17:48 savepoint
[tidb@mysql4 drainer-8249]$ pwd
/tidb/tidb-data/drainer-8249

 

3.写入数据测试

mysql> select * from my_test1; 
+------+------+
| id   | name |
+------+------+
|    1 | xs1  |
|    2 | xsq1 |
+------+------+
2 rows in set (0.00 sec)

mysql> insert into my_test1 values(3,'xsq3'),(4,'xsq4');
Query OK, 2 rows affected (0.02 sec)
Records: 2  Duplicates: 0  Warnings: 0

--观察文件系统。
[tidb@mysql4 drainer-8249]$ ll
total 4
-rw------- 1 tidb tidb  0 Aug 17 17:42 binlog-0000000000000000-20240817174214
-rw-r--r-- 1 tidb tidb 68 Aug 17 17:52 savepoint
[tidb@mysql4 drainer-8249]$ ll
total 8
-rw------- 1 tidb tidb 163 Aug 17 17:52 binlog-0000000000000000-20240817174214
-rw-r--r-- 1 tidb tidb  69 Aug 17 17:52 savepoint
--已经写入成功。
[tidb@mysql4 drainer-8249]$ strings binlog-0000000000000000-20240817174214 
test
my_test1
int"
name
varchar"
xsq3
test
my_test1
int"
name
varchar"
xsq4

4.总结 

开启binlog 涉及到集群的重启，所以需要在非业务时间进行。

戒掉贪嗔痴(薛双奇)
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
TiDB-Binlog架构演进与实现原理
02-24
TiDB-Binlog组件用于收集TiDB的binlog，并提供实时备份和同步功能。该组件在功能上类似于MySQL的主从复制，MySQL的主从复制依赖于记录的binlog文件，TiDB-Binlog组件也是如此，主要的不同点是TiDB是分布式的，因此...
tidb技术分享.pptx
03-23
tidb的简介、安装部署、Sql操作等
【TIDB】关闭tidbv5.1.1 的 binlog 功能
最新发布
weixin_43346403的博客
08-17 29
4.下线 drainer,pump 服务。2.编辑配置关闭 binlog。1.检查现有的binlog。3.检查binlog;
TiDB Binlog使用实践
TiDB 社区干货传送门
03-17 897
作者：吴永健 原文来源： https://tidb.net/blog/3a28b2c7 ...
TiDB实战篇-TiDB Binlog实战
S1124654的博客
04-22 461
TiDB实战篇-TiDB Binlog实战
TIDB - 使用 TiDB Binlog 将日志同步至下游 Kafka 中
小毕超博客
12-05 6883
一、TiDB Binlog 在上篇文章中我们介绍了使用TiDB Binlog将数据同步至下游的Mysql 中，本篇我们学习下使用TiDB Binlog工具将数据同步至Kafka中自定义业务逻辑，比如可以做TIDB和ES、MongoDB 或 Redis的数据同步，这功能就和Canal解析Mysql的binlog功能相差不大。如果还不了解TiDB Binlog工具的也可以参考我的上篇博客： https://blog.csdn.net/qq_43692950/article/details/121597230
【TIDB】TIUP 离线部署TIDB-v5.1.1；
weixin_43346403的博客
08-16 130
3.可以通过 playground 命令创建一个简单的集群。4.销毁测试集群，创建真正的集群。
TiDB-Binlog的使用及缩容
汪灵骅的博客
04-11 522
TiDB-Binlog的使用及缩容
TIDB-BINLOG初步搭建
line_on_database的博客
03-25 1702
一、简介 1.TiDB Binlog 是一个用于收集 TiDB 的 binlog，并提供准实时备份和同步功能的商业工具 1.1 应用场景 数据同步：同步 TiDB 集群数据到其他数据库 实时备份和恢复：：备份 TiDB 集群数据，同时可以用于 TiDB 集群故障时恢复 2. pump pump用于实时记录 TiDB 产生的 Binlog，并将 Binlog 按照事务的提交时间进行排序，再提供给 Drainer 进行消费。 3.drainer drainer从各个 Pump 中收集 Binlo
TIDB - 使用 TiDB Binlog 实现 TIDB 到 Mysql 数据复制
小毕超博客
11-28 5037
一、TiDB Binlog简介 TiDB Binlog 是一个用于收集 TiDB 的 binlog，并提供准实时备份和同步功能的工具，可以理解为Mysql 的 Binlog 主从服务模式，并且TiDB Binlog还支持将数据发送到Kafka中，这又类似与Canal中间件。目前TIDB Binlog集群主要分为 Pump 和 Drainer 两个组件，以及 binlogctl 工具。 TiDB Binlog 整体架构 注意： TiDB Binlog 与 TiDB v5.0 版本开始引入的一些特性不兼容，无
TIDB扩容--binlog
qq_43297415的博客
06-01 263
【代码】TIDB扩容--binlog。
tidb中文官方文档
10-03
TiDB 中文官方文档 TiDB 是一个开源的关系型数据库管理系统，由 PingCAP 公司开发，旨在提供高性能、可扩展、易于维护的数据库解决方案。 TiDB 的五大核心特性 1. Column-store storage: TiDB 采用列式存储...
TiDB PCTP专家认证学习总结
02-08
最全面的TIDB PCTP专家认证总结，本人目前 PCTP认证已过。 物有所值。
【TiDB】10-对 TiDB 进行 TPC-C 测试
宣晨光
08-15 809
TPC-C 使用 tpmC 值 (Transactions per Minute) 来衡量系统最大有效吞吐量 (MQTh, Max Qualified Throughput)，其中 Transactions 以 NewOrder Transaction 为准，即最终衡量单位为每分钟处理的新订单数。
【TiDB】09-修改tidb客户端访问密码
宣晨光
08-14 810
以 tiup cluster 命令方式启动，否则会出现启动失败。启动完后，保持窗口不要关闭，开启新的窗口进行后续操作。通过查找进程的方式，kill的对应程序，然后重启。1）将1中的tidb.toml 配置添加的内容移除。2）如果出现异常退出后，再次执行出现如下错误。2）停止3中的run_tidb.sh脚本。进入tidb-server默认部署位置。可以使用命令行的方式访问数据库。或者借助Navicat工具访问。注意需要切换到mysql 实例。3）重启tidb-server。最后检查服务是否运行正常。
新型智慧城市项目技术方案（2283页）.pdf
08-16
新型智慧城市项目技术方案（2283页）
openssh windows安装程序
08-16
openssh windows安装程序
java-团员管理系统（源码+数据库+论文）.rar
08-16
共青团员做为我们先进积极分子的培养对象，是未来党人和民的重点培养对象。但随着知识和认识的不断提高，越来越多的青少年选择积极入团，由此而引发的团员管理也成为当下需要解决的问题。日益成熟的互联网技术大大推动了共青团信息化建设的发展，此次毕业设计就是要通过技术的手段来实现团员的信息化管理。 那么业务实现就是为了实现共青团团员的管理系统，那么技术上我们采用的手段还是以目前主流的Java技术为主，那么采用的框架是SSM框架，这样一来更加方便的进行一个团员信息的管理。数据库方面我们使用的是MYSQL数据库，可以有效的快速上手，容易我们开发。 关键词：SSM框架；信息技术；团员管理；
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值