Prometheus监控mysql

监控远程MySQL

1. 下载mysqld_exporter组件

下载地址: https://prometheus.io/download/

2. 安装组件

mkdir /usr/local/mysqld_exporter
tar -xvf mysqld_exporter-0.12.1.linux-amd64.tar.gz -C /usr/local/mysqld_exporter
cd /usr/local/mysqld_exporter

3. mysql创建用户，并授权

#创建用户并授权
create user 'exporter'@'%' identified by '123456' with MAX_USER_CONNECTIONS 3 ;
grant process,replication client,select on *.* to 'exporter'@'%';
flush privileges;
quit;

4. 创建mysql连接的配置文件

vim /usr/local/mysqld_exporter/.my.cnf 

[client] 
user=exporter
password=123456

cp /usr/local/mysqld_exporter/.my.cnf /root/

5. 启动mysqld_exporter

直接./mysqld_exporter启动，看是否有报错

没有报错

nohup /usr/local/mysqld_exporter/mysqld_exporter --config.my-cnf=/usr/local/mysqld_exporter/.my.cnf &
#确认端口
netstat -tlnp |grep 9014

6. 回到prometheus服务器的配置文件里添加被监控的mysql的配置段

- job_name: 'mysql'
    static_configs:
    - targets: ['192.168.81.136:9104']

7. 改完配置文件后,重启服务

pkill prometheus 
/usr/local/prometheus/prometheus --config.file="/usr/local/prometheus/prometheus.yml" &