Mysql_export - 监控相关

#参考资料
	https://blog.csdn.net/qq_32502263/article/details/118794813
	https://segmentfault.com/a/1190000044009032#fl0Qb

---
#1、创建数据库账号
	#注意：密码不要带@
	CREATE USER 'exporter'@'%' IDENTIFIED BY 'xxxxxxxxxxxxx';
	GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'exporter'@'%';
	GRANT SELECT ON performance_schema.* TO 'exporter'@'%';
	
---
#2、创建yml文件
	vim deployment.yml
---
    apiVersion: apps/v1
    kind: Deployment
    metadata:
      name: mysqld-exporter
      namespace: monitoring
      labels:
        app: mysqld-exporter
    spec:
      selector:
        matchLabels:
          app: mysqld-exporter
      template:
        metadata:
          labels:
            app: mysqld-exporter
        spec:
          containers:
          - name: mysqld-exporter
            image: swr.cn-south-1.myhuaweicloud.com/d9cloud/prom/mysqld-exporter:latest
        	args:  
        	- --collect.slave_status
        	- --collect.binlog_size
        	- --collect.info_schema.processlist
        	- --collect.info_schema.innodb_metrics
        	- --collect.engine_innodb_status
        	- --collect.perf_schema.file_events
        	- --collect.perf_schema.replication_group_member_stats
        	- --collect.info_schema.innodb_tablespaces
        	- --collect.info_schema.tables
            env:
            - name: DATA_SOURCE_NAME
              value: exporter:XXXXXXXX@(mysql:3306)/  #数据库连接： 用户：密码@（主机：端口）
            ports:
            - containerPort: 9104
              name: http
          imagePullSecrets: # 镜像仓库拉取密钥
          - name: default-secret
    
    ---
    apiVersion: v1
    kind: Service
    metadata:
      labels:
        app: mysqld-exporter
      name: mysqld-exporter
      namespace: monitoring
    spec:
      type: ClusterIP
      ports:
      - name: metrics
        port: 9104
        protocol: TCP
        targetPort: 9104
      selector:
       app: mysqld-exporter

---
	kubectl apply -f deployment.yml
	
---
#3、测试
	kubectl get svc -n monitoring | grep mysqld-exporter
	----------------------------------------------------------
	curl <serviceip>:9104/metrics

![](/media//202406/2024-06-12143333031824.png)

![](/media//202406/2024-06-12143405023476.png)

---
#4、修改prometheus配置

- job_name: 'mysqld-exporter'
            scrape_interval: 30s
            static_configs:
            - targets: ["mysqld-exporter:9104"]

![](/media//202406/2024-06-12143805996787.png)

---
#5、验证

![](/media//202406/2024-06-12143831821024.png)

---
#6、grafana添加图表
	id:17320 
	id:14057