Database updating synchronization method and system and database cluster

A data update and database technology, applied in the database field, can solve problems such as the inability to provide data update capabilities and affect the data update speed of the target database

What is AI technical title?
AI technical title is built by PatSnap AI team. It summarizes the technical point description of the patent document.
A data update and database technology, applied in the database field, can solve problems such as the inability to provide data update capabilities and affect the data update speed of the target database

CN106202365AActive Publication Date: 2016-12-07帅斌鹏

5 Cites 13 Cited by

Image

Smart Image Click on the blue labels to locate them in the text.

Viewing Examples

Smart Image

Examples

Experimental program

Comparison scheme

Effect test

Embodiment Construction

[0029] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0030] figure 1 It is a schematic flowchart of a method for updating and synchronizing databases in an embodiment. In this embodiment, the execution environment is the first database, which is either a source database or a target database that accepts an update synchronization command. Such as figure 1 As shown, the method for database update synchronization in this embodiment includes steps:

[0031] S11, receiving an update command for the first database;

[0032] In the embodiment of the present invention, it is assumed that the execution of the update command is implemented in the trigger o...

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

Login to View More

Abstract

The invention relates to a database updating synchronization method and system and a database cluster. The method comprises the steps of receiving an updating command for a first database, and identifying whether the updating command is a copied updating command or not according to a preset database session attribute; if not, converting the updating command into a new updating command containing same data operation information; judging whether a second database linked with the first database meets a preset real-time updating condition or not; if the preset real-time updating condition is met, sending the new updating command to the second database for execution; and if the preset real-time updating condition is not met, storing the new updating command for the second database, and performing synchronous updating delay on the second database according to the stored updating command. According to the method, the system and the database cluster, the endless loop during updating synchronization of the databases in the cluster can be avoided and the overall data updating synchronization speed of the cluster is increased.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method, a system and a database cluster for updating and synchronizing databases. Background technique [0002] Relational database technology is a core technology in information system. It is widely used as the background of various information applications and provides data services for various applications. At present, the most important relational databases include commercial databases Oracle, DB2, SQL Server and open source relational databases MySQL, PostGreSQL, etc. [0003] In order to ensure data security, one or more database backups need to be implemented, and hot backup is a commonly used database backup method. Hot backup is a backup method when the database is running, and the hot backup data can be used for rapid disaster recovery. However, because the traditional hot backup is non-real-time, it is difficult to guarantee the accuracy of the data it provides,...

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

07 Dec 2016

Publication

CN106202365A

IPC: G06F17/30

CPC: G06F16/23; G06F16/2315; G06F16/27

Inventors: 帅斌鹏