zifuy 的个人笔记

Mysql监控

参考文章

说明 mysqld_exporter可以部署在Prometheus服务端，也可以部署在mysql服务所在的主机。

通过在Prometheus服务端部署mysqld_exporter

mysqld_exporter-0.12.1下载

cd /usr/local/

wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gz

tar -zxf mysqld_exporter-0.12.1.linux-amd64.tar.gz

mv mysqld_exporter-0.12.1.linux-amd64 mysqld_exporter

mysql授权mysqld_exporter客户端连接

set global validate_password_policy=0;

set global validate_password_length=4;

grant all privileges on *.* to root@"%" identified by 'root';

flush privileges;

# vim /etc/systemd/system/mysqld_exporter.service
[Unit]
Description=mysqld_exporter
After=network.target

[Service]
Environment=DATA_SOURCE_NAME=root:root@(192.168.22.22:3306)/
Restart=on-failure
ExecStart=/usr/local/mysqld_exporter/mysqld_exporter

[Install]
WantedBy=multi-user.target

部署在mysql服务所在主机时修改上面的ip地址即可

服务管理命令

systemctl daemon-reload  
systemctl start mysqld_exporter  
systemctl status mysqld_exporter

启动后查看

http://10.10.2.30:9104/metrics

添加 prometheus 监控

# vim prometheus.yml
  - file_sd_configs:
    - files:
      - 'configs/mysql.yml'
    job_name: MySQL
    metrics_path: /metrics
    relabel_configs:
    - source_labels: [__address__]
      regex: (.*)
      target_label: instance
      replacement: $1
    - source_labels: [__address__]
      regex: (.*)
      target_label: __address__
      replacement: $1:9104

# vim configs/mysql.yml
- labels:
    service: mysql_192.168.22.22
  targets:
  - 192.168.22.11

配置 grafana 展示

从 https://grafana.com/dashboards/6239 下载 json 文件，导入 grafana，根据需求调整即可。

Prometheus部署在Kubernetes时的配置

[root@Master01 mysql_exporter]# cat mysql-*
apiVersion: monitoring.coreos.com/v1
kind: ServiceMonitor
metadata:
  name: mysql-23
  namespace: monitoring
  labels:
    k8s-app: mysql-23
spec:
  jobLabel: k8s-app
  endpoints:
  - port: port
    interval: 30s
    scheme: http
  selector:
    matchLabels:
      k8s-app: mysql-23
  namespaceSelector:
    matchNames:
    - monitoring
apiVersion: v1
kind: Service
metadata:
  name: mysql-23
  namespace: monitoring
  labels:
    k8s-app: mysql-23
spec:
  type: ClusterIP
  clusterIP: None
  ports:
  - name: port
    port: 9104
    protocol: TCP

---
apiVersion: v1
kind: Endpoints
metadata:
  name: mysql-23
  namespace: monitoring
  labels:
    k8s-app: mysql-23
subsets:
- addresses:
  - ip: 10.10.2.30
  ports:
  - name: port
    port: 9104
    protocol: TCP

ip需要写 mysql_exporter所部署的主机ip

等待一会后 资源创建后查看 prometheus 界面数据是否正常

添加到grafana

import 6239

待续---

Kafka监控

待续---