mysql 集群_prometheus监控mysql集群

安装mysql_exporter

cd /usr/localwget https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gztar -zxvf mysqld_exporter-0.12.1.linux-amd64.tar.gzmv mysqld_exporter-0.12.1.linux-amd64 mysqld_exportermysql的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.201user=exporterpassword=123456启动：nohup ./mysqld_exporter --config.my-cnf=.my.cnf &

prometheus配置

 - 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"

grafana导入模板

https://grafana.com/grafana/dashboards/7362 mysqlhttps://grafana.com/grafana/dashboards/7377 pxc