Parallel execution method based on log analysis synchronization and data synchronization system
An execution method and log technology are applied in the field of parallel execution methods and data synchronization systems based on log parsing and synchronization, and can solve problems such as slowing down synchronization and low replication efficiency.
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0055] In data synchronization, a synchronization system is deployed on the source database and the destination database. The source data synchronization system reads logs from the source database, while the destination data synchronization system is responsible for applying the synchronization operations sent by the source to the destination. terminal database.
[0056] Since existing data synchronization environments vary widely, in order to maximize synchronization efficiency, it is necessary to perform targeted optimization according to the characteristics of the current data synchronization environment, in order to optimize the synchronization performance in the current environment. The present invention customizes a synchronization optimization scheme specifically for a synchronization system that needs to strictly guarantee the order of transaction submission. In this system, when the transaction of the destination end is stored, the order of submission of the transactio...
Embodiment 2
[0128] Both the source database and the destination database have a table T (ID INT PRIMARY KEY, C1 INT). Among them, the source application has two transactions (TRX1 and TRX2) that operate on table T in parallel, and TRX1 inserts 10 rows of data into T table, ID from 1 to 10; TRX2 inserts 2 rows of data into the T table with IDs 20 and 21, and then updates a row of data with the updated ID 1, generating the following log:
[0129]
[0130]
[0131] The synchronous system at the destination end initializes two transaction execution threads, namely EXEC1 and EXEC2, and the above log execution process is as follows:
[0132] After the log receiving thread receives the above two transactions, it assigns TRX1 and TRX2 to two execution threads according to the order of transaction submission, assigns transaction TRX1 to transaction execution thread EXEC1, and assigns transaction TRX2 to transaction execution thread EXEC2. The following details this Two transaction execution ...
Embodiment 4
[0144] see Figure 5 , Figure 5 It is a schematic structural diagram of a data synchronization system provided by an embodiment of the present invention. The data synchronization system in this embodiment includes one or more processors 41 and a memory 42 . in, Figure 5 A processor 41 is taken as an example.
[0145] Processor 41 and memory 42 can be connected by bus or other means, Figure 5 Take connection via bus as an example.
[0146] The memory 42, as a non-volatile computer-readable storage medium based on a parallel execution method, can be used to store non-volatile software programs, non-volatile computer-executable programs and modules, the methods of the above-mentioned embodiments and corresponding programs instruction. The processor 41 executes various functional applications and data processing by running non-volatile software programs, instructions and modules stored in the memory 42 to implement the methods of the foregoing embodiments.
[0147] Where...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
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