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

A method for ensuring consistency of replication transactions and a corresponding replication device

A consistency and transactional technology, applied in database distribution/replication, redundancy in computing, data error detection, response error generation, etc., can solve the problem of large memory and resource occupation of the submitted transaction table, and achieve shortened memory Effects of resource consumption, reduced size, and reduced recovery time

Active Publication Date: 2019-01-11
WUHAN DAMENG DATABASE
View PDF5 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] The technical problem to be solved by the present invention is that due to the existence of long transactions, a large amount of expired transaction information is stored in the submitted transaction table, which causes the memory of the submitted transaction table to be too large and takes up 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
  • A method for ensuring consistency of replication transactions and a corresponding replication device
  • A method for ensuring consistency of replication transactions and a corresponding replication device
  • A method for ensuring consistency of replication transactions and a corresponding replication device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0056] refer to figure 1 , in this embodiment, the replication system includes a source database 1, a replication device, and a target database 2, and the replication device is respectively connected to the source database 1 and the target database 2, so as to ensure that the source database 1 and the target database are 2 transactions are consistent, and then data synchronization is achieved.

[0057] Specifically, the replication device includes a source replication tool 31 and a target replication tool 32 . Wherein, the source replication tool 31 is connected with the source database 1, and the source replication tool 31 accesses the source database 1 through the source replication process; the target replication tool 32 is connected with the target database 2, and the target replication tool 32 accesses the target database through the target replication process 2. The source copy process and the target copy process interact to copy the data of the source database 1 to the...

Embodiment 2

[0119] see Figure 5 , Figure 5 The replication device is a schematic structural diagram of a replication device provided by an embodiment of the present invention. The replication device in this embodiment includes one or more processors 51 and memory 52 . in, Figure 5 A processor 51 is taken as an example.

[0120] Processor 51 and memory 52 can be connected by bus or other means, Figure 5 Take connection via bus as an example.

[0121] The memory 52, 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 ensuring the consistency of replication transactions in Embodiment 1 Sexual methods and corresponding program instructions. The processor 51 runs the non-volatile software programs, instructions and modules stored in the memory 52, thereby executing various functional applications and data processing of the method for ensuri...

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 method for ensuring the consistency of replication transactions and a corresponding replication device. The method comprises the following steps: obtaining the starting log sequence number of the earliest active transaction in the source database; marking the starting log sequence number of the earliest active transaction as the recovery starting point; obtaining the starting log sequence number of the earliest active transaction in the source database; obtaining the starting log sequence numbers of two adjacent active transactions of the source database, and marking the starting log sequence numbers of the two adjacent active transactions as a range checkpoint when the difference between the starting log sequence numbers of the two adjacent active transactions isgreater than a preset threshold value; obtaining the transaction log of the source database, deleting the transaction log whose log submitting sequence number is not greater than the recovery startingpoint and the transaction log whose log submitting sequence number falls into the checkpoint of the range; performing data recovery based on the recovery start point, range checkpoint, and submittedtransaction records. The invention adopts the range checkpoint mechanism to compress the submitted transaction table, which can effectively reduce the scale of the submitted transaction table.

Description

【Technical field】 [0001] The invention relates to the technical field of database synchronization, in particular to a method for ensuring the consistency of replicated transactions and a corresponding replicated 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 target database and the source database are kept consistent in real time. When the source database fails and interrupts the service, the application system can quickly switch to the target database to ensure business continuity. [0003] The real-time database data replication technology based on log analysis has the characteristics of little impact on the performance and data mode of the source database, supports heterogeneous operating systems and database platforms, and high data replication performance. , data m...

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): G06F11/14G06F16/27
CPCG06F11/1464G06F16/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