监控MySQL服务器

#监控mysql数据库主机
-----------------------------------------------------

 #服务端配置
#在Prometheus配置文件添加被监控端
vim /opt/monitor/prometheus/prometheus.yml
scrape_configs:
  - job_name: 'dbserver'
    static_configs:
   - targets: ['192.168.1.11:9104']
---------------------------------------------------
#配置完成后，使用promtool工具检查配置文件是否有误
cd /opt/monitor/prometheus
./promtool check config ./prometheus.yml 
#查看prometheus的进程id,上面修改配置进行热加载配置
ps -ef |grep prometheus
kill -HUP 62291 

#MySQL服务器（被监控端 端口9104）
mysql_exporter：用于收集MySQL性能信息。监听端口：9104
项目地址：https://github.com/prometheus/mysqld_exporter

#运行MySQL容器
docker run -d --name db -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql:5.7
docker exec -it db bash
mysql -uroot -p123456
mysql> grant PROCESS, REPLICATION CLIENT, SELECT ON *.* to 'exporter'@'%' identified by '123456';

#安装mysql_exporter采集器
tar -zxf mysqld_exporter-0.12.1.linux-amd64.tar.gz
mv mysqld_exporter-0.12.1.linux-amd64 /usr/local/mysqld_exporter
cd /usr/local/mysqld_exporter/
#指定MySQL的用户名密码
vi .my.cnf
[client] 
user=exporter      
password=123456  
 #配置为系统服务管理：   
vi /usr/lib/systemd/system/mysqld_exporter.service 
[Unit]
Description=mysqld_exporter 
[Service]
ExecStart=/usr/local/mysqld_exporter/mysqld_exporter --config.my-cnf=/usr/local/mysqld_exporter/.my.cnf
ExecReload=/bin/kill -HUP $MAINPID
KillMode=process
Restart=on-failure
[Install]
WantedBy=multi-user.target
#加载服务配置启动，开机启动
systemctl daemon-reload 
systemctl start mysqld_exporter 
systemctl enable mysqld_exporter