prometheus 监控MySQL数据库_prometheous监控mysql数据库

1、MySQL数据库安装exporter

安装mysqld_exporter

由于mysqld_exporter需要连接到MySQL，创建用户并赋予所需的权限

GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'mysql_monitor'@'localhost' identified by 'mysql_monitor';
GRANT SELECT ON *.* TO 'mysql_monitor'@'localhost';

修改配置文件

[client]
user=mysql_monitor
password=mysql_monitor

运行

 nohup  mysqld_exporter --config.my-cnf=/etc/my.cnf &

2、prometheus配置

  - job_name: 'mysql'   
    static_configs:   
       - targets: ['10.130.4.**:9104']
       - targets: ['10.130.4.**:9104']
       - targets: ['172.18.1.**:9104']
       - targets: ['172.18.1.**:9104'] 

3、监控效果