Data synchronization method and device and computer readable storage medium

A data synchronization and computer technology, which is applied in the field of data processing, can solve the problems affecting the switching time of the master and backup of the distributed database, the high availability of the distributed database, and the low synchronization performance of the master and backup data nodes, so as to achieve fusion synchronization and reduce playback Latency, the effect of improving high availability

Active Publication Date: 2022-01-28
ZTE CORP
View PDF16 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] For example, the data nodes of the current GoldenDB (financial-level transactional) distributed database are developed based on an open source database such as MySQL (relational database management system). Data synchronization, but the synchronization performance between the active and standby data nodes is usually low, which leads to low overall performance of the distributed database; in addition, due to the high playback delay of the standby machine node in the active and standby data nodes, it affects the active and standby data nodes of the distributed database. Standby switchover time reduces the high availability of distributed databases

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 and computer readable storage medium
  • Data synchronization method and device and computer readable storage medium
  • Data synchronization method and device and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] 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.

[0036] It should be noted that although the functional modules are divided in the schematic diagram of the device, and the logical sequence is shown in the flowchart, in some cases, it can be executed in a different order than the module division in the device or the flowchart in the flowchart. steps shown or described. The terms "first", "second" and the like in the specification and claims and the above drawings are used to distinguish similar objects, and not necessarily used to describe a specific sequence or sequence.

[0037] It is understandable that, whether it is a distributed database or...

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 and a computer readable storage medium, and the method comprises the steps: receiving a database request from a terminal through a main machine, and generating a redo log and a binary log according to the database request; synchronously copying the redo log to a plurality of synchronization standby machines, and asynchronously coping the binary logs to a plurality of asynchronous standby machines; and after response based on the redo logs from each synchronous standby machine is received, receiving the database request from the terminal again. According to the embodiment of the invention, by adopting two data synchronization modes, namely logic replication based on logic logs and physical replication based on physical logs, between the main and standby data nodes, fusion synchronization between the main and standby data nodes is realized, the synchronization performance between the main and standby data nodes is effectively improved, and the overall performance of the distributed database is further improved; and moreover, the playback time delay of the standby machine node can be reduced, and the high availability of the distributed database is improved.

Description

technical field [0001] The present invention relates to but not limited to the technical field of data processing, and in particular relates to a data synchronization method, device and computer-readable storage medium. Background technique [0002] At present, whether it is a distributed database or a stand-alone database, there are mainly two methods for data synchronization between the active and standby data nodes. The first is logical replication based on logical logs, and the second is physical replication based on physical logs. [0003] For example, the data nodes of the current GoldenDB (financial-level transactional) distributed database are developed based on an open source database such as MySQL (relational database management system). Data synchronization, but the synchronization performance between the active and standby data nodes is usually low, which leads to low overall performance of the distributed database; in addition, due to the high playback delay of ...

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 Applications(China)
IPC IPC(8): G06F16/27G06F16/21
CPCG06F16/275G06F16/219
Inventor 周亚运盛夏付裕
Owner ZTE CORP
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap