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 文件

 

 

[root@nginx01 mysqld_exporter]# cat /etc/systemd/system/mysqld_exporter.service

[Unit]

Description=mysqld_exporter

After=network.target

 

[Service]

Environment=DATA_SOURCE_NAME=exporter:P@ssw0rd1@(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

[root@middle-ground-test-0001 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模版展示数据

   

 

#相关配置文件：https://gitee.com/meijinmeng/doc.git