Zookeeper查看并修改Canal位点position信息-创新互联

• 1. ZK地址
• 2. 目录
• 3. 命令及结果
• 4. mysql查看binlog目录

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

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

• 进入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}}

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

你是否还在寻找稳定的海外服务器提供商？创新互联www.cdcxhl.cn海外机房具备T级流量清洗系统配攻击溯源，准确流量调度确保服务器高可用性，企业级服务器适合批量采购，新人活动首月15元起，快前往官网查看详情吧