Supercharge Your Innovation With Domain-Expert AI Agents!

Mysql master-slave synchronization state monitoring and alarming method and system

A synchronization state, master-slave technology, applied in hardware monitoring, instrumentation, error detection/correction, etc., can solve the problems of state monitoring that cannot realize database master-slave synchronization, consume large hardware resources, and insufficient resources, etc., to reduce redundancy The effect of reducing expenditure, improving efficiency, and not consuming hardware resources

Pending Publication Date: 2022-05-27
XIAN THERMAL POWER RES INST CO LTD +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Traditional monitoring is more about the monitoring of a single indicator of the system or application, and the monitoring of the database is more about monitoring the performance of the system, which cannot realize the status monitoring of the database master-slave synchronization
At the same time, traditional monitoring solutions are generally implemented through monitoring software, which consumes a lot of hardware resources. For some environments where resources are not sufficient, it is undoubtedly a huge burden

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
  • Mysql master-slave synchronization state monitoring and alarming method and system
  • Mysql master-slave synchronization state monitoring and alarming method and system
  • Mysql master-slave synchronization state monitoring and alarming method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to make those skilled in the art better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only The embodiments are part of the present invention, not all of the embodiments, and are not intended to limit the scope of the present disclosure. Also, in the following description, descriptions of well-known structures and techniques are omitted to avoid unnecessarily obscuring the concepts disclosed in the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0024] The accompanying drawings show a schematic structural diagram of an embodiment accor...

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 mysql master-slave synchronization state monitoring and alarming method and system, and the method comprises the steps: triggering a shell script through a timed task, and detecting the master-slave synchronization state of mysql; when the master-slave synchronization state of the mysql is abnormal, abnormal information is sent to the enterprise WeChat server, the method and system can monitor the master-slave synchronization state of the mysql, and meanwhile hardware resources are not consumed.

Description

technical field [0001] The invention relates to a monitoring and alarming method and system, in particular to a MySQL master-slave synchronization state monitoring and alarming method and system. Background technique [0002] Based on the consideration of data security and system performance, more and more systems adopt the database master-slave scheme to achieve high availability of system data. How to monitor the master-slave synchronization status of the database has become a top priority. The traditional monitoring is more about monitoring a single indicator of the system or application, and the monitoring of the database is more about monitoring the performance of the system, which cannot realize the status monitoring of the master-slave synchronization of the database. At the same time, traditional monitoring solutions are generally implemented through monitoring software, which consumes a lot of hardware resources, which is undoubtedly a huge burden for some environme...

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
IPC IPC(8): G06F11/30G06F11/32
CPCG06F11/302G06F11/3051G06F11/327
Inventor 顾永全赵轩王涛祁周腾
Owner XIAN THERMAL POWER RES INST CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More