Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Agent-based intelligent database backup system

A backup system and database technology, applied in database distribution/replication, redundancy in operation, data error detection, structured data retrieval, etc. problem to improve security

Active Publication Date: 2018-07-06
HANGZHOU SHISHUO EDUCATION TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

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
  • Agent-based intelligent database backup system
  • Agent-based intelligent database backup system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] The present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments.

[0041] figure 1 It is the overall architecture diagram of the backup system of the present invention. The management node is the core. First, the meta information node is called to obtain the IP and data directory of the storage node, the IP, port and role information of the database node. According to the IP and data directory of the storage node, adopt The agent method obtains the size of its available space, thereby updating the detailed information of the storage node, and then automatically selects the backup node from the information of the database node, and then generates or updates the backup policy according to the backup policy template, and then distributes scheduled tasks and backup scripts to the backup node; the backup node triggers database backup at a specified point in time; the storage node regularly verifies the ba...

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 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...

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): G06F11/14G06F17/30
CPCG06F11/1448G06F11/1464G06F16/27
Inventor 顾伟涛
Owner HANGZHOU SHISHUO EDUCATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products