【Maxwell】Maxwell连接MySQL时报错:com.zendesk.maxwell.MaxwellCompatibilityError: server_id is ‘0‘. Maxwell

今天在测试Maxwell时候,出现了一个错误,报错如下:

kuroneko@localhost:/opt/module/maxwell$ maxwell
Using kafka version: 1.0.0
18:17:54,387 INFO  Maxwell - Starting Maxwell. maxMemory: 3695181824 bufferMemoryUsage: 0.25
18:17:55,179 INFO  TaskManager - Stopping 0 tasks
18:17:55,179 ERROR TaskManager - cause: 
com.zendesk.maxwell.MaxwellCompatibilityError: server_id is '0'.  Maxwell will not function without a server_id being set.
	at com.zendesk.maxwell.MaxwellMysqlStatus.ensureServerIDIsSet(MaxwellMysqlStatus.java:50) ~[maxwell-1.29.0.jar:1.29.0]
	at com.zendesk.maxwell.MaxwellMysqlStatus.ensureReplicationMysqlState(MaxwellMysqlStatus.java:68) ~[maxwell-1.29.0.jar:1.29.0]
	at com.zendesk.maxwell.Maxwell.startInner(Maxwell.java:200) ~[maxwell-1.29.0.jar:1.29.0]
	at com.zendesk.maxwell.Maxwell.start(Maxwell.java:183) ~[maxwell-1.29.0.jar:1.29.0]
	at com.zendesk.maxwell.Maxwell.main(Maxwell.java:286) ~[maxwell-1.29.0.jar:1.29.0]
18:17:55,183 INFO  TaskManager - Stopped all tasks
com.zendesk.maxwell.MaxwellCompatibilityError: server_id is '0'.  Maxwell will not function without a server_id being set.
	at com.zendesk.maxwell.MaxwellMysqlStatus.ensureServerIDIsSet(MaxwellMysqlStatus.java:50)
	at com.zendesk.maxwell.MaxwellMysqlStatus.ensureReplicationMysqlState(MaxwellMysqlStatus.java:68)
	at com.zendesk.maxwell.Maxwell.startInner(Maxwell.java:200)
	at com.zendesk.maxwell.Maxwell.start(Maxwell.java:183)
	at com.zendesk.maxwell.Maxwell.main(Maxwell.java:286)

错误原因:

server_id未设置,MySQL的binlog服务未开启:

解决方法:

编辑/etc/my.cnf,在[mysqld]下加入以下内容:

server_id=1
log-bin=mysql-bin
binlog_format=row

问题成功解决。

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值