Automatic monitoring system of database performance based on salt

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.

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...

AI Technical Summary

Problems solved by technology

[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 suitable for large-scale database monitoring: In the case of large-scale databases, it is almost difficult to meet the monitoring requirements with existing monitoring methods;

[0007] (4) Single function: The existing monitoring scheme has a single function

Images