一、下载mysql exporter 二进制文件压缩包

1、在节点上执行命令下载 

wget "https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gz" 

 2、解压压缩包

[root@master mysql]# ls
mysqld_exporter-0.12.1.linux-amd64.tar.gz
[root@master mysql]# tar -xzf mysqld_exporter-0.12.1.linux-amd64.tar.gz
[root@master mysql]# ls
mysqld_exporter-0.12.1.linux-amd64  mysqld_exporter-0.12.1.linux-amd64.tar.gz

二、将mysqld_exporter-0.12.1.linux-amd64 目录下的 mysqld_exporter 二进制文件复制到 /usr/local/bin路径下

[root@master mysql]# cd mysqld_exporter-0.12.1.linux-amd64/
[root@master mysqld_exporter-0.12.1.linux-amd64]# ls
LICENSE  mysqld_exporter  NOTICE
[root@master mysqld_exporter-0.12.1.linux-amd64]# cp mysqld_exporter /usr/local/bin/
[root@master mysqld_exporter-0.12.1.linux-amd64]# ls -l /usr/local/bin/mysqld_exporter
-rwxr-xr-x. 1 root root 14813452 Oct 22 15:05 /usr/local/bin/mysqld_exporter

三、配置mysqld-exporter的MySQL认证用戶账户密码

执行MySQL Command 新建用戶并赋权（command中的相关参数请根据实际情況修改）
注意：建议为用户设置最大连接限制，以避免在服务器重负载下监视碎片导致服务器过载，並非所有MySQL / MariaDB版本都支持此功能。例如，MariaDB 10.1（由Ubuntu 18.04提供）不支持此功能。

mysql -uroot -P3310 -h10.82.42.197 -p


CREATE USER 'exporter'@'127.0.0.1' IDENTIFIED BY 'dangerous.pwd' WITH MAX_USER_CONNECTIONS 5;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'127.0.0.1';

四、创建systemd service文件 

根据实际情況修改其中的Environment配置值
如果上一步骤沒有修改创建用户命令中的认证参数
则下文可不做变更
直接复制下文全部文字命令並在节点上执行即可

cat <<EOF > /etc/systemd/system/mysqld_exporter.service
[Unit]
Description=mysqld_exporter
After=network.target 

[Service]
Environment=DATA_SOURCE_NAME=exporter:dangerous.pwd@(127.0.0.1:3306)/
User=nobody
Group=nobody
Type=simple
ExecStart=/usr/local/bin/mysqld_exporter\\
          --web.listen-address=:9104

[Install]
WantedBy=multi-user.target
EOF

 

五、重载系统systemd配置 

执行命令：systemctl daemon-reload

六、启动服务并且设置服务自启

[root@master mysqld_exporter]# systemctl enable --now mysqld_exporter
Created symlink from /etc/systemd/system/multi-user.target.wants/mysqld_exporter.service to /etc/systemd/system/mysqld_exporter.service.

 

七、查看服务运行状态

执行命令
能夠得到类似下文的回显结果
主要看Active属性值
以及日志中提示：systemctl status mysqld_exporteractive(running)Listening on :9104

mysqld_exporter.service - mysqld_exporter
   Loaded: loaded (/etc/systemd/system/mysqld_exporter.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2020-10-22 16:47:41 CST; 1min 27s ago
 Main PID: 31810 (mysqld_exporter)
   CGroup: /system.slice/mysqld_exporter.service
           └─31810 /usr/local/bin/mysqld_exporter --web.listen-address=:9104

Oct 22 16:47:41 master mysqld_exporter[31810]: time="2020-10-22T16:47:41+08:00" level=info msg="Starting mysqld_exporter (version=0.12.1, branch=HEAD, revision=48667bf7c3b438b5e93b259f3d17b70...porter.go:257"
Oct 22 16:47:41 master mysqld_exporter[31810]: time="2020-10-22T16:47:41+08:00" level=info msg="Build context (go=go1.12.7, user=root@0b3e56a7bc0a, date=20190729-12:35:58)" source="mysqld_exporter.go:258"
Oct 22 16:47:41 master mysqld_exporter[31810]: time="2020-10-22T16:47:41+08:00" level=info msg="Enabled scrapers:" source="mysqld_exporter.go:269"
Oct 22 16:47:41 master mysqld_exporter[31810]: time="2020-10-22T16:47:41+08:00" level=info msg=" --collect.global_status" source="mysqld_exporter.go:273"
Oct 22 16:47:41 master mysqld_exporter[31810]: time="2020-10-22T16:47:41+08:00" level=info msg=" --collect.global_variables" source="mysqld_exporter.go:273"
Oct 22 16:47:41 master mysqld_exporter[31810]: time="2020-10-22T16:47:41+08:00" level=info msg=" --collect.slave_status" source="mysqld_exporter.go:273"
Oct 22 16:47:41 master mysqld_exporter[31810]: time="2020-10-22T16:47:41+08:00" level=info msg=" --collect.info_schema.innodb_cmp" source="mysqld_exporter.go:273"
Oct 22 16:47:41 master mysqld_exporter[31810]: time="2020-10-22T16:47:41+08:00" level=info msg=" --collect.info_schema.innodb_cmpmem" source="mysqld_exporter.go:273"
Oct 22 16:47:41 master mysqld_exporter[31810]: time="2020-10-22T16:47:41+08:00" level=info msg=" --collect.info_schema.query_response_time" source="mysqld_exporter.go:273"
Oct 22 16:47:41 master mysqld_exporter[31810]: time="2020-10-22T16:47:41+08:00" level=info msg="Listening on :9104" source="mysqld_exporter.go:283"

 

八、测试接口

在节点上使用命令访问接口
能夠得到类似下文結果（mysql_up 值非0）curl -s {{节点IP}}:9104/metrics | grep mysql_up

[root@master ~]# curl  -s 192.168.150.166:9104/metrics | grep mysql_up
# HELP mysql_up Whether the MySQL server is up.
# TYPE mysql_up gauge
mysql_up 1

 或直接使用浏览器访问能夠看到相关 mysqld 实例指标信息则为正常{{节点IP}}:9104/metrics