Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A data synchronization method and a data synchronization device

A data synchronization and database technology, applied in the direction of structured data retrieval, database distribution/replication, etc., can solve problems affecting the efficiency of synchronization, transaction loss, increase the amount of data processed by synchronization log data, etc., to reduce the amount of data processing, The effect of improving efficiency

Active Publication Date: 2019-01-18
WUHAN DAMENG DATABASE
View PDF6 Cites 27 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although this method can avoid the problem of transaction loss after synchronization is enabled for active transactions, there are often uncommitted transactions (active transactions) for a long time in real application systems, so this waiting time is uncontrollable
[0006] Therefore, in the existing backup-based data synchronization method, due to the existence of active transactions, it is necessary to confirm the reservation of the active transaction log, and it is necessary to wait for the active transaction to be submitted before generating a backup file, and this waiting time is uncontrollable; and Increased the amount of data processed by synchronous log data, affecting the efficiency of synchronization

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 data synchronization method and a data synchronization device
  • A data synchronization method and a data synchronization device
  • A data synchronization method and a data synchronization device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0065] See figure 2 The method of data synchronization in this embodiment is specifically described. Among them, the data synchronization method of this embodiment explains the data synchronization method of the present invention from the perspective of the source database. The data synchronization method includes the following steps:

[0066] Step 10: The source synchronization tool obtains the backup file generated by the source database.

[0067] Among them, the source database includes either DM6 database or DM7 database, which can be selected according to actual conditions.

[0068] In actual application scenarios, the source database generates database backup files according to the online backup command. Because during the backup process, the source database will still have transactions, the source database also obtains the transaction log corresponding to the backup start time to the backup completion time , Where the transaction log includes the active transaction log and ...

Embodiment 2

[0084] See image 3 The method of data synchronization in this embodiment is specifically described. Among them, the data synchronization method of this embodiment explains the data synchronization method of the present invention from the perspective of the destination database. The method for database synchronization in this embodiment includes the following steps:

[0085] Step 20: The destination synchronization tool receives the backup file sent by the source synchronization tool, and obtains the reference database and the active transaction log according to the backup file.

[0086] In this embodiment, the destination synchronization tool receives the backup file sent by the source synchronization tool, and obtains the reference database according to the backup file. Wherein, the backup file includes a data file and a transaction log corresponding to the source database from the start of the backup to the completion of the backup. The transaction log includes an active transa...

Embodiment 3

[0119] See Image 6 , Image 6 It is a schematic structural diagram of a data synchronization device provided by an embodiment of the present invention. The data synchronization device of this embodiment includes one or more processors 61 and a memory 62. among them, Image 6 Take a processor 61 as an example.

[0120] The processor 61 and the memory 62 may be connected by a bus or other means, Image 6 Take the bus connection as an example.

[0121] The memory 62, as a non-volatile computer-readable storage medium based on data synchronization, can be used to store non-volatile software programs, non-volatile computer-executable programs and modules, such as the data synchronization method in Embodiment 1. And the corresponding program instructions. The processor 61 executes various functional applications and data processing of the data synchronization method by running the non-volatile software programs, instructions, and modules stored in the memory 62 to implement the data s...

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 relates to the technical field of database synchronization, and provides a data synchronization method and a data synchronization device. The data synchronization method comprises the following steps: obtaining a backup file generated by a source database by a source synchronization tool; Sending the backup file to the destination synchronization tool so that the destination synchronization tool can restore the reference database and the active transaction log according to the backup file; Obtaining the maximum log sequence number corresponding to the source database at the backup completion time; reading the operation log whose log sequence number is larger than the maximum log sequence number in the log file of the source database, and sending the operation log to the destination synchronization tool, so that the destination synchronization tool synchronizes data on the destination database according to the reference database, the active transaction log and the operation log. The data synchronization method of the invention does not need to perform a rollback operation on the active transaction, and the data processing amount is reduced. At the same time, there isno need to limit the transaction commit time and the backup start time, which can effectively improve the efficiency of synchronization.

Description

【Technical Field】 [0001] The invention relates to the technical field of database synchronization, in particular to a data synchronization method and a data synchronization device. 【Background technique】 [0002] Real-time synchronization of database data is a technical solution to improve the availability of information systems and ensure business continuity. Through real-time data synchronization, the business data of the destination database and the source database remain consistent in real time. When the source database fails and interrupts the service, the application system can quickly switch to the destination database to ensure business continuity requirements. [0003] At present, real-time data synchronization based on database log analysis is a commonly used real-time data synchronization technology. This technology obtains data additions, deletions and changes by analyzing the online log or archive log of the source database, and then converts these changes into a spec...

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 Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products