A master-slave replication method of an in-memory database and an in-memory database system

A replication method and database technology, applied in the field of in-memory databases, can solve problems such as decreased processing efficiency, achieve the effect of efficient processing and ensure consistency

Active Publication Date: 2019-09-17
北京思特奇信息技术股份有限公司
View PDF6 Cites 0 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
  • A master-slave replication method of an in-memory database and an in-memory database system
  • A master-slave replication method of an in-memory database and an in-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 will be described.

[0026] join figure 1 , the method provided by this embodiment includes: S1. When the main library service process in the memory database executes the submission action, the REDO log is sent to the backup library replication process in real time, and the REDO log is written into 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 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 copy process of the standby database writes the change increment of the received REDO log f...

Embodiment 2

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

[0046] see figure 2 , the in-memory data system provided in this embodiment includes a master database and a standby database, wherein the master database has a master database replication process and a master database service process, and the standby database has a standby database replication process and a standby database service process.

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

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

[0049] Described standby library copying process is used to write into the...

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 in-memory databases, in particular to an in-memory database master-backup replication method and an in-memory database system. Background technique [0002] In-memory databases have much higher performance than disk databases because they operate all data in memory, 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 memory database process or host stops abnormally, it will directly cause the application program to be unable to continue accessing. How to ensure that one in-memory database node (primary database) is damaged and another node (standby database) can take over normally has become a key technology for in-memory database security. [0003] Currently, data consistency between in-memory databases is generally resolved through replication technology. The replication metho...

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 北京思特奇信息技术股份有限公司
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