Distributed database synchronization system, synchronization method and node management method

A technology for synchronizing systems and databases, applied in electrical digital data processing, special data processing applications, instruments, etc., it can solve the problems of regional power supply interruption and inability to safely protect data, improve performance, and solve data incompatibility and mutual incompatibility. Effects of synchronization, reduced overhead

Inactive Publication Date: 2012-09-26
XIDIAN UNIV
View PDF4 Cites 121 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, storing data copies in the database server in the same computer room or in the same region cannot safely protect 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
  • Distributed database synchronization system, synchronization method and node management method
  • Distributed database synchronization system, synchronization method and node management method
  • Distributed database synchronization system, synchronization method and node management method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 2

[0055] Database Synchronization Method

[0056] refer to Figure 4 , Suppose there are two database nodes, A and B, and M is the management node. The data synchronization port of A and B is an open API function set based on Web service. In M, it is set that A initiates synchronization to B.

[0057] 1. Database node A communicates with management node M to obtain the latest synchronization configuration table and network member configuration table;

[0058] 2. Database node A periodically sends a synchronization request to database node B according to the relevant synchronization strategy in the synchronization configuration table. The synchronization request includes information such as the KEY of database node B and the time stamp of the last synchronization update with database node B.

[0059] 3. After receiving the synchronization request, database node B checks the validity of the received KEY value, and returns the incremental data information after the last synchr...

Embodiment 3

[0063] Node management method

[0064] (1) Add nodes

[0065] When a new node joins the network, it first applies to the management node. The management node reviews the application information of the node and adds its relevant information to the network member configuration table of the management node. The new node uses the network member configuration table of the management node to obtain the relevant synchronization strategy and synchronize with the relevant target. Other nodes communicate with the management node through heartbeat information to obtain the synchronization strategy with this new node.

[0066] (2) delete node

[0067] Immediately deleting a database node may result in loss of important data on the deleted node. The management node first stops the external database service of the node, retrieves the relevant database nodes that are synchronized with the deleted node, and sends them an emergency message for immediate synchronization. After receiving 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 discloses a distributed database synchronization system which comprises database nodes and a management node, wherein the database nodes outwards provide distributed database access, updating and inquiry services on the basis of Web services; all the database nodes have no master-slave difference, and are independently in charge of providing distributed database services; all the database nodes have no direct relationships and periodically obtain a synchronization configuration table and a network member configuration table from the management node, and establish a synchronization relationship with other database nodes; and a Web-service-based synchronization module is adopted in all the database nodes, the traditional database is encapsulated by using the synchronization module for providing one group of API (Application Program Interface) function for the outside. Data transmission is carried out by using the Web-service-based SOAP (Simple Object Access Protocol). The distributed database synchronization system can adapt to various complex heterogeneous networks, and can be used for solving the problems of incompatibility and incapability of mutual synchronization of data among various traditional databases.

Description

technical field [0001] This solution involves the design of a distributed database or cloud database synchronization model, and provides a low-overhead, loosely coupled, autonomous synchronization solution based on Web services. Background technique [0002] Currently, storing data copies in database servers in the same computer room or in the same region cannot safely protect data, especially in the event of regional emergencies, such as regional power supply interruptions, or natural disasters and other emergencies . Therefore, more and more database service systems choose to store copies of databases on a global scale to ensure data security to the greatest extent. The ever-increasing amount of concurrent visits and the huge amount of data access require the construction of a distributed database system. [0003] Distributed databases not only solve the problem of traditional databases that are difficult to expand in storage space and the bottleneck of highly concurrent...

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): G06F17/30
Inventor 王凯东于菊珍胡继磊
Owner XIDIAN UNIV
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