tencent cloud

CREATE USER 'exporter'@'ip' IDENTIFIED BY 'password' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'ip';

apiVersion: v1
kind: Secret
metadata:
  name: mysql-secret-test
  namespace: mysql-demo
type: Opaque
stringData:
  datasource: "user:password@tcp(ip:port)/"  #corresponds to MySQL connection string information


apiVersion: apps/v1
kind: Deployment
metadata:
  labels:
    k8s-app: mysql-exporter  # Adjust to the corresponding name based on business requirements. It is recommended to include information about the MySQL instance.
  name: mysql-exporter  # Adjust to the corresponding name based on business requirements. It is recommended to include information about the MySQL instance.
  namespace: mysql-demo
spec:
  replicas: 1
  selector:
    matchLabels:
      k8s-app: mysql-exporter  # Adjust to the corresponding name based on business requirements. It is recommended to include information about the MySQL instance.
  template:
    metadata:
      labels:
        k8s-app: mysql-exporter  # Adjust to the corresponding name based on business requirements. It is recommended to include information about the MySQL instance.
    spec:
      containers:
      - env:
        - name: DATA_SOURCE_NAME
          valueFrom:
            secretKeyRef:
              name: mysql-secret-test # Corresponds to the name of the Secret in the previous step.
              key: datasource # Corresponds to the Secret Key in the previous step.
        image: ccr.ccs.tencentyun.com/rig-agent/mysqld-exporter:v0.12.1
        imagePullPolicy: IfNotPresent
        name: mysql-exporter
        ports:
        - containerPort: 9104
          name: metric-port 
        terminationMessagePath: /dev/termination-log
        terminationMessagePolicy: File
      dnsPolicy: ClusterFirst
      imagePullSecrets:
      - name: qcloudregistrykey
      restartPolicy: Always
      schedulerName: default-scheduler
      securityContext: {}
      terminationGracePeriodSeconds: 30


wget -O- localhost:9104/metrics

  apiVersion: monitoring.coreos.com/v1
  kind: PodMonitor
  metadata:
    name: mysql-exporter  # Enter a unique name.
    namespace: cm-prometheus  # Pay-as-you-go instance: cluster namespace; Annual and monthly subscription instances (no longer available): namespace is fixed, do not change
  spec:
    podMetricsEndpoints:
    - interval: 30s
      port: metric-port  # Enter the port of the Prometheus Exporter in the Pod YAML file.
      path: /metrics  # Enter the path of the Prometheus Exporter. Default value: /metrics.
      relabelings:
      - action: replace
        sourceLabels: 
        - instance
        regex: (.*)
        targetLabel: instance
        replacement: 'cdb-xxxxxx' # Replace with the corresponding MySQL instance ID
      - action: replace
        sourceLabels: 
        - instance
        regex: (.*)
        targetLabel: ip
        replacement: '1.x.x.x' # Replace with the corresponding MySQL instance IP
    namespaceSelector:  # Select the namespace where the Pod to be monitored is located.
      matchNames:
      - mysql-demo
    selector:  # Enter the labels of the Pod to be monitored to locate the target Pod.
      matchLabels:
        k8s-app: mysql-exporter