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

Database backup method and device, readable storage medium and electronic equipment

A storage medium and database technology, applied in the field of data processing, can solve the problems of consuming a lot of manpower and material resources, unable to manage multiple backup resources in a unified manner, and having no management interface, etc., to achieve the effect of improving efficiency

Pending Publication Date: 2022-08-05
用友汽车信息科技(上海)股份有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the prior art, the methods for backing up the volume of distributed databases include the following two methods: one is to back up the database management personnel of each distributed database by themselves, and in this method, they choose the backup time by themselves and manage the storage and use of the backup files by themselves. There is no unified The management interface of multiple backup resources cannot be managed in a unified manner; the second is to perform unified backup by the operation and maintenance department. In this method, the unified operation and maintenance department performs unified backup of all distributed databases, and manages the storage and Due to the large number of databases that need to be backed up, it takes a lot of manpower and material resources, and it is difficult to ensure that each database can perform disaster recovery in a timely manner.

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
  • Database backup method and device, readable storage medium and electronic equipment
  • Database backup method and device, readable storage medium and electronic equipment
  • Database backup method and device, readable storage medium and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0075] figure 1 A schematic flowchart of a database backup method according to an embodiment of the present invention is shown, wherein the backup method includes:

[0076] Step S102, within the first preset time period, confirm whether the invocation of the backup script is successful;

[0077] Step S104, in the case of confirming that calling the backup script is successful, back up the database to be backed up to generate a first backup file;

[0078] Step S106, within the second preset time period, confirm whether the reading of the first backup file is successful;

[0079] Step S108, in the case of confirming that the reading of the first backup file is successful, preprocessing the first backup file to generate a second backup file, and uploading the second backup file to the cloud storage unit;

[0080] Step S110, confirming whether uploading the second backup file to the cloud storage unit is successful;

[0081] Step S112, in the case of confirming that the uploadi...

Embodiment 2

[0154] Figure 8 A schematic block diagram of a database backup apparatus according to an embodiment of the present invention is shown, which is used for backing up a plug-in. The database backup apparatus 800 includes: a first processing module 802, configured to confirm invoking a backup script within a first preset time period Whether it is successful; the first processing module 802 is further configured to back up the database to be backed up to generate a first backup file when it is confirmed that the backup script is successfully invoked; the second processing module 804 is configured to perform a backup within a second preset time period , confirming whether the reading of the first backup file is successful; the second processing module 804 is further configured to preprocess the first backup file to generate a second backup file when it is confirmed that the reading of the first backup file is successful The second backup file is uploaded to the cloud storage unit; ...

Embodiment 3

[0173] According to a third embodiment of the present invention, a readable storage medium is provided on which programs or instructions are stored, and when the programs or instructions are executed by a processor, the database backup method as proposed in the above embodiments is implemented. Therefore, the readable storage medium has all the beneficial effects of the database backup method proposed in the foregoing embodiments, and details are not described herein again.

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 database backup method and device, a readable storage medium and electronic equipment, and the backup method comprises the steps: determining whether a backup script is successfully called within a first preset time period; under the condition of confirming that the backup script is successfully called, backing up the to-be-backed-up database to generate a first backup file; in a second preset time period, whether the first backup file is successfully read or not is confirmed; under the condition that it is confirmed that the first backup file is successfully read, the first backup file is preprocessed to generate a second backup file, and the second backup file is uploaded to a cloud storage unit; confirming whether the second backup file is successfully uploaded to the cloud storage unit or not; and when it is confirmed that the second backup file is successfully uploaded to the cloud storage unit, reporting the first prompt information to the management system. According to the technical scheme, automatic backup, automatic compression and encryption and automatic uploading of the backup file to the cloud storage unit of each distributed database are realized.

Description

technical field [0001] The present invention relates to the technical field of data processing, and in particular, to a database backup method, apparatus, readable storage medium and electronic device. Background technique [0002] In the prior art, distributed database volume backup methods include the following two: one is that each distributed database library administrator backs up by himself. The management interface cannot unify the management of multiple backup resources; the second is to perform unified backup by the operation and maintenance department. In this method, the unified operation and maintenance department performs unified backup of all distributed databases, and manages the storage and storage of backup files in a unified manner. Due to the large number of databases that need to be backed up, it takes a lot of manpower and material resources, and it is difficult to ensure that each database can be disaster prepared in time. SUMMARY OF THE INVENTION ...

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
IPC IPC(8): G06F11/14G06F21/60G06F21/62
CPCG06F11/1448G06F21/602G06F21/6218
Inventor 赵可重王明怀
Owner 用友汽车信息科技(上海)股份有限公司