Use the open source real-time monitoring tool HertzBeat to monitor and alarm the Mysql database, and it will be done in 5 minutes!
Mysql database introduction
MySQL is an open source relational database management system developed by the Swedish company MySQL AB and a product of Oracle. MySQL is one of the most popular open source relational database management systems. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System, relational database management system) application software.
Introduction to HertzBeat
HertzBeat is an open source, easy-to-use and friendly real-time monitoring tool that does not require Agent and has powerful custom monitoring capabilities.
- Integrate monitoring-alarm-notification, support monitoring of application services, databases, operating systems, middleware, cloud native, etc., threshold alarms, alarm notifications (email WeChat Dingding Feishu SMS Slack Discord Telegram).
- It configurable protocol specifications such as Http, Jmx, Ssh, Snmp, Jdbc, Prometheus, etc. You only need to configure YML to use these protocols to customize and collect any metrics you want to collect. Do you believe that you can immediately adapt to a new monitoring type such as K8s or Docker just by configuring YML?
- HertzBeat's powerful customization, multi-type support, easy expansion, and low coupling, hope to help developers and small and medium teams quickly build their own monitoring tools.
Get the Mysql database monitoring in HertzBeat in 5 minutes
The premise of the operation is that you already have the Mysql environment and the HertzBeat environment.
Add monitoring of Mysql database on the open source monitoring tool HertzBeat monitoring page
- Click Add Mysql Monitoring
Path: Menu -> Database Monitoring -> Mysql Database -> Add Mysql Database Monitoring
- Configure the parameters required for the new monitoring Mysql database
On the monitoring page, fill in Mysql service IP, monitoring port (default 3306), account password, etc., and finally click OK to add. For other parameters such as collection interval, timeout period, etc., please refer to Help Documentation https://hertzbeat.com/docs/help /mysql/
- Complete ✅, now we have added the monitoring of the Mysql database, check the monitoring list to see our added items.
- Click Operation->Monitoring Details Icon of the monitoring list item to browse the real-time monitoring metric data of the Mysql database.
- Click Monitoring History Details TAB to browse the historical monitoring metric data chart of Mysql database📈.
DONE! Done! Through the above steps, in fact, it only takes one step to sum up
- On the HertzBeat monitoring page, configure the IP port account password and add Mysql monitoring
Through the above two steps, we have completed the monitoring of the Mysql database. We can view the monitoring details and metrics in HertzBeat at any time to observe its service status. Of course, just looking at it is definitely not perfect. Monitoring is often accompanied by alarm thresholds. When the metrics of the Mysql database exceed our expectations or are abnormal, we can promptly notify our corresponding person in charge. The person in charge receives the notification and handles the problem. It is a complete monitoring and alarm process.
Next, we will demonstrate step by step how to configure the threshold alarm notification in the HertzBeat system, so that when the metrics of the Mysql database are found to be abnormal, they will be notified to us in time
3. Add Mysql database index threshold alarm in HertzBeat system
- Configure an alarm threshold for an important metric
Path: Menu -> Threshold Rules -> Add Threshold
- Select the configured metric object. Mysql database monitoring is mainly about database performance and other related metrics. For example, we set the threshold for the metric
query cache hit ratecache->query_cache_hit_rate. When the query cache hit rate of Mysql is very low An alarm is issued when it is less than 30%. - Here we configure to send an alarm when the
query_cache_hit_rate<30of this metriccache, the alarm level is serious alarm, and it will be triggered after three times, as shown in the figure below.
- Add message notification recipients
Configure the receiver to let the alarm message know who to send and how to send it.
Path: Menu -> Alarm Notification -> Alarm Recipient -> Add New Recipient
Message notification methods support email, DingTalk, WeChat Work, Feishu, WebHook, SMS, etc. Here we take the commonly used DingTalk as an example.
- Refer to this Help Documentation https://hertzbeat.com/docs/help/alert_dingtalk to configure the robot on DingTalk and set the security custom keyword
HertzBeat, get the correspondingaccess_tokenvalue. - Configure the receiver parameters in HertzBeat as follows.
【Alarm Notification】->【New Recipient】->【Select DingTalk Robot Notification Method】->【Set DingTalk Robot ACCESS_TOKEN】->【OK】
- Configure the associated alarm notification strategy ⚠️ [Add notification strategy] -> [Associate the recipient just set] -> [OK]
Configure the alarm notification policy to bind the alarm message with the receiver, so that you can decide which alarms to send to whom.
Finished, now wait for the warning message to come. ding ding ding ding
[HertzBeat warning notification]
Alarm target object: mysql.cahce.query_cache_hit_rate
Affiliated monitoring ID: 205540620394932
Belonging monitoring name: Mysql_localhost
Alarm level: major alarm
Alarm trigger time: 2023-02-11 21:13:44
Content details: mysql db query_cache_hit_rate is too low, now is 20.
Summary
This practical article took us to experience how to use the open source real-time monitoring tool HertzBeat to monitor Mysql database metric data. We can find that HertzBeat, which integrates monitoring-alarm-notification, is more convenient in operation and use, just click on the page The Mysql database can be included in the monitoring and alarm notification, and the tedious operations of deploying multiple components and writing configuration files are no longer needed.
Mysql Github: https://github.com/mysql/mysql-server
HertzBeat Github: https://github.com/apache/hertzbeat
Welcome to learn, use and star!
Only one docker command is needed to install and experience heartbeat:
docker run -d -p 1157:1157 --name hertzbeat apache/hertzbeat