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

Method for remotely synchronizing SQL data in real time

A real-time synchronization and remote technology, applied in the field of database management, can solve the problem of slow call data and achieve the effect of convenient logic development

Inactive Publication Date: 2018-06-29
上海祈贝健康管理咨询有限公司
View PDF0 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] With the development of the times, data transmission is showing a global trend, but in the field of database management, it is very slow to transfer data from different places

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
  • Method for remotely synchronizing SQL data in real time

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0022] Such as figure 1 As shown, a method for synchronizing SQL data in real time in different places, the method for synchronizing SQL data in real time in different places may further comprise the steps:

[0023] Step S1: Parse the incremental log of the database;

[0024] The specific implementation manner of analyzing the incremental log of the database in the step S1 may be:

[0025] The incremental subscription component canal simulates the interactiv...

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 discloses a method for remotely synchronizing SQL data in real time. The method for remotely synchronizing the SQL data in real time comprises the steps of parsing increment logs of databases; conducting filtering processing on the parsed data; establishing links among the remote databases, and conducting delay optimization; distributing the data after being subjected to filtering processing into the corresponding remote databases according to demands. By means of the method, the high-latency data of the databases of multiple regions can be synchronized in real time, logic is developed conveniently, and the cross-region real-time data assess is facilitated.

Description

technical field [0001] The invention relates to the field of database management, in particular to a method for synchronizing SQL data in different places in real time. Background technique [0002] With the development of the times, data transmission is showing a global trend, but in the field of database management, it is very slow to transfer data from different places. Contents of the invention [0003] In view of the above-mentioned shortcomings existing at present, the present invention provides a method for real-time synchronization of SQL data in different places, which can realize ultra-long-distance real-time synchronization of MySQL. [0004] In order to achieve the above object, embodiments of the present invention adopt the following technical solutions: [0005] A method for synchronizing SQL data in real time in different places, the method for synchronizing SQL data in real time in different places may further comprise the steps: [0006] Parse the increm...

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): G06F17/30
CPCG06F16/27
Inventor 许德朕
Owner 上海祈贝健康管理咨询有限公司
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