Shulou(Shulou.com)06/01 Report--

This article will explain in detail how DBA controls Open-Falcon. The content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

What is Open-Falcon? A well-functioning company can not be separated from operation and maintenance, and operation and maintenance can not be separated from monitoring tools. A gentleman is good at things, and an excellent monitoring tool can make the operation and maintenance get twice the result with half the effort. Open-Falcon from Xiaomi is such an excellent monitoring tool, which has the features that other monitoring tools such as zabbix and nagios do not have: 1. Flexible deployment, flexible interface, flexible alarm settings 1) flexible deployment, expandable components, and high availability of the whole system; 2) flexible interface, custom development collect; 3) flexible alarm settings, support callback, support humanized alarm; support Screen, multi-indicator aggregation display, support Dashboard, high query efficiency of historical data. two。 The single machine has high utilization rate, can support 2 million storage and reporting per second, and can support very large-scale monitoring. Judging from these features, Open-Falcon is very suitable for our company. Of course, offline practice and testing are essential before we confirm the use of Open-Falcon. When testing Open-Falcon, the DBA team found that the collection of DB monitoring items had the following deficiencies: 1. Monitoring item collection of Oracle is not supported. two。 The data collected must be digital, not text, so when monitoring the log, the alarm information cannot feedback the specific alarm content. 3. Mysql has poor support for deploying multiple instances on a stand-alone machine, so you need to maintain the monitoring later after instance migration. How to promote its strengths and avoid its weaknesses? Under the guidance of teacher Han Feng, I used python to write the collection tool collector for DB, which is also the third tool written after the sensitive information detection tool and the useless table detection tool since I learned python. It can be realized: 1. Support Oracle&Mysql monitoring item collection. two。 Use tag to return log ERROR information. 3. The indicators of all instances of the machine are collected separately, and one-click maintenance can be achieved after instance migration or role change. (4) centralized configuration of collection items, easy to maintain in batch. Through this tool, we can fully meet the requirements for the collection of DB monitoring items, but we have stepped on several more holes in the process of subsequent test and alarm, and I will mention only one of them here: because the Open-Falcon collection items do not support returning text results, I think of using tag to return log ERROR information. However, this method will cause the problem that the alarm item cannot be cleared automatically in the alarm list after the alarm. Of course, this problem is finally solved: use the tornado framework to configure an independent external service, modify the alarm component in Open-Falcon, and add a set0 button to its web page. Clicking this button will transfer the collected item information to the tornado external service, and the external service will set the alarm to no, and the alarm item will be cleared in the alarm list. So much for sharing about how DBA controls Open-Falcon. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.