Method and device for monitoring master-slave synchronization state of database

A technology for synchronizing state and database, applied in the field of database, can solve the problem of low efficiency of database master-slave synchronization state monitoring, and achieve the effect of improving monitoring efficiency

Inactive Publication Date: 2017-06-13
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to provide a method and device for monitoring the state of master-slave synchronization of the database, the purpose of which is to solve the problem of low efficiency of state monitoring of the master-slave state of the database in the prior art

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
  • Method and device for monitoring master-slave synchronization state of database
  • Method and device for monitoring master-slave synchronization state of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] In order to enable those skilled in the art to better understand the solution of the present invention, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0047] Due to the differences in databases and programming languages ​​used, the way to realize database master-slave synchronization status monitoring will also be different. Therefore, the following will introduce the scenario where the data is MYSQL database and the programming language is Python. Apparently, when the types of databases are different, or the scripting languages ​​used are different, the spe...

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 method for monitoring a master-slave synchronization state of a database. The method comprises the following steps: calling a first programming function and automatically executing a pre-set structured query instruction to obtain an executing result; judging whether the master-slave synchronization state of the database is normal or not according to the executing result. The structured query instruction is automatically executed by utilizing a programming manner, and the master-slave synchronization state of the database is monitored; compared with a manner of manually executing the structured query instruction to monitor the master-slave synchronization state of the database, the structured query instruction is automatically executed, so that the monitoring efficiency of the master-slave synchronization state of the database is relatively high; visibly, the monitoring efficiency of the master-slave synchronization state of the database is easy to improve. Furthermore, the invention also provides a device for monitoring the master-slave synchronization state of the database, and has the advantages corresponding to the method.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for monitoring the master-slave synchronization state of a database. Background technique [0002] With the development and progress of the website business, the number of users and the amount of data are also increasing, which leads to a linear increase in the number of visits to the database. [0003] In order to cope with the increasing number of visits, the database master-slave synchronization architecture is widely used in large-scale website systems. For example, in the MYSQL master-slave synchronization architecture, the MySam engine is responsible for operations such as adding, modifying, and deleting, and the InnoDB engine is responsible for querying. The database master-slave synchronization architecture may refer to the establishment of two master-slave databases, and the information status between the master-slave databases is synchronized. ...

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): G06F11/30G06F11/32G06F17/30
CPCG06F11/30G06F11/327G06F16/27
Inventor 王文庆
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
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