大数据集群监控配置操作指导（二）node_exporter+mysql_exporter部署
2.node_exporter监控集群服务器（所有集群服务器）
wget https://github.com/prometheus/node_exporter/releases/download/v1.3.1/node_exporter-1.3.1.linux-amd64.tar.gz
tar -zxvf node_exporter-1.3.1.linux-amd64.tar.gz -C /opt/dtstack/exporters/
mv node_exporter-1.3.1.linux-amd64 node_exporter-1.3.1
2.1可以直接启动，同样也可以配置成服务方便管理
直接启动命令
./node_exporter
2.2配置成服务
vim /etc/systemd/system/node_exporter.service
[Unit]
Description=node_exporter
Documentation=https://prometheus.io/
After=network.target
[Service]
Type=simple
User=root
ExecStart=/opt/software/exporters/node_exporter-1.3.1/node_exporter
Restart=on-failure
[Install]
WantedBy=multi-user.target
2.3将node_exporter的目录，和node_exporter.service文件分发到其他服务器上
2.4使node_exporter 服务生效(所有服务器)
systemctl daemon-reload
2.5启动node_exporter服务，并配置开机自启(所有服务器)
systemctl start node_exporter
systemctl status node_exporter
systemctl enable node_exporter
2.6更改prometheus的配置文件
vim /opt/dtstack/prometheus-2.33.3/prometheus.yml
增加
- job_name: 'node_exporter'
static_configs:
- targets:
- 'db001:9100'
- 'db002:9100'
- 'db003:9100'
- 'db004:9100'
2.7重启prometheus
systemctl restart prometheus
2.8查看配置是否生效，要进入prometheus的web界面进入status，选择targets看到node_exporter存在，并且状态是up说明已经成功
3.mysql暴露监控指标
3.1下载监控mysql的mysql_exporter，安装在mysql服务所在服务器上，然后解压安装包
cd /opt/dtstack/exporters
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.13.0/mysqld_exporter-0.13.0.linux-amd64.tar.gz
tar -zxvf mysqld_exporter-0.13.0.linux-amd64.tar.gz -C /opt/dtstack/exporters/
mv mysqld_exporter-0.13.0.linux-amd64 mysqld_exporter-0.13
cd mysqld_exporter-0.13
3.2登录mysql，创建exporter用户
CREATE USER 'exporter'@'%' IDENTIFIED BY 'exporter';
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'%';
FLUSH PRIVILEGES;
3.3创建mysql配置文件、运行时可免密码连接数据库：
vim /opt/dtstack/exporters/mysqld_exporter-0.13/.my.cnf
[client]
user=exporter
password=exporter
3.4给mysql_exporter赋权
useradd mysql
chown -R mysql:mysql /opt/software/exporters/mysqld_exporter-0.13
3.5将mysql_exporter配置成服务
vim /etc/systemd/system/mysql_exporter.service
[Unit]
Description=mysql_exporter
Documentation=https://prometheus.io/
After=network.target
[Service]
User=mysql
Restart=on-failure
WorkingDirectory=/opt/dtstack/exporters/mysqld_exporter-0.13
ExecStart=/opt/dtstack/exporters/mysqld_exporter-0.13/mysqld_exporter \
--config.my-cnf=/opt/dtstack/exporters/mysqld_exporter-0.13/.my.cnf
[Install]
WantedBy=multi-user.target
3.6启动服务，配置开机自启
systemctl daemon-reload
systemctl start mysql_exporter
systemctl status mysql_exporter
systemctl enable mysql_exporter
3.7查看mysql_exporter的端口
netstat -ntpl | grep mysql
3.8修改prometheus的配置文件
vim /opt/dtstack/prometheus-2.33.3/prometheus.yml
- job_name: 'mysql_master'
static_configs:
- targets: ['db004:9104']
labels:
service_name: 'mysql_master'
product_name: 'mysql'
systemctl restart prometheus
systemctl status prometheus
