Master database standby database and data consistency testing and repairing method and device of master database and standby database

A primary database and detection method technology, applied in the field of database replication system stability, can solve problems such as no provision, lack of data consistency detection, repair function, lack of data comparison methods for primary and secondary databases, etc., and achieve the effect of improving data quality

Inactive Publication Date: 2014-10-22
ZTE CORP
View PDF5 Cites 42 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the process of realizing the present invention, the inventor found that the existing replication technology does not provide any effective measures to detect and repair the consistency of the primary and backup data, and at least there are the following disadvantages: the current mainstream database manufacturers provide database replication technology, However, there is a lack of data consistency detection, repair functions or products; in the field of telecom business database application software, the master-standby database replication system implemented by application software lacks a fast and effective master-standby database data comparison method, and the master-standby database cannot be found online Inconsistency, when a data conflict occurs, the inconsistent data cannot be repaired in time, resulting in a decrease in the stability of the replication system

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
  • Master database standby database and data consistency testing and repairing method and device of master database and standby database
  • Master database standby database and data consistency testing and repairing method and device of master database and standby database
  • Master database standby database and data consistency testing and repairing method and device of master database and standby database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0080] In order to better understand the present invention, several concepts are described below first:

[0081] Primary database: Also called the source database, it refers to the relational database that stores the copied data before copying. In the field of telecommunication business database application software, the master database is a physical database, which mainly stores configuration data. Configuration data includes: system configuration attributes, including information such as user name, ID number, mobile phone number, and area code to which the number belongs. The configuration data is mainly managed by the administrator on the web page. The main database in this embodiment may include an instruction receiving module and a data sending module, the instruction receiving module is used to receive the file export instruction sent by the data consistency detection device of the main and standby databases, and is used to notify the data sending module after receiving...

Embodiment 2

[0116] The above-mentioned embodiment 1 illustrates the present invention through the data consistency detection device of the active and standby databases and the data consistency repairing device of the active and standby databases. The present invention will be further described below in conjunction with the specific method flow as an example, so as to better understand the present invention .

[0117] See Figure 8 As shown, the process of data consistency detection of the primary and secondary databases includes the following steps:

[0118] Step 81: Export the primary file to be detected from the primary database; and export the standby file corresponding to the primary file from the standby database;

[0119] Step 82: Compare the master file with the backup file, and judge the consistency between the master file and the backup file according to the comparison result.

[0120] the above image 3 A schematic diagram of the file format of the primary file and the standb...

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

Disclosed are active and standby databases, consistency checking and recovering methods and apparatuses, and a storage medium. The consistency checking method comprises: sending a file exporting instruction to an active database, and exporting a to-be-checked active file from the active database; sending a file exporting instruction to a standby database, and exporting, from the standby database, a standby file corresponding to the active file; and comparing the active file with the standby file, to determine consistency between the active file and the standby file according to a comparison result.

Description

technical field [0001] The invention relates to the application field of telecommunication service databases, in particular to a technique for improving the stability of a database replication system by detecting and repairing the data consistency of the primary and backup databases during the database replication process. Background technique [0002] In the software industry, the database is used as the storage center, and various database applications are carried out on the database. In the telecommunications business database software industry, people have higher and higher requirements for databases. On the one hand, it is necessary to provide 7×24 hours of uninterrupted service in normal times to ensure the integrity of key data; on the other hand, when the data of the master database is damaged in a disaster, it is necessary to quickly restore the database without losing or less data loss , to ensure business continuity. For this reason, people have invented the dat...

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/215G06F11/1469G06F16/27
Inventor 谢东喻红宇
Owner ZTE CORP
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