夜莺-Nightingale
夜莺V6
项目介绍 架构介绍
快速开始 快速开始
黄埔营
安装部署 安装部署
升级
采集器 采集器
使用手册 使用手册
API API
数据库表结构 数据库表结构
FAQ FAQ
开源生态
Prometheus
版权声明
第1章:天降奇兵 第1章:天降奇兵
第2章:探索PromQL 第2章:探索PromQL
第3章:Prometheus告警处理 第3章:Prometheus告警处理
第4章:Exporter详解 第4章:Exporter详解
第5章:数据与可视化 第5章:数据与可视化
第6章:集群与高可用 第6章:集群与高可用
第7章:Prometheus服务发现 第7章:Prometheus服务发现
第8章:监控Kubernetes 第8章:监控Kubernetes
第9章:Prometheus Operator 第9章:Prometheus Operator
参考资料

MySQL Data Source Configuration Fields

There are many ways to install MySQL available online, so this document will not cover those in detail. Instead, it will directly introduce how to connect MySQL as a data source.

In Data Integration — Select Time Series Data Source — Select MySQL

mysql001

MySQL configuration only requires configuring the connection address, username, password, and associating with the alert engine.

mysql002

Query Data

In Time Series Metrics - Instant Query, select the data source type MySQL, enter the SQL statement in the query conditions, and the corresponding results will be queried. Click the prompt icon next to the query conditions to view the MySQL documentation.

mysql003

Configure Alerts

To configure alert rules, add a new alert rule. The core configuration parameters are introduced below.

mysql004

Data Source Type: Select MySQL;

Data Source: Select the configured MySQL data source;

Query Condition: The query alert statement, similar to the role of the PromQL expression;

Value Field: The core required field, SQL query results usually contain multiple columns, you can specify which column values are displayed on the chart as curves.

Alert Conditions:

Set the threshold for the alert query condition to trigger.

Simple Mode

The result of the query statement is stored in $A, and the threshold is set using $A. As shown below, the final trigger threshold uses $A > 10.

mysql005

mysql006

Expression Mode

The result of the query statement is stored in $A, and the threshold is set using $A.robin. As shown below, the final trigger threshold uses $A.robin > 10.

mysql007

mysql008

Configure Dashboard

mysql009

In the monitoring dashboard, you can use the MySQL data source to configure the dashboard. It is recommended to display the dashboard as disconnected indicator values and table types. Below is a basic configuration of a dashboard with core attention points marked in red.

mysql010

快猫星云 联系方式 快猫星云 联系方式
快猫星云 联系方式
快猫星云 联系方式
快猫星云 联系方式
快猫星云
OpenSource
开源版
Flashcat
Flashcat
FlashDuty
Flashduty