Check patentability & draft patents in minutes with Patsnap Eureka AI!

Method, device and system for synchronizing master database and secondary database

A master database and database technology, applied in the database field, can solve the problems of low synchronization efficiency and affect the performance of master and slave databases, and achieve the effects of high synchronization efficiency, low pressure and small data volume.

Active Publication Date: 2017-01-25
BEIJING QIHOO TECH CO LTD +1
View PDF5 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For example, due to network jitter between the master-slave database, the current load of the master database or the slave database is too high, etc., the synchronization efficiency may be too low, which seriously affects the performance of the master-slave database

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, device and system for synchronizing master database and secondary database
  • Method, device and system for synchronizing master database and secondary database
  • Method, device and system for synchronizing master database and secondary database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0059] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0060] figure 1 A schematic flow diagram showing a method for synchronizing master-slave databases according to an embodiment of the present invention, as figure 1 As shown, the method includes:

[0061] Step S110, receiving the operation log synchronization point sent from the database.

[0062] The addition, deletion, and modification operations of the master database and the slave database are usually the same, which can ensur...

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, a device and a system for synchronizing a master databaseand a secondary database. The method for synchronizing the master databaseand the secondary database comprises the following steps: receiving an operation log synchronization point sent from the database; when an operation log corresponding to the operation log synchronization point is found in an operation log file of the master database, sending the operation log in the operation log file of the master database to the secondary database, wherein the operation log dates from the operation log synchronization point; according to the received operation log in the operation log file of the master database, allowing the secondary database to conduct a corresponding data operation so as to synchronize the data of the master databaseand the secondary database, and if the operation log corresponding to the operation log synchronization point can not be found in the operation log file of the master database, synchronizing all data of the master database with that of the secondary database. The invention provides the method for synchronizing the master databaseand the secondary database, the method has high synchronization efficiency, and the possibility of synchronization failure and the possibility of data loss are effectively reduced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method, device and system for synchronizing master-slave databases. Background technique [0002] The master-slave architecture (Master / Slave) of the database realizes the separation of database read and write functions. Generally speaking, the master database is responsible for data writing operations, while one or more slave databases are responsible for data query operations. The data in the slave database is obtained by synchronizing with the master database, and the synchronization operation will occupy the resources of the master database and the slave database at the same time, so the synchronization efficiency between the master and slave databases is closely related to the performance of the master and slave databases. [0003] In the prior art, the synchronization of the master-slave database is usually completed spontaneously through the connection between the two,...

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/275
Inventor 吴晓飞
Owner BEIJING QIHOO TECH 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

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com