Database backup method and system thereof

Abstract

The invention relates to a database backup method and a system thereof. The method includes the steps that a backup information center subsystem receives backup deployment information of a database, is remotely connected with a corresponding database host and sends a remote deployment request to the database host to deploy a backup plane of the database according to the backup deployment information; a database backup subsystem automatically backs up the database according to the backup plane, records backup execution information of each time and stores the backup execution information to the backup information center subsystem; a backup detection subsystem scans the backup execution information stored in the backup information center subsystem, whether every time of backup execution of the database succeeds or not is detected according to the backup execution information, and if not, a warning prompt is output. By means of the database backup method and the system thereof, instantaneity and reliability of database backup can be improved, and unified management of backup of a large scale of distributed databases is facilitated.

Description

Technical field [0001] The present invention relates to the field of database technology, in particular to a database backup method and a database backup system. Background technique [0002] Database data is the core of a system application. The database on the production line usually faces various risk threats: the hard disk of the database host (the host where the database is located) is damaged, causing the loss of physical data; the database host is maliciously attacked, and the data has hidden dangers; the database administrator's human misoperation, etc. . If each database on the production line is not backed up in real time, or the backup fails, it will be difficult to restore data. The current database backup mechanism mainly has the following shortcomings: [0003] Database backup requires human intervention, high labor cost, and poor real-time performance of database backup; [0004] Failure to consider the completeness of the generated backup data, resulting in a larg...

AI Technical Summary

Problems solved by technology

[0003] Database backup requires human intervention, the labor cost is high, and the real-time performance of database backup is poor;

[0004] The completeness of the generated backup data is not considered, resulting in a large amount of unusable backup data, wasting storage space, and difficult to achieve database recovery;

[0005] Lack of unified and standardized backup management for large-scale distributed databases

Images