Data synchronization method and data synchronization system based on log analysis
A data synchronization and log technology, applied in the direction of file system, database update, file system functions, etc., can solve the problems of wasting disk space, slowing down the restart process of log synchronization service, etc., to reduce the impact of performance and ensure accuracy Effect
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0058] In the source database and destination database deployment synchronization system, the source database synchronization system reads the log from the source database, while the destination database synchronization system is responsible for applying the synchronization operation sent by the source to the destination database.
[0059] In a system based on log parsing synchronization, the source log analysis module stores the database object definition information to the local, the offline dictionary file has a significant advantage than using the connection online database to take the log, the former In addition to supporting DDL operation synchronization, it is also possible to implement log resolution during log resolution, and log resolution can still be performed in the case of abnormal source database. The method of data synchronization based on offline dictionary files is specifically described below, and managing the offline dictionary file in data synchronization.
[...
Embodiment 2
[0103] In the present embodiment, a specific example to perform the aforementioned method concise description of the process, for example as follows:
[0104] Source database sequentially perform the following operations:
[0105] CREATE TABLE T1 (C INT);
[0106] INSERT INTO T1 (C) VALUES (1);
[0107] ALTER TABLE T1 ADD C1 INT;
[0108] INSERT INTO T1 (C) VALUES (2);
[0109] ALTER TABLE T1 ADD C2 INT;
[0110] INSERT INTO T1 (C) VALUES (3);
[0111] DROP TABLE T1;
[0112] In the above-described operation will be log stream source produces the following transactions:
[0113] Transaction number operate TRX1 (LSN = 1) Create (T1), Object ID = 1000 TRX2 (LSN = 2) INSERT (c = 1) TRX3 (LSN = 3) ALTER (Add C1) TRX4 (LSN = 4) INSERT (c = 2) TRX5 (LSN = 5) ALTER (Add C2) TRX6 (LSN = 6) INSERT (c = 3) TRX7 (LSN = 7) Drop (t1)
[0114] The assumption is invalid version accounted for 50% it needs to be cleaned, dictionary maintenance proce...
Embodiment 3
[0127] See Figure 8 , Figure 8 It is a structural diagram of a data synchronization system according to an embodiment of the present invention. The data synchronization system of the present embodiment includes one or more processor 41 and a memory 42. in, Figure 8 Taking a processor 41 as an example.
[0128] Processor 41 and memory 42 can be connected by bus or other means, Figure 8 In connection with the bus connection.
[0129] The memory 42 can be used as a non-volatile computer readable storage medium based on a data synchronization method, and can be used to store non-volatile software programs, non-volatile computer executives, and modules, methods of the above embodiment, and corresponding procedures. instruction. The processor 41 performs various functional applications and data processing by running the nonvolatile software program, instructions and modules stored in memory 42, and implements a method of implementing the foregoing embodiments.
[0130] The memory 42 can...
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