Data synchronization method and system

A data synchronization and database technology, applied in the computer field, can solve problems such as long time consumption, resource waste, and failure to provide external services during copying, and achieve the effect of shortening synchronization time and improving synchronization efficiency

Pending Publication Date: 2019-07-16
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF5 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the process of implementing the concept of the present invention, the inventors found that there are at least the following problems in the prior art. When the amount of data is large, the full copy takes a long time and cannot provide external services during the copy period.
When replacing the master database, multiple slave databases belonging to the same system must be fully replicated, resulting in waste of resources

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
  • Data synchronization method and system
  • Data synchronization method and system
  • Data synchronization method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] Hereinafter, embodiments of the present disclosure will be described with reference to the drawings. It should be understood, however, that these descriptions are exemplary only, 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 of the present disclosure.

[0030] The terminology used herein is for the purpose of describing particular embodiments only, and is not intended to be limiting of the present disclosure. The words "a", "an" and "the" used herein shall also include the meanings of "plurality" and "multiple", unless the context clearly indicates otherwise. In addition, the terms "comprising", "comprising", etc. used herein indicate the existence of stated features, steps, operations and / or components, but do not exclude the existence or addition of one or more other features, steps, operations or comp...

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 data synchronization method, which is applied to a database system with a master database and a slave database architecture, and comprises the following steps of: obtaining anoperation command for the master database; generating a log, wherein the log comprises the write operation command and a corresponding log serial number; storing the log in a first log queue; obtaining a corresponding log from the first log queue according to a current to-be-synchronized log sequence number of a slave database, wherein the slave database sequentially realizes data synchronizationwith the master database according to the sequence of the log serial numbers, and the current to-be-synchronized log serial number is used for indicating the next log to be synchronized of the slavedatabase; and analyzing the obtained log, and executing an operation command corresponding to the log on the slave database.

Description

technical field [0001] The present disclosure relates to the field of computer technology, and more specifically, to a data synchronization method and a data synchronization system. Background technique [0002] With the rapid development of computer technology, the amount of data stored in the database is increasing. In the case where the database server has a master-slave deployment architecture, the data in the master database and the slave database should be consistent. [0003] In the prior art, methods such as full replication or incremental replication are usually used to realize data synchronization between the master and slave databases. For example, when the master database is replaced or the synchronization log of the slave database has exceeded the log range of the master database, the full copy method is adopted; when the disconnection time of the master-slave database is short, the data volume update is small, and the synchronization log of the slave database ...

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): G06F16/18G06F16/27
CPCG06F16/1815G06F16/27
Inventor 李强廖耀华
Owner BEIJING JINGDONG SHANGKE 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