Memory database backup management method, device, terminal and storage medium

Abstract

The embodiment of the application provides a method, a device, a terminal and a storage medium for backup management of a memory database. The method comprises the following steps: data in the memorydatabase is imported into a relational database; Synchronizing the backup data in the relational database to the shadow memory; Judging whether the in-memory database fails or not: if Yes, loading thebackup data in the shadow memory into the in-memory database; if not, the load is not performed. The backup and recovery process of the invention is an automatic execution process, and does not needto pass through a disk, which greatly improves the efficiency and saves a lot of time and human resources.

Description

technical field [0001] The invention belongs to the technical field of data storage, and in particular relates to a memory database backup management method, device, terminal and storage medium. Background technique [0002] For disk databases, due to disk access, data transfer between internal and external memory, buffer management, queuing, and lock delays, the actual average execution time of a transaction differs greatly from the estimated worst-case execution time. If the entire database Or its main "working" part is put into the memory, so that each transaction has no I / O during execution, which provides a more accurate estimation and arrangement of the running time of the transaction for the system, so that it has better dynamic predictability. At the same time, it also lays the foundation for realizing the timing limit of transactions, so the in-memory database that stores the data in the database in the memory is derived. Memory database (Memory Database, MDB) refe...

AI Technical Summary

Problems solved by technology

However, MDB has a fatal weakness, which is volatility. When the data stored in the memory fails, it is easy to cause data loss. In order to prevent data loss, it is necessary to save its backup in time.

However, database backup, log storage, and system recovery under abnormal conditions require a large number of time-consuming disk I / O operations, which will affect the normal transaction processing capabilities of the system.

Images