linux安装prometheus的node-exporter

1.首先需要增加授权

mysql> GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'localhost' IDENTIFIED BY 'exporter123' WITH MAX_USER_CONNECTIONS 3;
mysql> flush privileges;

2.安装mysqld_exporter

mkdir /usr/local/prometheus
cd /usr/local/prometheus/
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.13.0/mysqld_exporter-0.13.0.linux-amd64.tar.gz
tar xzvf  mysqld_exporter-0.13.0.linux-amd64.tar.gz
mv mysqld_exporter-0.13.0.linux-amd64.tar.gz  mysqld_exporter
chown -R root:root /usr/local/prometheus/mysqld_exporter/mysqld_exporter
chmod 755 /usr/local/prometheus/mysqld_exporter/mysqld_exporter

3.创建启动项文件

 vim /etc/systemd/system/mysqld_exporter.service

[Unit]
Description=mysqld_exporter
After=network.target
[Service]
Type=simple
User=mysql
Environment=DATA_SOURCE_NAME=exporter:exporter123@(localhost:3306)/
ExecStart=/usr/local/prometheus/mysqld_exporter/mysqld_exporter --web.listen-address=0.0.0.0:9104 
  --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.targe

4.启动exporter

chown -R root:root /etc/systemd/system/mysqld_exporter.service
chmod 644 /etc/systemd/system/mysqld_exporter.service
systemctl daemon-reload
systemctl enable mysqld_exporter.service
systemctl start mysqld_exporter.service

5.访问localhost:9104/metrics可以看到mysql的指标

6.修改prometheus配置文件，scrape_configs下面添加

scrape_configs:
  - job_name: 'mysql'
    static_configs:
      - targets: ['localhost:9104']

7.在界面可以看到mysql相关指标