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 -zxvf mysqld_exporter-0.12.1.linux-amd64.tar.gz
mv mysqld_exporter-0.12.1.linux-amd64 mysqld_exporter


mysql的pxc集群添加账号密码：
GRANT REPLICATION CLIENT, PROCESS ON . TO 'exporter'@'localhost' identified by '123456';
GRANT SELECT ON performance_schema.* TO 'exporter'@'localhost';
flush privileges;


[root@pxc1 mysqld_exporter]# cat .my.cnf 
[client]
host=192.168.7.201
user=exporter
password=123456


启动：
nohup ./mysqld_exporter --config.my-cnf=.my.cnf &
复制

 - job_name: 'mysql-cluster'
   static_configs:
   - targets:
     - '192.168.7.201:9104'
     - '192.168.7.202:9104'
     - '192.168.7.203:9104'
     
     
     
报警：
############ mysql 监控 ############
      - alert: MySQLGaleraNotReady
        expr: mysql_global_status_wsrep_ready != 1
        for: 5m
        labels:
          severity: warning
        annotations:
          description: "{{$labels.job}} on {{$labels.instance}} is not ready."
          summary: "Galera cluster node not ready"
      - alert: MySQLGaleraOutOfSync
        expr: (mysql_global_status_wsrep_local_state != 4 and mysql_global_variables_wsrep_desync == 0)
        for: 5m
        labels:
          severity: warning
        annotations:
          description: "{{$labels.job}} on {{$labels.instance}} is not in sync ({{$value}}!= 4)."
          summary: "Galera cluster node out of sync"
      - alert: MySQL is down
        expr: mysql_up == 0
        for: 1m
        labels:
          severity: critical
        annotations:
          description: "Instance {{ $labels.instance }} MySQL is down"
          summary: "MySQL database is down. This requires immediate action!"
      - alert: MySql 连接数超过最大连接数的80%
        expr: mysql_global_status_max_used_connections > mysql_global_variables_max_connections * 0.8
        for: 2m
        labels:
          severity: warning
        annotations:
          description: "Instance {{ $labels.instance }} Used more than 80% of max connections limited"
          summary: "Used more than 80% of max connections limited"
复制