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

Database real-time backup method

A real-time backup and database technology, which is applied in the direction of data error detection and response error generation in electrical digital data processing and calculation, and can solve problems such as inability to synchronize data in real time

Active Publication Date: 2020-01-21
宏为物联网科技(苏州)有限公司
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when some data on the primary database cannot be rolled back and recovered through log analysis, the data in the backup database and the primary database are always synchronized in real time, and the exact same operations will be performed, so it is also impossible to perform real-time synchronization based on the synchronized backup data

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
  • Database real-time backup method
  • Database real-time backup method
  • Database real-time backup method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0024] The present invention proposes the designed database data synchronous backup method, such as figure 1 shown, including the following steps:

[0025] S101: Set the master database as the master node on the control node, and the two backup databases as two standby nodes;

[0026] S102: Install a trigger on the database table that needs to be backed up synchronously by the master node in real time;

[0027] S103: Establish a ...

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 designs a database real-time backup method, which can ensure the continuity of database services and ensure that data is not lost to the maximum extent. The embodiment of the invention comprises a control node, a main node and two standby nodes. The main database is located at the main node, and the backup database is located at the standby node. The method has the advantages that: 1) when part of the data is in fault, the main database can still work, and a standby database is not required to take over the data; 2) the database synchronous backup system does not need to run on the main database or the backup database, the system performance of the database is not influenced, and 3) the data is not lost when a fault occurs to the maximum extent.

Description

technical field [0001] The invention relates to the field of database backup, and relates to a real-time synchronous backup and recovery method for database data. Background technique [0002] There are two types of database data backup: asynchronous and synchronous. Asynchronous database backup compresses all or differential data in the database and transfers them to the backup database in each backup cycle; synchronous database backup is obtained based on database log analysis or triggers. The differential data between the primary database and the backup database is synchronized to the backup database in real time. When the primary database is abnormal or part of the data fails, the standby database will continue to provide services or perform data recovery based on the data stored in the backup database. However, there are still many problems in these existing database backup technologies. When the asynchronous backup mode is used, only the data of the previous backup c...

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
IPC IPC(8): G06F11/14
CPCG06F11/1458G06F11/1469Y02D10/00
Inventor 孙玉娥黄河
Owner 宏为物联网科技(苏州)有限公司