mysql export_mysql-export 监控

背景说明

prometheus 使用的是kube-prometheus 部署的，也就是通过servicemonitor 的方式监控新的监控项目。mysql export 插件通过helm 部署的 pod  service servicemonitor 等资源。

mysql-export 安装配置

通过helm 形式部署

添加仓库，下载包

helm repo add  azure http://mirror.azure.cn/kubernetes/charts/

helm repo update

helm pull azure/prometheus-mysql-exporter

tar -xvf prometheus-mysql-exporter-0.7.1.tgz

配置

cp prometheus-mysql-exporter/values.yaml  prometheus-mysql-exporter/values-117.yaml

vi prometheus-mysql-exporter/values-117.yaml

serviceMonitor:

# enabled should be set to true to enable prometheus-operator discovery of this service

enabled: true

# interval is the interval at which metrics should be scraped

interval: 30s

# scrapeTimeout is the timeout after which the scrape is ended

scrapeTimeout: 10s

# additionalLabels is the set of additional labels to add to the ServiceMonitor

additionalLabels: {}

jobLabel: ""

targetLabels: []

podTargetLabels: []

metricRelabelings: []

mysql:

db: ""

host: "52.13.22.91"

param: ""

pass: "xxxxxxx"

port: 3306

protocol: ""

user: "root"

existingSecret: false

部署

helm install m91 prometheus-mysql-exporter -f prometheus-mysql-exporter/values-91.yaml      ( 注意此时的命名空间是默认的)

deployment    pod   service  endpoint   servicemonitor  一并创建了

验证