Unlock instant, AI-driven research and patent intelligence for your innovation.

A data synchronization method and data synchronization device

A data synchronization and database technology, applied in structured data retrieval, database distribution/replication, etc., can solve problems affecting synchronization efficiency, transaction loss, and uncontrollable waiting time, so as to improve efficiency and reduce data processing volume Effect

Active Publication Date: 2021-03-30
WUHAN DAMENG DATABASE
View PDF6 Cites 0 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 long-term uncommitted transactions (active transactions) 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 data synchronization device
  • A data synchronization method and data synchronization device
  • A data synchronization method and data synchronization device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0065] refer to figure 2 The method of data synchronization in this embodiment will be described in detail. Wherein, the data synchronization method in 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] Wherein, the source database includes any one of the DM6 database and the 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. During the backup process, the source database still has transactions, and the source database also obtains the corresponding transaction logs from the backup start time to the backup completion time. , wherein the transaction log includes an active tra...

Embodiment 2

[0084] refer to image 3 The method of data synchronization in this embodiment will be described in detail. Wherein, the data synchronization method in this embodiment explains the data synchronization method of the present invention from the perspective of the destination database. The method for data 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 synchronization tool at the destination end receives the backup file sent by the synchronization tool at the source end, and obtains the reference database according to the backup file. Wherein, the backup file includes the data file and the transaction log corresponding to the source database from the backup start time to the backup completion time, and the transacti...

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 in this embodiment includes one or more processors 61 and a memory 62 . in, Image 6 A processor 61 is taken as an example.

[0120] Processor 61 and memory 62 can be connected by bus or other means, Image 6 Take connection via bus as an example.

[0121] 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 non-volatile software programs, instructions and modules stored in the memory 62, thereby realizing the data synchroni...

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. [0003] Currently, 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 parsing the online logs or archived logs of the source database, and then converts these changes into specific data f...

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 Patents(China)
IPC IPC(8): G06F16/27
Inventor 孙峰赵家威
Owner WUHAN DAMENG DATABASE