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

Data synchronization method, 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-04-19
ZTE CORP
View PDF10 Cites 0 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, device and computer-readable storage medium
  • Data synchronization method, device and computer-readable storage medium
  • Data synchronization method, 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 present invention provides a data synchronization method, device and computer-readable storage medium. The method includes: receiving a database request from a terminal through a master computer, generating a redo log and a binary log according to the database request, and synchronizing the redo log Copying to multiple synchronous standby machines, and asynchronously copying the binary log to multiple asynchronous standby machines, after receiving the response from each synchronous standby machine based on the redo log, re-receiving the database request from the terminal; the present invention implements For example, by adopting the two data synchronization methods between the active and standby data nodes, the logical replication based on the logical log and the physical replication based on the physical log, the fusion synchronization between the active and standby data nodes can be realized, and the synchronization performance between the active and standby data nodes can be effectively improved. , thereby improving the overall performance of the distributed database; and can reduce the playback delay of the standby machine node and improve the high availability of the distributed database.

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 Patents(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 Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products