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 conf

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

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

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
Owner 北京思特奇信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap