A method and system for passive data synchronization

A data synchronization and passive technology, applied in the direction of structured data retrieval, database distribution/replication, etc., can solve the problems of poor scalability, multi-server resources, occupancy, etc., and achieve the effects of strong scalability, simplified functions, and reduced impact

Active Publication Date: 2019-02-15
WUHAN DAMENG DATABASE
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The purpose of the present invention is to overcome the above-mentioned technical deficiencies, provide a passive data synchronization method and system, and solve the technical problems in the prior art that when one-to-many data synchronization takes up more server resources and the scalability is not strong

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
  • A method and system for passive data synchronization
  • A method and system for passive data synchronization
  • A method and system for passive data synchronization

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0024] like figure 1 As shown, Embodiment 1 of the present invention provides a passive data synchronization method, including the following steps:

[0025] Step S1, the master database parses the transaction log to obtain the incremental data to be synchronized, and sends the incremental data to the intermediate server;

[0026] Step S2, the intermediate server caches the incremental data;

[0027] Step S3, the terminal database sends an acquisition request to the intermediate server to acquire unsynchronized incremental data according to the fact that it has synchronized incremental data;

[0028] Step S4, the intermediate server sends corresponding incremental data to the terminal database according to the acquisition request.

[0029] The present invention sets up an intermediate server, the main database sends the incremental database to be synchronized to the intermediate server cache, and the intermediate server is responsible for sending the incremental data to each ...

Embodiment 2

[0047] like image 3 As shown, Embodiment 2 of the present invention provides a passive data synchronization system, including a main synchronization module 1, an intermediate synchronization module 2 and a terminal synchronization module 3;

[0048] The main synchronization module 1 is used to analyze the transaction log to obtain incremental data to be synchronized, and send the incremental data to the intermediate synchronization module 2;

[0049] The intermediate synchronization module 2 is used to cache the incremental data;

[0050] The terminal synchronization module 3 is used to send an acquisition request to the intermediate synchronization module 2 to obtain unsynchronized incremental data according to the situation of its own synchronized incremental data;

[0051] The intermediate synchronization module 2 is configured to send corresponding incremental data to the terminal synchronization module 3 according to the acquisition request.

[0052] Active data synchr...

Embodiment 3

[0060] Embodiment 3 of the present invention provides a computer storage medium on which a computer program is stored. When the computer program is executed by a processor, the passive data synchronization method described in any of the above embodiments is implemented.

[0061] The computer storage medium provided by the present invention is used to implement the above-mentioned passive data synchronization method. Therefore, the technical effects of the above-mentioned passive data synchronization method are also provided by the computer storage medium, and will not be repeated here.

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 passive data synchronization method, comprising the following steps: step S1, a master database analyzes a transaction log to obtain incremental data to be synchronized, andsends the incremental data to an intermediate server; step S2, the master database analyzes the transaction log to obtain incremental data to be synchronized; step S1, the master database analyzes thetransaction log to obtain incremental data to be synchronized, and sends the incremental data to an intermediate server; step S1, the master database analyzes the transaction log to obtain incremental data to be synchronized. 2, that intermediate serv caches the incremental data; 3, that terminal database sends an acquisition request to the intermediate serv to acquire the unsynchronized incremental data according to the synchronized incremental data of the terminal database; Step S4, the intermediate server sends corresponding incremental data to the terminal database according to the acquisition request. The invention can minimize the resource occupancy of the server where the main database is located, and has good system expansibility at the same time.

Description

technical field [0001] The invention relates to the technical field of database synchronization, in particular to a passive data synchronization method and system. Background technique [0002] With the development of science and technology, data synchronization between databases has been used more and more. In many complex systems, the data of multiple databases all comes from the same database, a typical application scenario of one-to-many data synchronization. For example, in a system with one master and multiple backups, in order to ensure data security and business continuity, it is necessary to make multiple backups of the data of the master node database. When the master node database is abnormal, one of the slave node databases can replace the master node database. Work. Another example is a multi-terminal system. In this system, the central database and the terminal database are not on the same server, and application systems are deployed on both the central databa...

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): G06F16/27
Inventor 付铨孙峰刘启春杨春
Owner WUHAN DAMENG DATABASE
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