Unlock instant, AI-driven research and patent intelligence for your innovation.

A database disaster recovery system

A database and disaster recovery technology, applied in the database field, can solve the problems of long data recovery time and short recovery time.

Active Publication Date: 2018-03-27
CHENGDU WENWU INFORMATION TECH
View PDF9 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 problem that the current database disaster recovery system takes too long to restore data, and to provide a database disaster recovery system with a very short recovery time, including a master server and a slave server, and the master server and the slave server include snapshot of the database

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
  • A database disaster recovery system
  • A database disaster recovery system
  • A database disaster recovery system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] Embodiment 1: The object of the present invention is to overcome the problem that the data recovery of the current database disaster recovery system takes too long, and provide a database disaster recovery system with a very short recovery time, such as Figure 4 As shown, including the master server and the slave server, the master server and the slave server all contain snapshots of the database; (it should be noted that in this field, master nodes and master servers all refer to the same technical concept, similarly, slave Server, standby server, and slave node are also the same technical concept) The master server and the slave server can be connected together through optical fiber or Ethernet, and the snapshot of the database can choose to use the ZFS file system or the vxfs file system.

[0026] When the database is running normally, the data in the slave server is copied in real time from the data in the master server through optical fiber or Ethernet; at this tim...

Embodiment 2

[0033] Embodiment 2: The difference between this embodiment and Embodiment 1 is that the master server and the slave server each take a snapshot according to their own preset time, such as Figure 7 As shown, in the same time period, the snapshots of the master server are set to T1, T2, T3, T4, T5 respectively, and the snapshots of the slave servers are T1', T2', T3', T4'.

[0034] In this embodiment, when the main server needs to rejoin the cluster after the failure is repaired, it is necessary to restore the data of the main server first. The recovery steps are as follows:

[0035] (1) First restore the primary server's own data to the specified snapshot before the failure. Assuming that the primary server fails after snapshot T5, in order to eliminate the log branch problem, ensure that the content of the snapshot data selected for recovery is earlier than the secondary server when the primary server failed The content of the data in the middle is enough, so in this embodim...

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 the database field, in particular to a database disaster backup system. It includes a master server and a slave server, both of which contain snapshots of the database; when the database is running normally, the master server and the slave server take snapshots of the database at preset intervals or according to instructions; when the master server fails , the slave server replaces the master server to work; when the master server restores data, it first restores its own data to the specified snapshot before the failure, and then copies the data that is not in the specified snapshot from the slave server to the master server, and the master server Rejoin the cluster; the present invention can create a time window that can be backed up at any time for applications that do not have a backup time window, and does not affect the normal operation of the database and applications, and can solve the problem of log branches. The present invention can also quickly It is integrated into the current application environment for testing, and does not affect the continuous operation of the current system.

Description

technical field [0001] The invention relates to the database field, in particular to a database disaster recovery system. Background technique [0002] The database is the core of all IT systems. It saves the complete data running in the business system. When the database system equipment crashes, the log recovery of the database is very important. At present, most of the disaster recovery devices for database system equipment crashes are as follows: figure 1 As shown, it is composed of two servers, the primary server and the standalone server. Under normal circumstances, the primary server provides services to the outside world and accepts operations such as reading, writing, changing, and deleting from applications. Standalone provides read-only operations; figure 2 As shown, the data of the master server is copied to the slave server in real time, and the slave server receives the data of the master server and restores it to the slave database. There is always a certain...

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 CHENGDU WENWU INFORMATION TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com