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

Primary and backup copying method of memory database and memory database system

A replication method and database technology, which is applied in the field of memory database, can solve the problems such as the decrease of processing efficiency, and achieve the effect of efficient processing and guaranteed consistency

Active Publication Date: 2016-09-28
北京思特奇信息技术股份有限公司
View PDF6 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This ensures data security to a certain extent, but due to the need to wait for the confirmation of the standby database, it will also cause a decrease in processing efficiency

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
  • Primary and backup copying method of memory database and memory database system
  • Primary and backup copying method of memory database and memory database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] Embodiment 1. A method for master / backup replication of an in-memory database. Combine below figure 1 The method provided in this embodiment is described.

[0026] participate figure 1 The method provided in this embodiment includes: S1, when the main library service process in the memory database performs the commit action, sending the REDO log to the standby library replication process in real time, and writing the REDO log to the local REDO log file;

[0027] S2. After the standby database replication process receives the REDO log sent by the main database service process, it immediately writes it to the local semi-synchronous REDO log file;

[0028] S3. The master database replication process scans the change increment of the local REDO log file in real time, and sends the change increment of the REDO log file to the standby database replication process;

[0029] S4. The standby database replication process writes the change increment of the received REDO log file into the ...

Embodiment 2

[0045] Embodiment 2. An in-memory database system. Combine below figure 2 The system provided in this embodiment is described.

[0046] See figure 2 The memory data system provided by this embodiment includes a main library and a standby library, wherein the main library has a main library copy process and a main library service process, and the standby library has a standby library copy process and a standby library service process.

[0047] The main database service process is used to send the REDO log to the standby database replication process in real time when the commit action is performed, and write the REDO log to the local REDO log file;

[0048] The master database replication process is used to scan the change increment of the local REDO log file in real time, and send the change increment of the REDO log file to the standby database replication process;

[0049] The standby database replication process is used to write to the local semi-synchronous REDO log file immedi...

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 primary and backup copying method of a memory database and a memory database system. A mode of combining asynchrony and semi-synchronicity is used. Compared with a conventional semi-synchronous copying mode, the method provided by the invention has the advantages that according to the semi-synchronicity, the subsequent processing can be performed without waiting for the receiving confirmation of a backup library host on a REDO log sent by a primary library; the processing efficiency cannot be influenced; in addition, the asynchronous copying and the semi-synchronous copying are mutually matched for jointly ensuring the consistency of data in a primary library and a backup library; under the condition that the main library is abnormal, the backup library can take over the function of the primary library; and on the precise of ensuring the data security, the efficient processing advantages of the memory database are sufficiently realized.

Description

Technical field [0001] The invention relates to the field of internal memory databases, in particular to a method for master and backup replication of internal memory databases and an internal memory database system. Background technique [0002] In-memory databases have much higher performance than disk databases because they put data in memory for operations, and provide strong support for database application systems that require high-speed response, such as telecommunications and finance. However, due to the non-persistence of memory, once the in-memory database process or the host is stopped abnormally, it will directly cause the application to be unable to continue accessing. How to ensure that one memory database node (main database) is damaged and another node (standby database) can be taken over normally has become a key technology for memory database security. [0003] At present, the way to keep the data consistent between memory databases is generally solved by replica...

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
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