Unlock instant, AI-driven research and patent intelligence for your innovation.

Data recovery method and device based on incremental backup and medium

A technology of incremental backup and recovery methods, applied in the computer field, can solve problems such as incomplete operation statement interception, large time and space consumption, and incomplete data recovery, so as to save backup time and space, improve quality and efficiency, and save The effect of storage space

Pending Publication Date: 2022-03-08
中国农业银行股份有限公司福建省分行
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Since log_pos is not unique, it will be counted again in each binlog file, so this patent is only suitable for the scenario of a single binlog file. When the misoperation statement spans multiple binlog files, because log_pos is not unique, the operation statement may be intercepted incompletely situation, resulting in incomplete data recovery
[0004] The Chinese invention patent with the application date of 2020.04.02 and the application number CN202010256751.5 discloses a transaction log-based Mysql data recovery method. The patent uses full database backup to perform full recovery first, and then extracts table-level logic based on time Statement for data recovery, because it is the logical statement extraction at the data table level, so in addition to providing time, you also need to specify the corresponding table. There are many elements that need to be provided, and frequent full backups will consume a lot of time and space. If database backup is infrequent, too many logic statements need to be restored, which will affect the overall recovery speed

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
  • Data recovery method and device based on incremental backup and medium
  • Data recovery method and device based on incremental backup and medium
  • Data recovery method and device based on incremental backup and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] This embodiment provides a data recovery method based on incremental backup, such as figure 1 shown, including the following steps:

[0045] Step S10, periodically incrementally backing up the data to obtain several backup data packets;

[0046] Step S20, obtain the deadline for data recovery, and use the backup time of the last backup data package as the start time for data recovery; the deadline for data recovery can be automatically obtained through a script;

[0047] Step S30, based on the data recovery start time and the data recovery deadline, automatically extract the start GTID and the end GTID from the corresponding backup data package and the binary log file (binlog file);

[0048] Step S40, deriving logical statements from the corresponding binary log file based on the start GTID and the end GTID;

[0049]Step S50, display the start GTID, end GTID and logic statement, and obtain the operation instruction input by the user; since the data recovery will affec...

Embodiment 2

[0073] This embodiment provides a data recovery device based on incremental backup, such as figure 2 As shown, it includes a memory, a processor, and a computer program stored in the memory and operable on the processor. When the processor executes the computer program, any implementation manner in Embodiment 1 can be realized.

[0074] Since the electronic device introduced in this embodiment is the device used to implement the method in Embodiment 1 of this application, based on the method described in Embodiment 1 of this application, those skilled in the art can understand the electronic device of this embodiment. Specific implementation methods and various variations thereof, so how the electronic device implements the method in the embodiment of the present application will not be described in detail here. As long as a person skilled in the art implements the equipment used by the method in the embodiment of the present application, it all belongs to the protection scop...

Embodiment 3

[0077] This embodiment provides a data recovery medium based on incremental backup, such as image 3 As shown, a computer program is stored thereon, and when the computer program is executed by a processor, any implementation manner in the first embodiment can be realized.

[0078] The technical solutions provided in the embodiments of the present application have at least the following technical effects or advantages:

[0079] 1. By periodically incrementally backing up the data, and then extracting the start GTID and the end GTID from the corresponding binary log file according to the data recovery start time and the data recovery deadline, use the start GTID and the end GTID from the corresponding binary log file The logical statement is exported from the log file, and finally the logical statement is integrated with all the backup data packages corresponding to the data recovery start time to complete the data recovery. Since the GTID is globally unique, incomplete data re...

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 provides a data recovery method and device based on incremental backup and a medium in the technical field of computers. The method comprises the following steps: step S10, performing incremental backup on data to obtain a plurality of backup data packets; step S20, acquiring data recovery deadline, and determining data recovery starting time according to the latest incremental backup data packet; step S30, respectively extracting a starting GTID and a stopping GTID from the backup data packet and the binary log file based on the data recovery starting time and the data recovery stopping time; s40, based on the starting GTID and the stopping GTID, a logic statement is exported from the binary log file; s50, displaying the starting GTID, the stopping GTID and the logical statement, and obtaining an operation instruction input by a user; step S60, based on the operation instruction, integrating the logic statement with all backup data packets before the data recovery starting time to complete data recovery; and step S70, carrying out full-amount backup on the data. The method has the advantage that the data recovery quality and efficiency are greatly improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a data recovery method, device and medium based on incremental backup. Background technique [0002] With the advancement of science and technology, electronic office has gradually become popular, and working with computers has greatly improved people's work efficiency. Due to operational errors or sudden power outages, data is often lost, and data loss means that a lot of work has been wasted. In order to avoid data loss due to accidents, it is necessary to back up the data in case of emergency. [0003] After searching, the application date is 2018.11.09, and the Chinese invention patent with the application number CN201811331065.9 discloses the MySQL misoperation rollback method, equipment and system. The patent first obtains the binlog file where the misoperation occurred, and uses log_pos in the binlog file Locate the misoperation statement fragment, and then reverse the...

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 Applications(China)
IPC IPC(8): G06F11/14
CPCG06F11/1469
Inventor 王弘中张松坚杨超陈长钦沈书航
Owner 中国农业银行股份有限公司福建省分行