Zookeeper查看并修改Canal位点position信息

1. ZK地址

hd-master-100
hd-master-101
hd-master-102

2. 目录

cd /opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/lib/zookeeper/bin

3. 命令及结果

• 进入zk命令行

sh ./zkCli.sh

• 查看zk目录数据

ls /otter/canal/destinations

• 获取zk数据

get /otter/canal/destinations/cps_yangguang_slave/1001/cursor

• 结果:

	{"@type":"com.alibaba.otter.canal.protocol.position.LogPosition","identity":{"slaveId":-1,"sourceAddress":{"address":"192.168.31.74","port":3306}},"postion":{"gtid":"","included":false,"journalName":"mysql-bin.005380","position":229466749,"serverId":3379404740,"timestamp":1619606927000}}

• 修改canal position

set /otter/canal/destinations/cps_yangguang_slave/1001/cursor {"@type":"com.alibaba.otter.canal.protocol.position.LogPosition","identity":{"slaveId":-1,"sourceAddress":{"address":"192.168.31.74","port":3306}},"postion":{"gtid":"","included":false,"journalName":"mysql-bin.005380","position":229466749,"serverId":3379404740,"timestamp":1619606927000}}

4. mysql查看binlog目录

show binlog events in 'mysql-binilog-xxxx' from 0000001 limit 10;