Prometheus监控Mysql

Prometheus部署mysql_export

#下载mysql_exporter
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.14.0/mysqld_exporter-0.14.0.linux-amd64.tar.gz
#查看主机状态
[root@localhost /]# ls
bin   home   mnt                                        proc              run   tmp
boot  lib    mysqld_exporter-0.14.0.linux-amd64.tar.gz  prometheus_mysql  sbin  tyx
dev   lib64  node_exporter-1.5.0.linux-amd64.tar.gz     prometheus_node   srv   usr
etc   media  opt                                        root              sys   var
[root@localhost /]# ss -antl
State     Recv-Q    Send-Q         Local Address:Port         Peer Address:Port    Process    
LISTEN    0         80                   0.0.0.0:3306              0.0.0.0:*                  
LISTEN    0         128                  0.0.0.0:22                0.0.0.0:*                  
LISTEN    0         128                        *:9100                    *:*                  
LISTEN    0         128                     [::]:22                   [::]:*    

#解压
[root@localhost prometheus_mysql]# tar xf mysqld_exporter-0.14.0.linux-amd64.tar.gz  -C /prometheus_mysql/
[root@localhost prometheus_mysql]# mv /prometheus_mysql/mysqld_exporter-0.14.0.linux-amd64/* /prometheus_mysql/

#mysql创建监控用户并授权
mysql> create user 'mysql_monitor'@'localhost' identified by 'abc123';
Query OK, 0 rows affected (0.00 sec)

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

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

#创建客户端配置文件
[root@localhost prometheus_mysql]# vim .my.cnf
[root@localhost prometheus_mysql]# cat .my.cnf
[client]
user=mysql_monitor
password=abc123
[root@localhost prometheus_mysql]# 

#加入systemd管理
[root@localhost prometheus_mysql]# vim /usr/lib/systemd/system/mysqld_exporter.service
[root@localhost prometheus_mysql]# cat /usr/lib/systemd/system/mysqld_exporter.service
[Unit]
Description=prometheus server daemon

[Service]
ExecStart=/prometheus_mysql/mysqld_exporter  --config.my-cnf=/prometheus_mysql/.my.cnf
Restart=on-failure

[Install]
WantedBy=multi-user.target
[root@localhost prometheus_mysql]# systemctl daemon-reload 
[root@localhost prometheus_mysql]# systemctl enable mysqld_exporter.service 
Created symlink /etc/systemd/system/multi-user.target.wants/mysqld_exporter.service → /usr/lib/systemd/system/mysqld_exporter.service.


#启动
[root@localhost prometheus_mysql]# systemctl restart mysqld_exporter.service 
[root@localhost prometheus_mysql]# ss -antl
State     Recv-Q    Send-Q         Local Address:Port         Peer Address:Port    Process    
LISTEN    0         80                   0.0.0.0:3306              0.0.0.0:*                  
LISTEN    0         128                  0.0.0.0:22                0.0.0.0:*                  
LISTEN    0         128                        *:9100                    *:*                  
LISTEN    0         128                        *:9104                    *:*                  
LISTEN    0         128                     [::]:22                   [::]:*        

于server端加入监听端口

[root@localhost supervisory_control]# vim /prometheus/prometheus.yml 

static_configs:
            - targets: ["localhost:9090","192.168.245.130:9104","192.168.245.130:9100","192.168.245.129:9100"]


在这里插入图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值