Salt-based database error log monitoring system

A monitoring system and database technology, applied in the field of database monitoring, can solve the problems of high maintenance cost, low efficiency, and many manpower, and achieve the effect of low maintenance cost, high accuracy, and simple method

Active Publication Date: 2017-10-10
杭州铭师堂数字科技有限公司
View PDF3 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] (1) High maintenance cost: the operation steps are complicated, more manpower is required, and the maintenance cost is relatively high
[0005] (2) Lack of automation: almost all manual operations are required, lack of automation, and low efficiency
[0006] (3) The monitoring scheme is complex: every time monitoring is added, a large number of useless alarms will be generated, and the adding operation is very complicated and lacks simplicity

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
  • Salt-based database error log monitoring system
  • Salt-based database error log monitoring system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] figure 1 It is an overall architecture diagram of the salt-based database error log monitoring system of the present invention. Overall, it includes four parts: salt server, database node, Zabbix server and storage node. The Salt server obtains the database processes of all database nodes through the salt client, parses the database port according to the database process, and then calls the Zabbix server interface to automatically register the database host. According to the database process, it periodically cuts the error log and collects errors log, analyze the corresponding error log of each database process on the salt management terminal, obtain the monitoring data, send the monitoring data to the Zabbix server, and finally, the salt management terminal sends the error log to the salt client on the storage node Storage nodes.

[0042] figure 2 It is a flow chart of each module of the present invention calling each other. First, call the salt management module,...

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 database error log monitoring system. The system comprises a salt management end, database nodes, storage nodes and a zabbix server, wherein the salt management end is used for managing salt clients, distributing instructions and files, obtaining database process information on the database nodes and acquiring monitoring data; the database nodes are servers for deploying database services, and are used for periodically segmenting error logs and sending the error logs to the salt management end; the storage nodes are used for storing the error logs; the salt management end is further used for sending all the database error logs of all the database nodes to the storage nodes through the salt clints after collecting all the database error logs; and the zabbix server is used for receiving the monitoring data, carrying out warning according to a warning strategy and displaying a tendency chart of the monitoring data. The system is simple in monitoring deployment, low in maintenance cost and high in correctness, and supports various types of databases.

Description

technical field [0001] The invention belongs to the field of database monitoring and is mainly applied to various types of database monitoring 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. Conventional function monitoring cannot fully discover database faults. Therefore, it is necessary to monitor database error logs to detect database problems in time and ensure database service quality. [0003] The shortcoming of existing database monitoring system and method is: [0004] (1) High maintenance cost: the operation steps are complicated, more manpower is required, and the maintenance cost is relatively high [0005] (2) Lack of automation: almost all manual operations are required, lack of automation, and low efficiency [0006] (3) The monitoring scheme is complex: every time monitoring ...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/1734
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap