Prometheus配置Mysql邮件报警

[Unit]Description=alertmanagerDocumentation=https://github.com/prometheus/alertmanagerAfter=network.target[Service]Type=simpleUser=rootExecStart=/usr/local/alertmanager/alertmanager --config.file=/usr/local/alertmanager/alertmanager.ymlRestart=on-failure[Install]WantedBy=multi-user.target

global:  resolve_timeout: 5m  # 邮件配置  smtp_smarthost: 'smtp.exmail.qq.com:25'  smtp_from: 'service@yangxingzhen.com'  smtp_auth_username: 'service@yangxingzhen.com'  smtp_auth_password: '123456'  smtp_require_tls: false# route用来设置报警的分发策略route:  # 采用哪个标签来作为分组依据  group_by: ['alertname']  # 组告警等待时间。也就是告警产生后等待10s，如果有同组告警一起发出  group_wait: 10s  # 两组告警的间隔时间  group_interval: 10s  # 重复告警的间隔时间，减少相同邮件的发送频率  repeat_interval: 5m  # 设置默认接收人  receiver: 'default-receiver'  routes:   # 可以指定哪些组接手哪些消息  - receiver: 'default-receiver'    continue: true    group_wait: 10sreceivers:- name: 'default-receiver'  email_configs:  - to: 'xingzhen.yang@yangxingzhen.com'    headers: { Subject: "[WARN] 报警邮件" }

groups:- name: MySQL  rules:  - alert: MySQL Status # 告警名称    expr: mysql_up == 0    for: 5s # 满足告警条件持续时间多久后，才会发送告警    annotations: # 解析项，详细解释告警信息      summary: "{{$labels.instance}}: MySQL has stop !!!"      value: "{{$value}}"      alertname: "MySQL数据库停止运行"      description: "检测MySQL数据库运行状态"      message: 当前数据库实例{{$labels.instance}}已经停止运行，请及时处理  - alert: MySQL Slave IO Thread Status # 告警名称    expr: mysql_slave_status_slave_io_running == 0    for: 5s # 满足告警条件持续时间多久后，才会发送告警    annotations: # 解析项，详细解释告警信息      summary: "{{$labels.instance}}: MySQL Slave IO Thread has stop !!!"      value: "{{$value}}"      alertname: "MySQL主从IO线程停止运行"      description: "检测MySQL主从IO线程运行状态"      message: 当前数据库实例{{$labels.instance}} IO线程已经停止运行，请及时处理  - alert: MySQL Slave SQL Thread Status # 告警名称    expr: mysql_slave_status_slave_sql_running == 0    for: 5s # 满足告警条件持续时间多久后，才会发送告警    annotations: # 解析项，详细解释告警信息      summary: "{{$labels.instance}}: MySQL Slave SQL Thread has stop !!!"      value: "{{$value}}"      alertname: "MySQL主从SQL线程停止运行"      description: "检测MySQL主从SQL线程运行状态"      message: 当前数据库实例{{$labels.instance}} SQL线程已经停止运行，请及时处理  - alert: MySQL Slave Delay Status # 告警名称    expr: mysql_slave_status_sql_delay == 30    for: 5s # 满足告警条件持续时间多久后，才会发送告警    annotations: # 解析项，详细解释告警信息      summary: "{{$labels.instance}}: MySQL Slave Delay has more than 30s !!!"      value: "{{$value}}"      alertname: "MySQL主从延时过大"      description: "检测MySQL主从延时状态"      message: 当前数据库实例{{$labels.instance}} 主从延时状态已经超过30s，请及时处理

global:  scrape_interval:     15s # Set the scrape interval to every 15 seconds. Default is every 1 minute.  evaluation_interval: 15s # Evaluate rules every 15 seconds. The default is every 1 minute.  # scrape_timeout is set to the global default (10s).# Alertmanager configurationalerting:  alertmanagers:  - static_configs:    - targets: ['localhost:9093']      # - localhost:9093# Load rules once and periodically evaluate them according to the global 'evaluation_interval'.rule_files:  - 'rules/*.yml'  # - "first_rules.yml"  # - "second_rules.yml"# A scrape configuration containing exactly one endpoint to scrape:# Here it's Prometheus itself.scrape_configs:  # The job name is added as a label `job=<job_name>` to any timeseries scraped from this config.  - job_name: 'prometheus'    # metrics_path defaults to '/metrics'    # scheme defaults to 'http'.    static_configs:    - targets: ['localhost:9100']