助力工业物联网，工业大数据之服务域：node_exporter插件【三十七】

Maynor

发布于 2023-08-21 08:17:14

2200

发布于 2023-08-21 08:17:14

文章被收录于专栏：最新最全的大数据技术体系

前言

项目所需工具: 链接：https://pan.baidu.com/s/1sIa8nninf2Fz6YqE3vUpqQ?pwd=5wr3 提取码：5wr3 –来自百度网盘超级会员V4的分享

06：node_exporter插件

目标：实现node_exporter插件的安装监控Linux指标

实施

上传安装

cd ~
rz
tar zxvf node_exporter-1.1.2.linux-amd64.tar.gz -C /opt/prometheus-2.26/
mv /opt/prometheus-2.26/node_exporter-1.1.2.linux-amd64 /opt/prometheus-2.26/node_exporter

# 创建并编辑文件
vim /etc/systemd/system/node_exporter.service

[Unit]
Description=node_exporter
Documentation=Prometheus node_exporter plugin

[Service]
ExecStart=/opt/prometheus-2.26/node_exporter/node_exporter
Restart=on-failure
[Install]
WantedBy=multi-user.target

启动

# 设置开机自启动
systemctl enable node_exporter
# 启动服务
systemctl start node_exporter
# 查看服务状态
systemctl status node_exporter

配置Prometheus

vim /opt/prometheus-2.26/prometheus.yml

scrape_configs:

  - job_name: 'prometheus'
    static_configs:
      - targets: ['localhost:9090']
  # 增加以下内容
  - job_name: 'linux'
    static_configs:
    - targets: ['localhost:9100']
      labels:
        instance: node1

重启prometheus

systemctl restart prometheus.service

验证：http://node1:9090

查看当前主机的CPU使用情况：node_cpu_seconds_total

查看当前主机的CPU负载情况：node_load15

小结

实现node_exporter插件的安装监控Linux指标

07：mysqld_exportor插件

目标：实现mysqld_exportor插件的安装监控MySQL指标

实施

上传安装

cd ~
rz
tar zxvf mysqld_exporter-0.13.0-rc.0.linux-amd64.tar.gz -C /opt/prometheus-2.26/
mv /opt/prometheus-2.26/mysqld_exporter-0.13.0-rc.0.linux-amd64/ /opt/prometheus-2.26/mysqld_exporter/

配置MySQL用户授权

mysql -uroot -p
SHOW VARIABLES LIKE 'validate_password%';
set global validate_password_policy=LOW; 
set global validate_password_length=6;
# 授权
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'mysql_exporter'@'localhost' IDENTIFIED BY '123456' WITH MAX_USER_CONNECTIONS 3;
flush privileges;

DDL：数据定义语言：建库建表
DML：数据操作语言：增删改
DQL：数据查询语言：查询
DCL：grant、revoke

注册服务

vim /etc/systemd/system/mysqld_exporter.service

[Unit]
Description=mysqld_exporter
Documentation=Prometheus mysql exporter plugin

[Service]
Type=simple
User=mysql
Environment=DATA_SOURCE_NAME=mysql_exporter:123456@(localhost:3306)/
ExecStart=/opt/prometheus-2.26/mysqld_exporter/mysqld_exporter --config.my-cnf /etc/my.cnf \
  --collect.slave_status \
  --collect.slave_hosts \
  --log.level=error \
  --collect.info_schema.processlist \
  --collect.info_schema.innodb_metrics \
  --collect.info_schema.innodb_tablespaces \
  --collect.info_schema.innodb_cmp \
  --collect.info_schema.innodb_cmpmem 
Restart=on-failure
[Install]
WantedBy=multi-user.target

启动服务

# 设置开机自启动
systemctl enable mysqld_exporter
# 启动服务
systemctl start mysqld_exporter
# 查看服务状态
systemctl status mysqld_exporter

配置Prometheus

vim /opt/prometheus-2.26/prometheus.yml

scrape_configs:
  # 增加以下内容
  - job_name: 'mysql'
    scrape_interval: 1s
    static_configs:
    - targets: ['localhost:9104']
      labels:
        instance: 'mysqld_exporter'

重启prometheus