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...

Examples

Embodiment Construction

[0090] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the drawings, it should be understood that the disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein; A more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are for exemplary purposes only, and are not intended to limit the protection scope of the present disclosure.

[0091] It should be understood that the various steps described in the method implementations of the present disclosure may be executed in different orders, and / or executed in parallel. Additionally, method embodiments may include additional steps and / or omit performing illustrated steps. The scope of the present disclosure is not limited in this regard. ...

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...

Examples

Embodiment Construction

[0090] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the drawings, it should be understood that the disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein; A more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are for exemplary purposes only, and are not intended to limit the protection scope of the present disclosure.

[0091] It should be understood that the various steps described in the method implementations of the present disclosure may be executed in different orders, and / or executed in parallel. Additionally, method embodiments may include additional steps and / or omit performing illustrated steps. The scope of the present disclosure is not limited in this regard. ...

Images