Data synchronization method and apparatus
A data synchronization and data technology, applied in the computer field, can solve problems such as reducing the efficiency of incremental data synchronization, and achieve the effect of improving synchronization efficiency
Active Publication Date: 2018-06-26
TENCENT TECH (SHENZHEN) CO LTD
View PDF6 Cites 7 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
There is a strong correlation between the log and the version of the database. Therefore, for two databases with different versions, it is impossible to synchronize incremental data through the log.
Moreover, the synchronization method of the incremental data of the current database is based on a single process, that is, it is necessary to synchronize all the incremental data to other databases through a single process. For example, in the case of large concurrent writes, the incremental data will be The generation is relatively fast, therefore, the synchronization method based on a single process will greatly reduce the synchronization efficiency of incremental data
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
[0022] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.
[0023] See figure 1 , is a schematic flowchart of a data synchronization method provided by an embodiment of the present invention, and the method may include:
[0024] S101. Obtain a data operation instruction, execute a data processing service according to the data operation instruction, and record the total incremental data generated based on the data processing service;
[0025] Specifically, the server may obtain the data operation instruction sent by the use...
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
Embodiments of the invention disclose a data synchronization method and apparatus. The method comprises the steps of obtaining a data operation instruction, executing a data processing business according to the data operation instruction, and recording total incremental data generated based on the data processing business, wherein the total incremental data is logic statement-based incremental data; searching for at least one first data table associated with the total incremental data, wherein each first data table comprises corresponding table incremental data, and the sum of the table incremental data corresponding to the first data tables is the total incremental data; and synchronizing the table incremental data in the first data tables to a target database in parallel. By adopting thedata synchronization method and apparatus, the incremental data synchronization can be performed among databases with different versions, and the synchronization efficiency can be improved.
Description
technical field [0001] The present invention relates to the field of computer technology, in particular to a data synchronization method and device. Background technique [0002] The current PostgreSQL (object-relational database management system) database usually records the incremental data generated by the modification of the database by various data processing services through logs, and then synchronizes the incremental data to other databases. The incremental data synchronization method of the database needs to be implemented through logs. However, there is a strong correlation between the log and the version of the database. Therefore, for two databases with different versions, the synchronization of incremental data cannot be realized through the log. Moreover, the synchronization method of the incremental data of the current database is based on a single process, that is, it is necessary to synchronize all the incremental data to other databases through a single pr...
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): G06F17/30
CPCG06F16/27
Inventor 胡森许中清李跃森刘煜宏
Owner TENCENT TECH (SHENZHEN) CO LTD