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

Distributed memory database data synchronization method and system

A data synchronization and distributed technology, applied in the computer field, can solve the problems affecting the data update of the main database and the standby database, the inability to guarantee strong data consistency, and the impact of data update performance, so as to achieve strong consistency between the main and backup databases, and strong The effect of consistency, improved performance

Active Publication Date: 2018-08-07
北京思特奇信息技术股份有限公司
View PDF8 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] If asynchronous replication is used between the master and backup of the distributed memory database, the consistency of the master and backup data of the distributed memory database can be guaranteed, but the strong consistency of the data cannot be guaranteed at the moment of downtime, and there is a possibility of data differences
If the synchronization mechanism is used, it will have a certain impact on the update performance of the data, and after the main database is normal and the standby database is down, the synchronization mechanism will fail, affecting the data update of the main database and the standby database
And the synchronization mechanism takes up a lot of network resources, and the synchronization mechanism causes the time to complete a transaction to be too long

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
  • Distributed memory database data synchronization method and system
  • Distributed memory database data synchronization method and system
  • Distributed memory database data synchronization method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] The principles and features of the present invention will be described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0049] figure 1 A schematic flowchart of a data synchronization method for a distributed memory database provided by an embodiment of the present invention is given. figure 2 A schematic diagram of signaling interaction of a distributed memory database data synchronization method provided by an embodiment of the present invention is given. Such as figure 1 and 2 As shown, the method includes:

[0050] S110, receiving a transaction submission request sent by the client, and the main library of the distributed memory database records redo log redo according to the transaction submission request;

[0051] S120, the main database sends the redo log redo to the host where the standby database is located through ...

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 a distributed memory database data synchronization method. The method comprises the steps of receiving a transaction submitting request, and recording a redo log according tothe transaction submitting request through a main library; sending the redo log to a host where a standby library is located through a synchronous mode; updating data of the main library of the distributed memory database; receiving confirmation information of the completion of the redo log receiving fed back by the host where the standby library is located through the synchronous mode; generatinga prompt message of completion of the transaction according to the confirmation information, and sending the prompt message to a client; sending the redo log to the host where the standby library islocated by a copy module of the host where the main library is located through an asynchronous mode; loading the redo log sent by the copy module of the host where the main library is located by the standby library, and completing the data update. The method combines the synchronous mode and the asynchronous mode to achieve the situation that complete data of the main library is in the standby library, and achieves strong consistency between the main library and the standby library. The invention further provides a distributed memory database data synchronization system.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a data synchronization method and system for a distributed memory database. Background technique [0002] If asynchronous replication is used between the master and backup of the distributed memory database, the consistency of the master and backup data of the distributed memory database can be guaranteed, but the strong consistency of the data cannot be guaranteed at the moment of downtime, and there is the possibility of data differences. If the synchronization mechanism is adopted, it will have a certain impact on the data update performance, and after the normal standby database of the main database is down, the synchronization mechanism will fail, affecting the data update of the main database and the standby database. Moreover, the synchronization mechanism takes up a large amount of network resources, and the synchronization mechanism causes the time to complete a transa...

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): G06F17/30
CPCG06F16/273G06F16/275
Inventor 邱海港
Owner 北京思特奇信息技术股份有限公司
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com