Data recovery method and device, medium and electronic equipment

Abstract

The invention provides a data recovery method and device, a medium and electronic equipment. According to the method and the device, the misoperation information is acquired from a backup log file, and a reverse rollback operation instruction is generated based on the misoperation information, so that the access burden of the operation log file is relieved; and when the backup log file is stored in another server outside the database, the pressure of the database can be reduced, and the stable operation of the database is ensured.

Description

technical field [0001] The present disclosure relates to the field of data processing, in particular, to a data recovery method, device, medium and electronic equipment. Background technique [0002] When adding, deleting or modifying the database, it often leads to misoperation, destroying normal data, even important data, resulting in irreparable consequences. [0003] After a misoperation is found, the original data is usually restored by means of a rollback operation. For example, before rolling back the mysql database, the binlog2sql tool needs to be authorized so that it can read the information_schema. Parse out the required SQL statement. For example, SQL statements for misoperations, SQL statements required for rollback, and insert SQL statements for removing primary keys. [0004] However, when searching and parsing the log content for the mysql instance online, it will cause performance pressure on the mysql instance, especially when there are a lot of access t...

AI Technical Summary

Problems solved by technology

[0004] However, when searching and parsing the log content of the mysql instance online, it will cause performance pressure on the mysql instance, especially when there are a lot of access to the mysql database and there are many log files

However, when the binlog2sql tool uses a single process to work, the parsing operation and the rollback operation take a long time, which slows down the normal operation of the entire system.

Images