linux系统监控工具prometheus的安装以及监控mysql

安装

https://prometheus.io/download/下载客户端和服务端以及需要监控的所有的包

服务端

官网下载下载prometheustar -xf prometheus-2.47.2.linux-amd64.tar.gz -C /usr/local/
cd /usr/local/
mv prometheus-2.47.2.linux-amd64 prometheus
cd prometheus
./prometheus --config.file=prometheus.yml &     //启动prometheus

将Prometheus配置为systemd管理vim /usr/lib/systemd/system/prometheus.service[Unit]
Description=https://prometheus.io[Service]
Restart=on-failure
ExecStart=/usr/local/prometheus/prometheus --config.file=/usr/local/prometheus/prometheus.yml --web.listen-address=:9090[Install]                      
WantedBy=multi-user.targetsystemctl daemon-reload
systemctl start prometheus

客户端

官网下载安装node_exportertar -xf node_exporter-1.7.0.linux-amd64.tar.gz -C /usr/local/
cd /usr/local/
mv node_exporter-1.7.0.linux-amd64/ node_exporter
cd node_exporter/
./node_exporter &默认端口9100

将node_exporter配置为systemd管理vim /usr/lib/systemd/system/node_exporter.service[Unit]
Description=node_exporter
After=network.target [Service]
ExecStart=/usr/local/node_exporter/node_exporter
Restart=on-failure[Install]
WantedBy=multi-user.targetsystemctl daemon-reload
systemctl start node_exporter

服务端配置数据
vim prometheus.yml 
scrape_configs:# The job name is added as a label `job=<job_name>` to any timeseries scraped from this config.- job_name: "prometheus"# metrics_path defaults to '/metrics'# scheme defaults to 'http'.static_configs:- targets: ["localhost:9090"]# 添加以下内容- job_name: "node_exporter"static_configs:# 如果有多个机器，用','分开- targets: ['ip:端口']# 重启prometheus服务
systemctl restart prometheus

监控mysql

# 官网下载安装mysqld-exporter
tar xf mysqld_exporter-0.15.0.linux-amd64.tar.gz -C /usr/local/
cd /usr/local
mv mysqld_exporter-0.15.0.linux-amd64 mysqld_exporter
cd mysqld_exporter/vim .my.cnf[client]
user=用户名
password=密码./mysqld_exporter --config.my-cnf="/usr/local/mysqld_exporter/.my.cnf" &           //启动mysqld-exporterps -ef |grep mysqld_exporter    //查看进程
ss -lntp |grep 4647             //过滤进程号，查看端口
默认端口：9104

将mysqld-exporter配置为systemd管理vim /usr/lib/systemd/system/mysqld_exporter.service[Unit]
Description=Prometheus
[Service]
ExecStart=/usr/local/mysqld_exporter/mysqld_exporter --config.my-cnf=/usr/local/mysqld_exporter/.my.cnf
Restart=on-failure
[Install]
WantedBy=multi-user.targetsystemctl daemon-reload
systemctl start mysqld_exporter

服务端配置
vim prometheus.yml                  //prometheus配置文件添加- job_name: 'mysql'static_configs:- targets: ['ip:端口']systemctl restart prometheus   //重启prometheus

prometheus浏览器查看

浏览器访问
ip:9090

status=》Targets
查看关联的主机