Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

如果master一直没有数据写入,发现put、get、ack delay会持续增长 #5318

Open
lanicc opened this issue Nov 12, 2024 · 1 comment

Comments

@lanicc
Copy link
Contributor

lanicc commented Nov 12, 2024

Question

这样的话,在grafana中怎么配置告警呢

@290433788
Copy link

你可以配置。 如下信息,这个信息是canal和mysql的心跳,注意sql语句改成下面类似的语句,这样每次心跳就会有数据变更。然后就可以解决你的问题了。当然这个配置可以单独再instant中配置,但是server的canal.instance.detecting.enable = true需要设置为开启。

detecing config

canal.instance.detecting.enable = true
canal.instance.detecting.sql = insert into xx.table(id,update_time) values(1,now()) on duplicate key update update_time=now()
#canal.instance.detecting.sql = select 1
canal.instance.detecting.interval.time = 3
canal.instance.detecting.retry.threshold = 3
canal.instance.detecting.heartbeatHaEnable = false

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants