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

Data synchronization method and system of distributed database, terminal and storage medium

A data synchronization and database technology, applied in the field of distributed databases, can solve the problems of reading results not being up to date, data not being up-to-date, etc., to achieve the effect of reliable design principle, simple structure and wide application prospect.

Pending Publication Date: 2022-03-29
SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] For the above-mentioned third synchronous replication technology, the master database responds to the user that the synchronization is successful after receiving a signal that a part of the slave database is successfully synchronized. At this time, the following problem occurs: the data of some of the slave databases (not updated successfully) is not up-to-date Yes, if the client accesses these nodes to read data at this time, the read results will not be up-to-date

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 system of distributed database, terminal and storage medium
  • Data synchronization method and system of distributed database, terminal and storage medium
  • Data synchronization method and system of distributed database, terminal and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] In order to enable those skilled in the art to better understand the technical solutions in the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described The embodiments are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0040] figure 1 is a schematic flowchart of a method in one embodiment of the present invention. in, figure 1 The execution subject may be a data synchronization system of a distributed database.

[0041] Such as figure 1 As shown, the method includes:

[0042] Step 110, generating an index for the object data for which the master ...

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 relates to the technical field of distributed databases, and particularly provides a data synchronization method and system for a distributed database, a terminal and a storage medium, and the method comprises the steps: generating an index for object data for executing an updating operation by a master node, and synchronizing the object data and the corresponding index to a slave node; periodically acquiring the latest index of the slave node, and checking the consistency of the latest index and the local latest index of the master node; if the latest index of the slave node does not pass the consistency verification, searching a positioning index matched with the latest index of the slave node in the master node; and synchronizing the index of which the operation time is after the positioning index and the corresponding object data to the slave node. According to the method and the device, the final consistency of the data of each node of the whole MySQL cluster can be realized, so that correct data can be returned to the client by the node which is recovered after a fault occurs.

Description

technical field [0001] The invention relates to the technical field of distributed databases, in particular to a data synchronization method, system, terminal and storage medium of a distributed database. Background technique [0002] With the advent of the mobile Internet era, there are more and more smart devices, more and more data storage, and the frequency and concurrency of users reading and writing data are also increasing. Traditional stand-alone databases cannot meet the requirements of massive data storage and concurrency. processing needs. More and more enterprises choose to use distributed database clusters, such as MySQL database clusters. The essence of using a distributed cluster is data replication between each node, and the accompanying problem is the consistency of the data of each node in the cluster, that is, only when the data in the master-slave database remains consistent, can the master-slave be replaced. Currently, the data replication technologies...

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/28G06F16/2455G06F16/23G06F16/22
CPCG06F16/275G06F16/22G06F16/2455G06F16/2365G06F16/284
Inventor 何金彪刘洋
Owner SUZHOU LANGCHAO INTELLIGENT 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