Data backup and recovery method, device, computer equipment and storage medium

A technology of data backup and recovery method, which is applied in the field of data processing, can solve the problems of slow data repair and data recovery, achieve fast recovery, improve overall availability, and avoid failure recovery failures

Active Publication Date: 2021-10-01
ZHONGAN ONLINE P&C INSURANCE CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Regardless of whether it is hot backup or cold backup, if the production database is deleted due to human misoperation, the common data recovery method is to find the full backup data file at the beginning of the month, and then find out the daily increment Back up the files, and then find all the binlog log files on the day when the database was deleted, and then execute them sequentially until all data files and binlog log files are executed, that is, the recovery of database data is completed. The potential problems of this solution are: All daily incremental files and binlog log files need to be executed, and data restoration is slow. If the end of the month is encountered, more daily incremental files need to be executed, and data recovery is slower

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 backup and recovery method, device, computer equipment and storage medium
  • Data backup and recovery method, device, computer equipment and storage medium
  • Data backup and recovery method, device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0046] refer to figure 2 As shown, the embodiment of the present invention provides a method for data backup and recovery, the method comprising steps:

[0047] S1. When performing data backup on the primary database, delay synchronizing the data of the primary database to multiple backup databases at different time intervals.

[0048] In this embodiment, there is a master-slave relationship between the master database and the backup database. If the master database performs an operation on a certain data, the corresponding data operation record for the data is recorded in the master database operation log, and the data operation record includes The data identification, storage path, operation instruction and operation time of the data, when the synchronization is delayed, the data operation record of the data is obtained from the operation log of the primary database, and the data is executed on the backup database according to the data operation record of the data The same...

Embodiment 2

[0072] As the realization of the data backup and recovery method in the first embodiment, the embodiment of the present invention also provides a data backup and recovery device, refer to image 3 As shown, the device includes:

[0073] The data backup module 31 is used to delay and synchronize the data of the main database to multiple backup databases at different time intervals when the main database is backed up;

[0074] The data recovery module 32 is configured to determine, among the plurality of backup databases, a target backup database for data recovery of the primary database when an error occurs in the primary database, and use the data pair of the target backup database to The data of the master database is restored.

[0075] In a preferred embodiment, the data recovery module 32 is specifically used for:

[0076] determining the erroneous operation that caused the error in said master database;

[0077] Determining a backup database that does not perform the er...

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 discloses a data backup and recovery method, device, computer equipment and storage medium, belonging to the technical field of data processing. The method includes: when performing data backup on the primary database, delaying synchronization of the data of the primary database to multiple backup databases at different time intervals; when an error occurs in the primary database, determining an error in the multiple backup databases A target backup database for data recovery of the main database; the data of the target backup database is used for data recovery of the data of the main database. Compared with the data recovery method in the prior art, the present invention can quickly Restoring the primary database can significantly shorten the failure recovery time, avoid failure recovery failures, and improve the overall availability of the database system.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data backup and recovery method, device, computer equipment and storage medium. Background technique [0002] At present, there are usually two common methods of database backup, cold backup and hot backup. Cold backup means that the DBA (database administrator) or system administrator manually exports data from the production database to local storage. Hot backup means that no DBA or system administrator is required. The system administrator executes it manually, and the system automatically executes the backup such as master-slave replication, master-master replication, etc. At present, mainstream companies use the method of full backup + incremental backup, such as a full export of the production database once a month. A daily incremental export of the production database is performed. [0003] Regardless of whether it is hot backup or cold backup, if the production...

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 Patents(China)
IPC IPC(8): G06F16/27G06F11/14
CPCG06F11/1446G06F16/27
Inventor 郭志伟窦文瑞
Owner ZHONGAN ONLINE P&C INSURANCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap