Heterogeneous database unified disaster recovery backup method and device based on virtualization and snapshot

A disaster recovery backup and database technology, applied in the field of database security, can solve the problems of idle waste of resources, backup discontinuity, high investment cost, etc., and achieve the effect of cost control

Pending Publication Date: 2022-04-12
SHANGHAI DRAGONNET TECH
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This requires a higher input cost, and the backup is non-continuous, which is easy to cause idle waste of resources

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
  • Heterogeneous database unified disaster recovery backup method and device based on virtualization and snapshot
  • Heterogeneous database unified disaster recovery backup method and device based on virtualization and snapshot
  • Heterogeneous database unified disaster recovery backup method and device based on virtualization and snapshot

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0038] refer to figure 1 As shown, this embodiment provides a unified disaster recovery and backup method for heterogeneous databases based on virtualization and snapshots, including the following steps: using virtualization technology to build a virtual machine that matches the hardware environment of the source end, and maintaining a virtual machine in the virtual machine There is a standby database, which is an active secondary database. The standby database maintains data synchronization with the source database at the source and is in operation; perform the first full backup; monitor in real time whether new log events are generated at the source, and if so, update the new When the log event is backed up, control the virtual machine to perform log synchronization; monitor in real time whether a snapshot command is generated, if so, obtain the data snapshot of the storage volume corresponding to the backup library in the virtual machine, and generate a virtual snapshot libr...

Embodiment 2

[0049] refer to figure 1 As shown, this embodiment provides a unified disaster recovery backup device for heterogeneous databases based on virtualization and snapshots, including a server scheduling manager (BMS), a source agent (SA) and a virtual agent (VA), wherein,

[0050] The server scheduling manager is configured to: construct a matching standby virtual machine based on the hardware environment of the source agent; Monitor whether a new log event is generated, and when the monitoring result is yes, send a log synchronization instruction to the virtual end agent; periodically send a snapshot instruction to the virtual end agent; receive a data recovery instruction, create a snapshot database virtual machine, and realize data recovery. Restoration, the virtual machine of the snapshot library can be set up as many as needed;

[0051] The source agent is configured to: establish a connection with the server scheduling manager, perform new log event monitoring based on the ...

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 heterogeneous database unified disaster recovery backup method and device based on virtualization and snapshot, and the method comprises the following steps: constructing a virtual machine matched with a source end hardware environment by using a virtualization technology, maintaining a standby database in the virtual machine, and keeping the standby database in data synchronization with a source database of a source end and in operation; carrying out primary full-amount backup; monitoring whether a source end generates a new log event or not in real time, and if yes, backing up the new log event and controlling the virtual machine to perform log synchronization at the same time; whether a snapshot instruction is generated or not is monitored in real time, and if yes, a data snapshot of a storage volume corresponding to a standby library in the virtual machine is obtained, and a virtual snapshot library is generated; and when recovery is executed, realizing data recovery based on the virtual snapshot library. Compared with the prior art, the method has the advantages that the reliability and the data security of a database system can be ensured, and meanwhile, physical resources are flexibly distributed and scheduled according to needs.

Description

technical field [0001] The invention relates to the technical field of database security, in particular to a unified disaster recovery backup method and device for heterogeneous databases based on virtualization and snapshots. Background technique [0002] In the era of big data, data is growing explosively, and the importance of data has been recognized. Compared with the huge amount of unstructured data, most of them are media files, and the structured data represented by databases usually records key data related to enterprise business, which is the core data related to the normal development of business. For database data, backup + disaster recovery is often used for protection. Database backup refers to periodically transferring data to other external storage media. Backup solves the problem of data security, but cannot guarantee system availability, and the restoration time is long and inefficient. The disaster recovery of the database refers to running one or more s...

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 Applications(China)
IPC IPC(8): G06F11/14G06F16/11G06F16/27
Inventor 王怡清童飞文马名马可
Owner SHANGHAI DRAGONNET TECH
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap