Method and system for capturing database consistent points in block-level CDP, and storage medium

Abstract

The invention relates to a method and system for capturing database consistent points in a block-level CDP and a storage medium, and belongs to the field of data recovery. The method comprises the steps of obtaining a path where a redo log is located; creating a consistent point cache; installing a file filter driver and a roll filter driver; a sending step; a basic information acquisition step; a judgment step; and a capturing step. The system comprises a redo log path acquisition module; a consistent point cache creation module; a file filter drive and roll filter drive installation module; a sending module; a basic information acquisition module; a judgment module; and a capture module. According to the method, the volume filtering driver captures the consistent points, the work of capturing the consistent points is completed through mutual cooperation of the file filtering driver, the consistent point cache and the volume filtering driver, the specific content of an IO request packet does not need to be analyzed, only the InnoDB redo log check points need to be recognized, and the method is simple, convenient and feasible.

Description

technical field [0001] The invention belongs to the field of data restoration, and relates to a method, system and storage medium for capturing consistent points of databases in block-level CDP. Background technique [0002] InnoDB is a storage engine that supports transactions, rollback, and multi-version concurrency control. The current popular MySQL database uses InnoDB as the default storage engine. InnoDB has a fixed checkpoint field in its redo log file, and the database cache will make a corresponding record in the checkpoint every time it is placed on the disk. Block-level CDP is a backup method that can continuously capture all volume device IO requests, which can effectively avoid data loss caused by non-hardware failures such as operation errors and virus attacks, and can provide more flexible target recovery points. With the development of storage technology, block-level CDP is gradually becoming the mainstream method of data protection, and applying block-level...

AI Technical Summary

Problems solved by technology

This method can effectively solve the problem of database consistency in block-level CDP, but it also has certain disadvantages, that is, the content of each transaction log IO request packet needs to be analyzed, which will inevitably have a certain performance impact on the protected client , especially the IO request packet is generated at the kernel layer, and the delivery speed is very fast. If the specific content of the IO request packet is parsed during the delivery process, it will cause a large delay

Images