Automatic monitoring system of database performance based on salt

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

Active Publication Date: 2018-05-08
杭州铭师堂数字科技有限公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Automatic monitoring system of database performance based on salt
  • Automatic monitoring system of database performance based on salt

Examples

Experimental program
Comparison scheme
Effect test

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

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F11/30
CPCG06F11/3006G06F11/302
Inventor 顾伟涛
Owner 杭州铭师堂数字科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products