Prometheus入门使用(二)

Prometheus监控MySQL:


1.下载mysqld_exporter:
root@dokcer:~# wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.14.0/mysqld_exporter-0.14.0.linux-amd64.tar.gz

2.解压mysqld_exporter:
root@dokcer:~# tar -xzvf mysqld_exporter-0.14.0.linux-amd64.tar.gz -C  /usr/local

3.创建链接文件:
root@dokcer:~# ln -sv /usr/local/mysqld_exporter-0.14.0.linux-amd64/mysqld_exporter /usr/local/bin/mysql_exporter
'/usr/local/bin/mysqld_exporter' -> '/usr/local/mysqld_exporter-0.14.0.linux-amd64/mysqld_exporter'

4.安装并启动mysql server
root@dokcer:~# apt install mysql-server
root@dokcer:~# sudo systemctl start mysql.service

5.添加用户和赋予权限信息:
mysql> CREATE USER 'exporter'@'localhost' IDENTIFIED BY '123456' WITH MAX_USER_CONNECTIONS 3;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'localhost';
Query OK, 0 rows affected (0.00 sec)


mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

6.编辑mysqld_exporter配置文件 .my.cnf文件(默认文件在~/.my.cnf)
root@dokcer:~# vim /usr/local/mysqld_exporter-0.14.0.linux-amd64/.my.cnf 
[client]
user=exporter   #mysql 用户
password=123456 #mysql密码

7.后台运行mysqld_exporter
root@dokcer:~# nohup mysqld_exporter --config.my-cnf='/usr/local/mysqld_exporter-0.14.0.linux-amd64/.my.cnf' &

8.查看mysqld exporter端口状态
root@dokcer:~# lsof -i:9104
COMMAND    PID USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
mysqld_ex 2456 root    3u  IPv6  26780      0t0  TCP *:9104 (LISTEN)

root@dokcer:~# netstat -tulp | grep 9104
tcp6       0      0 [::]:9104               [::]:*                  LISTEN      2456/mysqld_exporte 

root@dokcer:~# ss -natlp | grep 9104
LISTEN   0         128                       *:9104                   *:*        users:(("mysqld_exporter",pid=2456,fd=3))

访问http://IP:9104/metrics:

Prometheus添加MySQL主机:


1.添加Prometheus配置文件,添加MySQL主机
root@dokcer:~# vim /usr/local/prometheus/prometheus.yml

- job_name: "mysql"
    static_configs:
      - targets: ["192.168.0.50:9104"]

2.重启prometheus
root@dokcer:~# pkill prometheus
root@dokcer:~# nohup /usr/local/prometheus/prometheus --config.file=/usr/local/prometheus/prometheus.yml &