Salt-based automatic database performance monitoring system

An automatic monitoring and database technology, applied in the field of database monitoring, can solve the problems of single function, many operation steps, high maintenance cost, and achieve the effect of accurate performance monitoring, expansion and feasibility, and low maintenance cost.

CN107239379AActive Publication Date: 2017-10-10杭州铭师堂数字科技有限公司
5 Cites 4 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
Publication Date
2017-10-10

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
Patent Text Reader

Abstract

The invention discloses a salt-based automatic database performance monitoring system. The system is characterized by monitoring database performance through acquiring cpu data corresponding to a database service process; the system comprises a salt management end, database nodes and a zabbix server; the salt management end is used for acquiring cpu information of database service processes on the database nodes through salt clients, and sending the cpu information to the zabbix server; the database nodes are servers for deploying database services; one salt client is deployed on each database node; the database nodes are used for calling acquisition scripts on the nodes according to parameters transmitted from the salt management end so as to acquire performance monitoring data; and the zabbix sever is used for receiving monitoring data, carrying out warning according to a warning strategy and displaying a tendency chart of the monitoring data. The system disclosed by the invention is capable of realizing the automatic monitoring of database performance, and is basically free of labor cost, strong in universality and convenient to user.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention belongs to the field of database monitoring and is mainly applied to the performance monitoring of various types of databases in the Internet industry. Background technique

[0002] For Internet companies, database applications are becoming more and more popular. In order to improve database availability, it is necessary to deploy monitoring for databases. In addition to conventional function monitoring, it is also necessary to monitor database performance, so as to improve monitoring accuracy, detect database performance problems in time, and ensure Database service quality.

[0003] The shortcoming of existing database monitoring system and method is:

[0004] (1) Complicated operation and high maintenance cost: many operation steps require a lot of manpower for maintenance and high maintenance cost;

[0005] (2) Low degree of automation: almost all require manual operation, lack of automation, and low efficiency;

[0006] (3) Not su...

Examples

Embodiment Construction

[0034] figure 1 It is an overall architecture diagram of the salt-based database performance automatic monitoring system of the present invention. It generally includes three parts: salt management end, database node and zabbix server end, each database node deploys a salt client. The salt management terminal obtains all database processes through the salt client, and then calls the zabbix server interface to register the database host. Next, the salt management terminal collects the monitoring data corresponding to each database process on the database node through the salt client, and finally sends the The above monitoring data is sent to the zabbix server.

[0035] figure 2 It is a flow chart of each module of the present invention calling each other. First, the salt management module registers the salt client corresponding to all database nodes, and then obtains the database processes on all database nodes through the salt client, and analyzes the database process numb...