Agent-based intelligent database backup system

Abstract

The invention discloses an agent-based database intelligent backup system. The system comprises a meta-information node, a management node, a storage node and a backup node, wherein the meta-information node is used for storing IPs of all the database clusters, a port and database character information, and takes the port as a unique identifier; the management node is a server for managing the system, and comprises a storage node management module, a backup strategy management module, a backup cleaning module and an agent management module; the backup node is a database server for executing a timed task, and comprises a task scheduling module and a backup execution module; and the storage node is a database server or storage equipment for storing database backup files, and comprises a backup verification module. According to the system disclosed by the invention, automatic data backup can be carried out; by sufficiently utilizing the storage node, the data security is improved; and the system has an automatic fault-tolerant mechanism, a feasible verification mechanism and a perfect management mechanism, so that one-key operation can be realized and backup data can be recovered.

Description

technical field [0001] The invention belongs to the technical field of database backup, and is mainly applied to the automatic backup of databases of relational databases and memory databases in the Internet industry. Background technique [0002] For Internet companies, database backup is becoming more and more important. At present, most commonly used database backup solutions call open source backup tools for simple packaging. These solutions have the following disadvantages: [0003] (1) Much manual intervention is required: Since the design of the backup system is not intelligent enough, manual intervention is required in many links, which increases maintenance costs. [0004] (2) Low security: Storage nodes cannot be intelligently selected, increasing the risk of data loss and low storage utilization. [0005] (3) Poor management: due to design defects, it is impossible to fully manage backup information, which reduces backup availability. [0006] (4) Unable to auto...

AI Technical Summary

Problems solved by technology

[0003] (1) More manual intervention is required: because the design of the backup system is not intelligent enough, manual intervention is required in many links, which increases maintenance costs

[0004] (2) Low security: unable to intelligently select storage nodes, increasing the risk of data loss, and low storage utilization

[0005] (3) Poor management: due to design defects, it is impossible to fully manage backup information and reduce backup availability

[0006] (4) Unable to automatically restore data: When restoring data, complex processes and manual processing are required, and the degree of automation is very low

[0007] (5) Availability cannot be guaranteed: Since there is no feasible data verification mechanism, the availability of backup data cannot be guaranteed, which reduces the availability of backup data

[0008] (6) The backup node cannot be automatically selected: a backup node needs to be manually or fixedly selected, which cannot be intelligently selected, has low flexibility, increases the risk of backup problems, and reduces the feasibility of backup

[0009] (7) Single function: generally only supports the backup of a certain database, does not record backup information, does not support multiple database backups, and cannot perform comprehensive management backup

Images