Prometheus安装部署和监控MySQL,并在grafana上展示
1.下载mysqld_exporter
https://prometheus.io/download/#mysqld_exporter
2. 上传 rz
3.解压 tar -xvf mysqld_exporter-0.12.1.linux-amd64.tar.gz -C /home/devops
4.配置连接MySQL的信息
首先执行下面命令创建mysql_monitor用户并进行赋权:
1 | GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'mysql_monitor'@'%' identified by 'mysql_monitor'; GRANT SELECT ON*.* TO 'mysql_monitor'@'%'; |
创建并编辑配置文件
1 | vim /home/devops/mysqld_exporter-0.12.1.linux-amd64/.my.cnf |
1 | [client] |
5.运行mysqld_exporter
1 | nohup /home/devops/mysqld_exporter-0.12.1.linux-amd64/mysqld_exporter --config.my-cnf=/home/devops/mysqld_exporter-0.12.1.linux-amd64/my.cnf & |
已封装,直接执行 ./start.sh
6.配置prometheus.yml
1 | global: |
7.热重启Promethus:curl -XPOST http://localhost:9090/-/reload ;
直接执行 reload.sh
访问 http://172.16.102.102:9090/targets
访问:http://172.16.102.102:3000/d/FogKaQvMk/prometheus-2-0-stats?orgId=1
8.从Grafana导入mysql监控面板
MySQL_Overview.json(https://github.com/percona/grafana-dashboards/blob/master/dashboards/MySQL_Overview.json)