prometheusmysql_Grafana+Prometheus监控MySQL

架构图

环境

IP

环境

需装软件

192.168.0.237

mysql-5.7.20

node_exporter-0.15.2.linux-amd64.tar.gz

mysqld_exporter-0.10.0.linux-amd64.tar.gz

192.168.0.248

grafana&＃43;prometheus

prometheus-2.1.0.linux-amd64.tar.gz

node_exporter-0.15.2.linux-amd64.tar.gz

grafana-4.6.3.linux-x64.tar.gz

在 192.168.0.248 上安装 grafana prometheus

安装 prometheus

# 创建保存软件的目录

mkdir /data/software/ -p

cd /data/software/

# 解压 prometheus

tar xvf prometheus-2.1.0.linux-amd64.tar.gz -C /iba/

cd /iba/

mv prometheus-2.1.0.linux-amd64 prometheus

cd prometheus/

cp prometheus.yml /tmp/prometheus.yml.20181203

# 配置 prometheus.yml

cat prometheus.yml

# my global config

global:

scrape_interval: 15s # Set the scrape interval to every 15 seconds. Default is every 1 minute.

evaluation_interval: 15s # Evaluate rules every 15 seconds. The default is every 1 minute.

# scrape_timeout is set to the global default (10s).

# A scrape configuration containing exactly one endpoint to scrape:

# Here it&＃39;s Prometheus itself.

scrape_configs:

- job_name: &＃39;Host&＃39;

file_sd_configs:

- files:

- host.yml

metrics_path: /metrics

relabel_configs:

- source_labels: [__address__]

regex: (.*)

target_label: instance

replacement: $1

- source_labels: [__address__]

regex: (.*)

target_label: __address__

replacement: $1:9100

- job_name: &＃39;MySQL&＃39;

file_sd_configs:

- files:

- mysql.yml

metrics_path: /metrics

relabel_configs:

- source_labels: [__address__]

regex: (.*)

target_label: instance

replacement: $1

- source_labels: [__address__]

regex: (.*)

target_label: __address__

replacement: $1:9104

- job_name: &＃39;prometheus&＃39;

static_configs:

- targets:

- localhost:9090

cat host.yml

- labels:

service: test

targets:

- 192.168.0.248

- 192.168.0.237

cat mysql.yml

- labels:

service: test

targets:

- 192.168.0.237

# 测试 prometheus 是否可以正常启动

/iba/prometheus/prometheus --storage.tsdb.retention&＃61;30d &

ps -ef|grep prometh

kill -9 14650

# 配置 prometheus.service 文件

vi /usr/lib/systemd/system/prometheus.service

# 内容为

[Unit]

Description&＃61;Prometheus instance

Wants&＃61;network-online.target

After&＃61;network-online.target

[Service]

User&＃61;root

Group&＃61;root

Type&＃61;simple

Restart&＃61;on-failure

WorkingDirectory&＃61;/iba/prometheus/

RuntimeDirectory&＃61;prometheus

RuntimeDirectoryMode&＃61;0750

ExecStart&＃61;/iba/prometheus/prometheus --storage.tsdb.retention&＃61;30d --config.file&＃61;/iba/prometheus/prometheus.yml

LimitNOFILE&＃61;10000

TimeoutStopSec&＃61;20

[Install]

WantedBy&＃61;multi-user.target

# 启动 prometheus

systemctl start prometheus

systemctl status prometheus -l

# 开放防火墙

firewall-cmd --permanent --add-rich-rule&＃61;"rule family&＃61;"ipv4" source address&＃61;"192.168.0.0/16" accept"

firewall-cmd --reload

安装 node_exporter 获取主机信息

# 解压 node_exporter

cd /data/software/

tar xf node_exporter-0.15.2.linux-amd64.tar.gz -C /usr/local

mv node_exporter-0.15.2.linux-amd64 node_exporter

nohup ./node_exporter &

安装 grafana

cd /iba/software

# 解压

tar xf grafana-4.6.3.linux-x64.tar.gz -C /iba/prometheus/

cd /iba/prometheus/

mv grafana-4.6.3 grafana

cd grafana/

# 测试

./bin/grafana-server

# 停止

ctrl&＃43;c

cat /usr/lib/systemd/system/grafana-server.service

[Unit]

Description&＃61;Grafana instance

Documentation&＃61;http://docs.grafana.org

Wants&＃61;network-online.target

After&＃61;network-online.target

[Service]

User&＃61;root

Group&＃61;root

Type&＃61;simple

Restart&＃61;on-failure

WorkingDirectory&＃61;/iba/prometheus/grafana

RuntimeDirectory&＃61;grafana

RuntimeDirectoryMode&＃61;0750

ExecStart&＃61;/iba/prometheus/grafana/bin/grafana-server

LimitNOFILE&＃61;10000

TimeoutStopSec&＃61;20

[Install]

WantedBy&＃61;multi-user.target

# 启动

systemctl start grafana-server

systemctl status grafana-server -l

配置数据源

在 192.168.0.237 安装 node_exporter 和 mysqld_exporter

cd /iba/software/

tar zxf node_exporter-0.15.2.linux-amd64.tar.gz -C /usr/local/

cd /usr/local/

mv node_exporter-0.15.2.linux-amd64 node_exporter

# 启动

cd node_exporter/

nohup ./node_exporter &

几分钟后 grafana 出现了新服务器的信息

在mysql上配置监控使用的用户

GRANT REPLICATION CLIENT, PROCESS, SELECT ON *.* TO &＃39;mysql_monitor&＃39;&＃64;&＃39;%&＃39; IDENTIFIED BY &＃39;mysql_monitor&＃39;;

FLUSH PRIVILEGES;

cd /iba/software/

tar zxf mysqld_exporter-0.10.0.linux-amd64.tar.gz -C /usr/local/

cd /usr/local/

mv mysqld_exporter-0.10.0.linux-amd64/ mysqld_exporter

cd mysqld_exporter/

# 在 mysql 上创建一个专门用于监控的用户&＃xff0c;

cat .my.cnf

[client]

user&＃61;mysql_monitor

password&＃61;mysql_monitor

# 启动

nohup /usr/local/mysqld_exporter/mysqld_exporter -config.my-cnf&＃61;"/usr/local/mysqld_exporter/.my.cnf" &

导入 dashboard: MySQL_Overview.json