Prometheus监控MySQL数据库

1、被管理主机服务器上安装mysql_export组件

安装mysql_exporter
~]# tar xf mysqld_exporter-0.12.1.linux-amd64.tar.gz -C /usr/local/
~]# cd /usr/local/
local]#  ln -s mysqld_exporter-0.12.1.linux-amd64/ ./mysqld_exporter

创建一个数据库账号并授权，用于peometheus获取监控数据
mysql> create user 'mysql_exporter'@'localhost' identified by '123123';
Query OK, 0 rows affected (0.01 sec)

mysql> grant select,replication client,process on *.* to 'mysql_exporter'@'localhost';
Query OK, 0 rows affected (0.00 sec)

创建.my.cnf配置文件
~]# vim /usr/local/mysqld_exporter/.my.cnf
[client]
user=mysql_exporter
password=123123

启动mysql_exporter
mysqld_exporter]# ./mysqld_exporter --config.my-cnf=/usr/local/mysqld_exporter/.my.cnf &

mysqld_exporter]# ss -anpt |grep :9104
LISTEN     0      128       [::]:9104                  [::]:*                   users:(("mysqld_exporter",pid=2784,fd=3))

2、Prometheus服务器配置文件中添加被监控得MySQL配置段

增加配置段
prometheus]# vim prometheus.yml
  - job_name: 'mysql-client'
    static_configs:
    - targets: ['192.168.53.8:9104']

重启服务
prometheus]# pkill prometheus
prometheus]# ps -ef |grep prometheus |grep -v grep
prometheus]# ./prometheus --config.file=/usr/local/prometheus/prometheus.yml &
prometheus]# netstat -anpt |grep :9090
tcp        0      0 192.168.53.6:58602      192.168.53.6:9090       ESTABLISHED 1982/./prometheus   
tcp6       0      0 :::9090                 :::*                    LISTEN      1982/./prometheus   
tcp6       0      0 192.168.53.6:9090       192.168.53.6:58602      ESTABLISHED 1982/./prometheus