Method for synchronous data time delay detection between master database and slave database
A data synchronization and delay detection technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of wrong judgment, data synchronization delay T2 time delay is small, too small, etc., to achieve accuracy improvement, Small error, high accuracy effect
Active Publication Date: 2016-05-18
CHINA UNIONPAY
View PDF5 Cites 22 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] However, the above-mentioned existing technical solutions have the following problems: (1) Since the calculated data synchronization delay does not include the time T1 for the operation of "transmitting the newly generated log in the master database log to the slave database" (that is, the master-slave The time delay caused by transferring related logs between databases), so the calculated data synchronization delay T2 is always smaller than the actual time delay (T1+T2), and when the logs in the master database cannot be transmitted to the slave database in time ( For example, the network transmission is abnormal), the value of T1 will become larger, and the value of T2 will become smaller (or even 0) due to no new log incoming. At this time, the value of T2 will be seriously smaller than the actual time delay value, which will lead to Maintenance personnel misjudged the data synchronization status of the master-slave database; (2) Since the value unit of T2 is usually seconds, the data accuracy cannot meet the occasions that require high delay precision control
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
[0025] figure 1 It is a flowchart of a method for detecting data synchronization delay between master and slave databases according to an embodiment of the present invention. Such as figure 1 As shown, the method for detecting data synchronization delay between master and slave databases disclosed in the present invention includes the following steps: (A1) Each operation performed on the data in the master database (such as update, delete, insert, etc.) The information is recorded in the main database log, where the operation on the data in the main database includes the auxiliary operation periodically performed on the detection data table, the information of the auxiliary operation is used as the detection point, and the execution of the auxiliary operation is completed Time T1 is recorded; (A2) periodically transfer the newly generated log records in the master database log to the slave database; (A3) the slave database updates the slave database log based on the newly gene...
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 invention provides a method for synchronous data time delay detection between a master database and a slave database. The method comprises the steps as follows: information of each executed operation for data in the master database is recorded into a master database log; newly generated log records in the master database log are periodically transferred to the slave database; the slave database updates a slave database log on the basis of the received and newly generated log records in the master database log, records the updating time of each newly generated log information, and sequentially executes the operations indicated by the newly generated log records in the updated slave database log aiming at the data in the slave database; and the slave database is periodically detected in a polling mode at a preset frequency to sequentially determine whether the operations indicated by the newly generated records which are related to an auxiliary operation, in the updated slave database log are finished or not. The method provided by the invention has high accuracy and precision.
Description
Technical field [0001] The present invention relates to a method for delay detection, and more specifically, to a method for delay detection of data synchronization between master and slave databases. Background technique [0002] At present, with the increasing application of computers and networks and the increasing variety of business types in different fields, it is becoming more and more important to determine the data synchronization delay between master and slave databases in real time and accurately. [0003] In the existing technical solutions, the data synchronization delay between the master and slave databases is typically calculated in the following way: the master database periodically updates the master database log (which records every operation that has been implemented on the master database) The generated log is transmitted to the slave database, and the slave database updates the slave database log based on the newly generated log received, that is, implements t...
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 Applications(China)
IPC IPC(8): G06F11/34G06F17/30
Inventor 刘亦龙
Owner CHINA UNIONPAY