4.普罗米修斯promethues2.35.0监控-mysql.docx

4.普罗米修斯promethues2.35.0监控-mysql(mysql_exporter)

promethues监控宿docker容器服务和alertmanager报警：

--promethues支持两种添加被监控端：1)静态配置(手动配置),2)服务发现(动态发现需要监控的target实例(基于文件和基于consul))

mysql节点安装mysql_exporter:（手动到各个节点安装）

机器：9mysql_exporter(mysql主被监控端)

机器：2alertmanager、promethues

一、监控mysql单机

1.先搭建mysql单机(mysql5.7.24-docker搭建)

Mysql库：9上：

[root@k8s-node3~]#dockerps|grepmysql

3d0c927946afmysql:5.7.24docker-entrypoint.s…5minutesagoUp5minutesmysql

[root@k8s-node3~]#dockerexec-itmysqlmysql-uroot-p123456

mysqlshowdatabases;

+--------------------+

|Database|

+--------------------+

|information_schema|

|mysql|

|performance_schema|

|sys|

+--------------------+

mysqlgrantselect,process,super,replicationclient,reloadon*.*tomysql_exporter@192.168.10.%identifiedby123;

mysqlflushprivileges;

mysqlquit

#上面授权一个账号，供mysql_exporter服务连接mysql

2.安装mysql_exporter安装(二进制方式安装)(被监控端mysql上安装)

#wget/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gz

#lsmysqld_exporter-0.12.1.linux-amd64.tar.gz

mysqld_exporter-0.12.1.linux-amd64.tar.gz

#tar-zxfmysqld_exporter-0.12.1.linux-amd64.tar.gz

#mvmysqld_exporter-0.12.1.linux-amd64/data/mysql_exporter

#ls/data/mysql_exporter/mysqld_exporter#查看二进制文件

/data/mysql_exporter/mysqld_exporter

#vim/data/mysql_exporter/.f#新建一个密码文件,供mysql_exporter连接到mysql

[client]

host=9#连接mysql的ip

user=mysql_exporter#连接mysql的用户

password=123#连接mysql的密码

port=3306

交个systemed管理：

#vim/usr/lib/systemd/system/mysql_exporter.service

[Unit]

Description=mysql_exporterdaemon

[Service]

Restart=on-failure

ExecStart=/data/mysql_exporter/mysqld_exporter--config.my-cnf=/data/mysql_exporter/.f

[Install]

WantedBy=multi-user.target

#systemctldaemon-reload

[root@k8s-node3~]#systemctlstartmysql_exporter

[root@k8s-node3~]#systemctlstatusmy