prometheus+grafana 监控单节点Mysql
需求：可视化更好点的Mysql监控
1.下载 mysql exporter 和mysql展示模版
// 下载地址：https://github.com/prometheus/mysqld_exporter/releases# ls
mysqld_exporter-0.11.0.linux-amd64.tar.gz
mysqld_exporter-0.11.0.linux-amd64.tar.gz# tar xvf mysqld_exporter-0.11.0.linux-amd64.tar.gz -C /usr/local/
promethes官网 https://prometheus.io/download/#mysqld_exporter
grafana官网 https://grafana.com/api/dashboards/9623/revisions/4/download
2.配置 mysqld_exporter
2.1 添加账号授权给 mysqld exporter
CREATE USER 'exporter'@'%' IDENTIFIED BY '123456' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'%';
2.2 配置 mysqld_exporter service 文件
[[email protected] mysqld_exporter]# cat /etc/systemd/system/mysqld_exporter.service
[Unit]
Description=mysqld_exporter
After=network.target
[Service]
Environment=DATA_SOURCE_NAME=exporter:[email protected]@(localhost:3306)/
#DATA_SOURCE_NAME 变量，包含数据库信息：用户名:密码@(mysql地址:mysql端口)/
Restart=on-failure
ExecStart=/opt/mysqld_exporter/mysqld_exporter
[Install]
WantedBy=multi-user.target
2.3 在Agent客户端启动mysqld_exporter
# systemctl daemon-reload
# systemctl start mysqld_exporter
# systemctl status mysqld_exporter
3.添加Mysqld_exporter到Promethus
[[email protected] prometheus-2.16.0]#
cat prometheus.yml 【详见附件promethus.yaml文件】
#配置Mysql重点字段
- job_name: 'mysql'
static_configs:
-targets: ['192.168.1.173:9104','192.168.1.162:9104','192.168.1.109:9104','192.168.1.29:9104','192.168.1.181:9104']
配置完毕后，重启promethus
4.查看Promethus 是否采集到数据
http://192.168.1.29:9104/metrics
5.Garafana导入mysql模版展示数据