Log reading method based on log analysis synchronization and data synchronization system
A log and database technology, applied in the field of log reading method and data synchronization system based on log parsing and synchronization, can solve problems such as data synchronization errors
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0048] At present, although the data lock technology can only allow one process to access a certain file, the data lock is applicable to the same type of database or the database of the same manufacturer. The write operations on one side and the read operations on the destination database side originate from databases of two different manufacturers, so the above data lock cannot be used, and the method in this embodiment is applicable to databases of different sources or types.
[0049] combine image 3 , in this embodiment, a synchronization system is deployed on the source database and the destination database, the source database synchronization system reads logs from the source database, and the target database synchronization system is responsible for sending the synchronization operation application from the source to the destination database.
[0050] Among them, when the source-side data synchronization system starts, it needs to initialize an LSN information linked l...
Embodiment 2
[0085] Based on the aforementioned embodiment 1, here, taking ORACLE as an example, the implementation process of the aforementioned embodiment 1 is illustrated:
[0086] Build a data synchronization system on database A and database B, and set the minimum delay of data synchronization to Y seconds, set the time interval for polling the database log sequence number to Z seconds, and the source data synchronization system is in the database An auxiliary table T (C INT) is created on A to advance the log.
[0087] The database interaction process of the source log synchronization system is as follows:
[0088] (1) The database interaction thread obtains the largest log LSN and current time of the current database from the source database every Z seconds, and the obtained SQL is select dbms_flashback.get_system_change_number,sysdate from dual; get the value of the log serial number LSN and time for LSN1 and TIME1.
[0089] Step (2) Save LSN1 and TIME1 in the LSN information cha...
Embodiment 3
[0096] see Figure 4 , Figure 4 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 4 A processor 41 is taken as an example.
[0097] Processor 41 and memory 42 can be connected by bus or other means, Figure 4 Take connection via bus as an example.
[0098] The memory 42, as a non-volatile computer-readable storage medium based on the log reading 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 the corresponding program instructions. 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.
[0099] Wherei...
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