Database data real-time synchronization method and device
A real-time synchronization, database technology, applied in database distribution/replication, digital data processing, structured data retrieval, etc., can solve problems such as affecting synchronization applications, large synchronization delays, and slowing down synchronization software synchronization performance.
Active Publication Date: 2021-11-23
WUHAN DAMENG DATABASE
View PDF9 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
For batch data with a large amount of data, this processing flow will have lower synchronization efficiency.
For example, when the source database is in operation and maintenance, it will execute SQL statements to update or delete a large amount of data in batches. This operation and maintenance operation will generate a large number of logs. Synchronizing these operations will seriously slow down the synchronization performance of the synchronization software, resulting in Large synchronization delay, affecting synchronization applications
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0027] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, 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 embodiments It is a part of embodiments of the present invention, but not all embodiments. 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. In addition, the technical features in each embodiment or a single embodiment provided by the present invention can be combined arbitrarily with each other to form a feasible technical solution, but it must be based on the realization of those skilled in the art. When there is a contradiction or cannot be realized, it should be considered that ...
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
Login to View More Abstract
The embodiment of the present invention provides a database data real-time synchronization method and equipment. Wherein, the method includes: creating an auxiliary table in the source database, and inserting a synchronous SQL statement into the auxiliary table, the source database synchronization service captures and analyzes the transaction log of the source database, if the auxiliary table is parsed operation, then identify the transaction to which the auxiliary table operation belongs, and discard all operations in the transaction except the auxiliary table operation, obtain the analyzed message packet, and send it to the target-side database synchronization service; The service unpacks the analyzed message packet to obtain the SQL operation statement to be synchronized, and executes the SQL operation statement to be synchronized synchronously. The method and device for real-time synchronization of database data provided by the embodiments of the present invention can realize real-time synchronization of database data at a relatively fast rate.
Description
technical field [0001] Embodiments of the present invention relate to the technical field of database synchronization, and in particular, to a method and device for real-time synchronization of database data. Background technique [0002] Among the real-time database data synchronization technologies, the real-time data synchronization technology based on database log analysis has the characteristics of supporting heterogeneous operating systems and database platforms, less intrusiveness to the source database system, and low data synchronization delay. Extensive research and application. The log format and log content of heterogeneous database systems are quite different, so the log content of the data synchronization source database cannot be directly applied to the target database. The real-time data synchronization technology based on log analysis, the general principle is to capture the incremental log content of the source database, and then send it to the target term...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/27G06F16/242
Inventor 孙峰余院兰
Owner WUHAN DAMENG DATABASE