Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data synchronization method and device of primary and standby databases

A main database and data synchronization technology, applied in the field of network communication, can solve the problems of increasing the time for synchronizing the database to the backup storage device and affecting the front-end business, so as to reduce time, improve efficiency and reduce the impact

Active Publication Date: 2015-04-08
ZHEJIANG UNIVIEW TECH CO LTD
View PDF4 Cites 38 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a data synchronization method and device for the main and standby databases to solve the problem that in the prior art, with the continuous increase of data in the main database, the database files will continue to increase, resulting in the time for synchronizing the database from the main storage device to the backup storage device. increase, thus affecting front-end business issues

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
  • Data synchronization method and device of primary and standby databases
  • Data synchronization method and device of primary and standby databases
  • Data synchronization method and device of primary and standby databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] In order to enable those skilled in the art to better understand the technical solutions in the embodiments of the present invention, and to make the above-mentioned purposes, features and advantages of the embodiments of the present invention more obvious and understandable, the following describes the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings For further detailed explanation.

[0032] see figure 1 , which is a schematic diagram of the application scenario of data synchronization between the primary and secondary databases in the embodiment of the present invention:

[0033] figure 1 shows a high availability (High Available, HA) system networking architecture. As shown in the figure, the HA storage system includes a primary node and a standby node. Among them, HA is a technology that keeps storage services running continuously when an abnormality occurs in the storage system and improves the servic...

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 provides a data synchronization method and device of primary and standby databases. The data synchronization method is applied to main nodes of an HA (high availability) storage system, and includes: sending a heartbeat message to standby nodes, wherein the heartbeat message carries preset values or synchronous check values so that the standby nodes can judge whether data stored in the primary database and the standby database are consistent according to the synchronous check values; receiving a reply message sent by the standby nodes, wherein the reply message can indicate whether the data stored in the primary database and the standby database are consistent; stopping sending the heartbeat message and sending a WAL (write-ahead logging) file of the primary database to the standby nodes when the reply message indicates that the data stored in the primary database and the standby database are inconsistent, so the standby nodes can conduct data synchronization for the standby database according to the WAL file. The data synchronization method and device can reduce the data synchronization time and efficiency of the primary and standby databases.

Description

technical field [0001] The invention relates to the technical field of network communication, in particular to a method and a device for synchronizing data of an active and standby database. Background technique [0002] With the continuous development of network communication technology, more and more front-end data needs to be stored. In order to improve the reliability of the front-end data storage, the main and backup storage devices are generally used for synchronous storage. How to synchronize the data stored in the respective databases of the primary and secondary storage devices has become a key issue. [0003] In the prior art, the synchronization process of the respective databases of the primary and secondary storage devices is generally as follows: when the primary and secondary storage devices are running normally, the stored data is written into the primary database of the primary storage device, and real-time through database-related technologies, such as : ...

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
CPCG06F16/27
Inventor 张敏
Owner ZHEJIANG UNIVIEW TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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