open-falcon / mymon

MySQL Monitor Script
Apache License 2.0
267 stars 145 forks source link

采集到的信息怎么存到mysql里去 #7

Open bxhbpdxhzGithub opened 7 years ago

bxhbpdxhzGithub commented 7 years ago

麻烦帮我看一下日志

[root@rj mymon]# cat mymon.log
{"level":"info","msg":"MySQL Monitor for falcon","time":"2017-04-14T14:27:40+08:00"} {"level":"debug","msg":"Send to http://127.0.0.1:1988/v1/push, size: 1","time":"2017-04-14T14:27:40+08:00"} {"level":"debug","msg":"MetaData Metric:mysql_alive_local Endpoint:open-faIcon_mysql_3308 Value:\u003cnil\u003e CounterType:GAUGE Tags:port=3308 Timestamp:1492151260 Step:60","time":"2017-04-14T14:27:40+08:00"} level":"info","msg":"Alive data response 172.16.211.21:3308: success","time":"2017-04-14T14:27:40+08:00"} {"level":"error","msg":"Received #1045 error from MySQL server: \"Access denied for user 'root'@'rj.test.openfaIcon' (using password: YES)\"","time":"2017-04-14T14:27:40+08:00"}

最后一行报错的信息,'root'@'rj.test.openfaIcon'是在哪里配置的

itxx00 commented 7 years ago

etc/mon.cfg

bxhbpdxhzGithub commented 7 years ago

这个是我的etc/mymon.cfg

[default] log_file=mymon.log

log_level=5

falcon_client=http://127.0.0.1:1988/v1/push

endpoint=open-faIcon_mysql_3308

[mysql] user=root password=123456 host=172.16.211.21 port=3308

这里的mysql配置的是采集的目标mysql实例 还是采集信息存储的mysql实例,我是想采集本机的3308实例的信息,存到本机的3306实例里去,这里这样配置有问题吗

ahyw724 commented 7 years ago

每个指标有对应的说明吗?还有,指标有分类吗?比如:可用性指标,性能指标,关键指标,以及关键指标的监控建议阀值等,可能提供参考一下,谢谢!