mysql-data-sp-check

README

mysql数据存储过程迁移状态告警

• 配置文件
  • mysql-data-sp-check.ini
• 触发脚本
  • mysql-data-sp-check.sh
• telegraf 配置项

; /etc/telegraf/telegraf.conf

[[inputs.exec]]
  commands = ["/etc/telegraf/mysql-data-sp-check.sh"]
  timeout = "5s"
  name_suffix = "_mysql_data_sp"
  data_format = "json"
  data_type = "integer"

• mysql 用户权限

SET GLOBAL validate_password_special_char_count = 0;
GRANT SELECT ON `dbname`.* TO 'status'@'127.0.0.1' IDENTIFIED BY 'passWord';

show grants for 'status'@'127.0.0.1';

• 执行结果

[centos@hostname telegraf]$ ./mysql-data-sp-check
{
    "errs_count": 0,
    "errs": []
}

[centos@hostname ~]$ telegraf -input-filter exec -test
> exec_mysql_data_sp,host=hostname errs_count=0 0000000000000000000

下载程序

• linux 64位
• linux 32位