Distributed database cluster system, data synchronization method and storage medium

A cluster system and data synchronization technology, applied in the field of distributed databases, can solve problems such as the inability to achieve global consistency at time points, and achieve the effect of ensuring global consistency

Pending Publication Date: 2019-09-06
金篆信科有限责任公司
View PDF9 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Embodiments of the present invention provide a distributed database cluster system, a data synchronization method, and a storage medium to at lea

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 cluster system, data synchronization method and storage medium
  • Distributed database cluster system, data synchronization method and storage medium
  • Distributed database cluster system, data synchronization method and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0036] This embodiment provides a distributed database cluster system. figure 1 is a schematic diagram of the architecture of the distributed database cluster system according to Embodiment 1 of the present invention, such as figure 1 As shown, the distributed database cluster system may include: a first synchronous clock module 12, a first data synchronization module 14 and a plurality of first database groups 16, wherein each of the plurality of first database groups 16 A database group 16 includes a first master database (not shown in the figure),

[0037] The first synchronous clock module 12 is used to periodically send clock synchronization instructions;

[0038] The first data synchronization module 14 is used to respectively encapsulate the database operation instructions recorded between two adjacent clock synchronization instructions sent by the first synchronization clock module 12 into first operation instructions for each first master database block, and send the ...

Embodiment 2

[0070] This embodiment provides another distributed database cluster system. The distributed database cluster system can be used as the receiving end of data synchronization. Of course, when it is also given the function of the initiator of data synchronization, it can also be used as the initiator of data synchronization. At this time, you can refer to Embodiment 1 . Figure 4 is a schematic diagram of the architecture of the distributed database cluster system according to Embodiment 2 of the present invention, such as Figure 4 As shown, the distributed database cluster system may include: a second data synchronization module 42 and a plurality of second database groups 44, wherein each second database group 44 in the plurality of second database groups 44 includes a first Two main databases (not shown in the figure),

[0071] The second data synchronization module 42 is configured to receive an operation instruction block sent by the peer distributed database cluster sys...

Embodiment 3

[0090] This embodiment describes the processing flow of the initiator of data synchronization. Figure 6 is a flowchart of a data synchronization method according to Embodiment 3 of the present invention. The data synchronization method is applied to a first distributed database cluster system including a plurality of first database groups 16, wherein each first database group 16 in the plurality of first database groups 16 includes a first master database. Such as Figure 6 As shown, the method includes:

[0091] Step S602, the first distributed database cluster system regularly sends clock synchronization instructions;

[0092] Step S604, the first distributed database cluster system respectively encapsulates the database operation instructions recorded between two adjacent clock synchronization instructions of each first master database into a first operation instruction block, and sends the first Operation instruction block.

[0093] Through the above scheme, the first...

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 distributed database cluster system, a data synchronization method and a storage medium. The distributed database cluster system comprises a first synchronous clock module, afirst data synchronization module and a plurality of first database groups, each first database group in the plurality of first database groups comprises a first main database, and the first synchronous clock module is used for periodically sending a clock synchronization instruction; and the first data synchronization module is used for respectively packaging database operation instructions recorded by each first main database between two adjacent clock synchronization instructions sent by the first synchronization clock module into a first operation instruction block and sending the first operation instruction block. According to the method and the device, the problem that global consistency of time points can not be achieved by data synchronized by different data nodes in related technologies is solved, so that data records synchronized by different data nodes are based on the same time reference point, and the global consistency of the recorded data is ensured.

Description

technical field [0001] The invention relates to the field of distributed databases, in particular to a distributed database cluster system, a data synchronization method and a storage medium. Background technique [0002] In recent years, more and more organizations have begun to pay attention to and use open source database products, such as MySQL (SQL stands for Structured Query Language, that is, Structured Query Language). With the development of business and technology, database technology is developing in the direction of clustering. The data synchronization technology between clusters is the basic technology of the disaster preparedness scheme. It is of great and far-reaching significance to carry out research on efficient and consistent data synchronization methods between two data centers. [0003] At present, in the field of distributed databases, data synchronization between data clusters mainly relies on point-to-point data migration. However, due to various fa...

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): G06F16/27G06F16/23G06F16/242G06F16/18G06F9/46G06F9/48G06F9/50G06F9/54
CPCG06F9/466G06F9/4881G06F9/5016G06F9/546G06F2209/548G06F2209/5018G06F16/1815G06F16/2365G06F16/2438G06F16/27G06F16/23G06F9/48G06F9/54G06F16/18G06F9/46G06F16/242G06F9/50G06F16/00
Inventor 戴扶罗圣美付裕钱煜明
Owner 金篆信科有限责任公司
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