快上网专注成都网站设计 成都网站制作 成都网站建设
成都网站建设公司服务热线:028-86922220

网站建设知识

十年网站开发经验 + 多家企业客户 + 靠谱的建站团队

量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决

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

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

创新互联专业提供多线BGP机房服务,为用户提供五星数据中心、电信、双线接入解决方案,用户可自行在线购买多线BGP机房服务,并享受7*24小时金牌售后服务。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;

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


网站名称:Zookeeper查看并修改Canal位点position信息-创新互联
当前路径:http://6mz.cn/article/gejji.html

其他资讯