Method for synchronously verifying and monitoring databases

A synchronous verification and database technology, applied in the computer field, can solve the problems such as flexibility, customizability, operability, scalability and timeliness cannot be effectively guaranteed, and exceptions cannot be specifically notified, so as to reduce the daily workload. Effect

Inactive Publication Date: 2011-11-02
BEIJING FEINNO COMM TECH
View PDF3 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The open source software monitoring method is to monitor the synchronization status of the entire library table. If the data is found to be out of sync, an email will be sent to inform that the current synchronization status is abnormal, but it cannot specifically inform which table in the library is abnormal.
Such a monitoring method cannot be effectively guaranteed in terms of flexibility, customizability, operability, scalability and timeliness

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 for synchronously verifying and monitoring databases
  • Method for synchronously verifying and monitoring databases
  • Method for synchronously verifying and monitoring databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] Hereinafter, the present invention will be described in detail with reference to the drawings and specific embodiments. The following examples are only used to explain the technical solutions of the present invention. Therefore, the technical solution of the present invention should not be limited by this embodiment. The elements used in the following examples should also not be used to limit the technical solution of the present invention.

[0022] figure 2 is a flow chart showing the database synchronization verification and monitoring method according to the present invention.

[0023] Such as figure 2 As shown, the database synchronization verification and monitoring method of the present invention mainly includes the following steps:

[0024] S1: Collect database table information from the main database to be verified and its slave database;

[0025] In this step, database table information is collected from the master database and the slave database, includ...

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 provides a method for synchronously verifying and monitoring databases. The method comprises the following steps of: S1, collecting information of database tables from a master database to be verified and a slave database of the master database, wherein the information of the database tables includes names of the databases, names of the tables and collection times; S2, checking the data consistency between the master database and each slave database by analyzing and comparing the collected information of the database tables; and S3, according to a checking result, judging whether data non-synchronization exists; and, according to a judgement result, selectively triggering Web alarm or mail/message notification. According to the method, a plurality of databases and a plurality of data tables can be synchronously and simultaneously verified; the data synchronous states of the tables can be located accurately in time; and database maintainers can be notified in time.

Description

technical field [0001] The present invention relates to the field of computer technology, and more specifically, relates to verification and monitoring of databases. Background technique [0002] The database is the core part of a system or website, and the monitoring of the database is essential. However, with the increasing amount of data in the database, existing systems and websites usually adopt read-write separation and multi-master and multi-slave methods to achieve high availability. For example, figure 1 A set of application databases shown includes a master (Master) database and one or more slave (Slave) databases. When performing write or update operations on the database, the write update is performed through the master (Master) database, and after the data is written to the master (Master) database, the data will be synchronized to another one or more slaves ( Slave) library; when performing a read operation on the database, it is the data in these slave (Sla...

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
Inventor 刘奇许荟
Owner BEIJING FEINNO COMM TECH
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