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

A technology of data backup and recovery method, applied in the field of data processing, can solve the problems of slow data repair and slow data recovery, etc.

Active Publication Date: 2019-09-20
ZHONGAN ONLINE P&C INSURANCE CO LTD
View PDF6 Cites 6 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 and device, computer device and storage medium
  • Data backup and recovery method and device, computer device and storage medium
  • Data backup and recovery method and device, computer device 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 main database operation log, and the data operation record is executed on the backup database according to the data operation record The same oper...

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 and device, a computer device and a storage medium, and belongs to the technical field of data processing. The method comprises: when data backup is conducted on a main database, synchronizing data of the main database to a plurality of backup databases at different time intervals in a delayed mode; when an error occurs in the main database, determining a target backup database used for performing data recovery on the main database in the backup databases; and performing data recovery on data of main database by using data of the target backup database. Compared with a data recovery method in the prior art, the data recovery method can rapidly recover the main database, the fault recovery time can be obviously shortened, the fault recovery failure can be avoided, and the overall usability of the database system is improved.

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 Applications(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