High reliability data backup and recovery method based on cluster architecture

A recovery method and data backup technology, applied in the database field, can solve the problems such as the inability of node data recovery and data loss in the dual-system hot backup solution, and achieve the effects of avoiding the loss of backup files, improving efficiency, and enhancing high availability.

Inactive Publication Date: 2018-05-04
NAT COMP NETWORK & INFORMATION SECURITY MANAGEMENT CENT +1
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The purpose of the present invention is to overcome the deficiencies of the prior art, to provide a high-reliability data backup and recovery method based on cluster architecture, to solve the problem that the dual-computer hot backup scheme cannot use its backup node to realize the recovery of the node data and cannot solve the problem of the backup node Data loss due to simultaneous media failure

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
  • High reliability data backup and recovery method based on cluster architecture
  • High reliability data backup and recovery method based on cluster architecture
  • High reliability data backup and recovery method based on cluster architecture

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] Embodiments of the present invention are described in further detail below in conjunction with the accompanying drawings:

[0039] A high-reliability data backup and recovery method based on cluster architecture is figure 1 Implemented on the system framework shown. The system framework divides data into online data and historical data, and performs backup and recovery for the two types of data, such as figure 2 As shown, the processing ideas for online data and historical data backup and recovery are as follows:

[0040]The idea of ​​backup and recovery of online data is: Since online data is always in a dynamic process of continuous loading and updating, copying online data files will not achieve the backup effect. For online data, you can use the A backup processing process is implemented in the process of importing data. This process realizes that when the data is imported into the online sub-partition table, the data is backed up to all disks in a circular manne...

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 relates to a high-reliability data backup and recovery method based on a cluster architecture, and its technical characteristics are: it includes an online data backup and recovery method and a historical data backup and recovery method, and the online data backup and recovery method includes: creating a table Space and divide the range partition table by time; realize a backup function during the process of importing data into the database; write the backup information into the system table; when the data of the day becomes historical data, it will be backed up according to the historical data backup method; In case of failure, reload data to realize online data recovery. The present invention adopts different backup and recovery methods for the two types of data, so that when a medium failure occurs, the high availability and high reliability of the single database node are improved, and the node cannot be effectively restored in the general cluster dual-machine hot backup scheme. Problems such as data loss when media failures occur on data and mutual backup nodes at the same time.

Description

technical field [0001] The invention belongs to the technical field of databases, and mainly relates to a high-reliability data backup and recovery method based on a cluster architecture. Background technique [0002] In today's informatization, with the geometric growth of data volume, it is difficult for traditional single database services to meet the application requirements of enterprises. Under this background, database cluster technology has gradually become an effective way to solve the problem of efficient concurrency of massive data. To put it simply, a database cluster is a virtual single database logical image composed of multiple database servers, and provides transparent data services to clients. Each database server is a cluster node. In addition to providing normal service functions, the cluster must also have the ability to recover from system failures to prevent catastrophic data loss or damage. Therefore, high-reliability data backup and recovery has becom...

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
Inventor 王洋冀萌萌陈训逊赵殿奎吴震蒋旭谭炜波贾宗秀刘尧
Owner NAT COMP NETWORK & INFORMATION SECURITY MANAGEMENT CENT
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