promethus监控mysql

短命女 2021-12-13 03:39 272阅读 0赞

# 一、mysqld\_exporter安装 #

下载页面

[https://github.com/prometheus/mysqld\_exporter/releases][https_github.com_prometheus_mysqld_exporter_releases]

下载最新版本

[https://github.com/prometheus/mysqld\_exporter/releases/download/v0.12.0/mysqld\_exporter-0.12.0.linux-amd64.tar.gz][https_github.com_prometheus_mysqld_exporter_releases_download_v0.12.0_mysqld_exporter-0.12.0.linux-amd64.tar.gz]

登录到mysql服务器，解压，并运行

# 解压
    tar zxvf mysqld_exporter-0.12.0.linux-amd64.tar.gz -C /usr/src/
    cd /usr/src/mysqld_exporter-0.12.0.linux-amd64
    
    # 创建目录，复制文件
    mkdir -p /etc/mysqld_exporter/bin/
    mkdir -p /etc/mysqld_exporter/conf
    cp mysqld_exporter /etc/mysqld_exporter/bin/

# 二、mysql授权 #

mysqld\_exporter需要连接Mysql，首先为它创建用户并赋予所需的权限：

grant replication client,process on *.* to exporter@'%' identified by '27dc703b';
    grant select on performance_schma.* to exporter@'%';
    flush PRIVILEGES;

# 三、运行mysqld\_exporter #

新建配置文件

vi /etc/mysqld_exporter/conf/my.cnf

内容如下：

[client]
    user=exporter
    password=27dc703b
    port=3306
    host=127.0.0.1

启动进程

/etc/mysqld_exporter/bin/mysqld_exporter --config.my-cnf="/etc/mysqld_exporter/conf/my.cnf" --web.listen-address=":9104"

观察是否有报错信息，如果没有报错信息，就可以封装service服务了

# 四、mysqld\_exporter封装service #

vim /lib/systemd/system/mysqld_exporter.service

内容如下：

[Unit]
    Description=mysqld monitor
    After=network.target
    
    [Service]
    ExecStart=/etc/mysqld_exporter/bin/mysqld_exporter --config.my-cnf="/etc/mysqld_exporter/conf/my.cnf" --web.listen-address=":9104"
    ExecStop=-/sbin/start-stop-daemon --quiet --stop --retry QUIT/5
    TimeoutStopSec=5
    KillMode=mixed
    
    [Install]
    WantedBy=multi-user.target

重新加载service配置文件，设置开机自启动，并启动服务

systemctl daemon-reload
    systemctl enable mysqld_exporter.service
    systemctl start mysqld_exporter.service

查看端口

root@ubuntu:~# netstat -anpt|grep mysqld_exporte
    tcp6       0      0 :::9104                 :::*                    LISTEN      3253/mysqld_exporte

使用网页访问metrics

http://192.168.1.24:9104/metrics

效果如下：

![1341090-20190713170935838-1101740457.png][]

如果数据输出正常，则表示成功。

# 五、promethus增加job #

vim /opt/prometheus/prometheus.yml

增加以下内容：

- job_name: mysqld_exporter
    static_configs:
      - targets:
        - 192.168.1.24:9104
        labels:
          instance: mysql-24

重启prometheus

root@ubuntu:/opt/prometheus# docker ps |grep prometheus
    0fa256f85750        prom/prometheus     "/bin/prometheus --c…"   About an hour ago   Up 29 seconds       0.0.0.0:9090->9090/tcp   wizardly_kirch
    
    root@ubuntu:/opt/prometheus# docker restart 0fa256f85750

访问页面：

[http://192.168.1.24:9090/targets][http_192.168.1.24_9090_targets]

确保mysqd\_exporter状态为UP

![1341090-20190713171455535-47062996.png][]

# 六、Grafana导入Dashboards #

下载json文件

[https://files.cnblogs.com/files/xiao987334176/MySQL%E7%9B%91%E6%8E%A7-1563009517081.zip][https_files.cnblogs.com_files_xiao987334176_MySQL_E7_9B_91_E6_8E_A7-1563009517081.zip]

解压之后，里面就是一个json文件

点击import

![1341090-20190713155336798-963091322.png][]

上传json文件，设置Name，选择prometheus，点击import

![1341090-20190713171636982-51741620.png][]

等待一段时间，数据多了之后，效果如下：

![1341090-20190713171713752-118412254.png][]

[https_github.com_prometheus_mysqld_exporter_releases]: https://github.com/prometheus/mysqld_exporter/releases
[https_github.com_prometheus_mysqld_exporter_releases_download_v0.12.0_mysqld_exporter-0.12.0.linux-amd64.tar.gz]: https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.0/mysqld_exporter-0.12.0.linux-amd64.tar.gz
[1341090-20190713170935838-1101740457.png]: /images/20211210/0c664ba7b92f49d0b3ddbd382a3fa9c9.png
[http_192.168.1.24_9090_targets]: http://192.168.1.24:9090/targets
[1341090-20190713171455535-47062996.png]: /images/20211210/4dbb0a74b53147329eac82d569cfd01d.png
[https_files.cnblogs.com_files_xiao987334176_MySQL_E7_9B_91_E6_8E_A7-1563009517081.zip]: https://files.cnblogs.com/files/xiao987334176/MySQL%E7%9B%91%E6%8E%A7-1563009517081.zip
[1341090-20190713155336798-963091322.png]: /images/20211210/10a0c2cffdb7408badbfbae86626c2eb.png
[1341090-20190713171636982-51741620.png]: /images/20211210/fcc13d3c65f240a9b7dc51c1af63f443.png
[1341090-20190713171713752-118412254.png]: /images/20211210/29fa75b53af348cbb222adbabcf2dc41.png