Database synchronization method and device, server, and storage medium

A technology for synchronizing devices and databases, applied in the field of databases, can solve the problems of difficulty in meeting the needs of scenarios and high data delay between master and slave databases, and achieve the effect of improving the granularity of parallel processing and the speed of synchronization.

Active Publication Date: 2019-01-25
BEIJING BAIDU NETCOM SCI & TECH CO LTD
View PDF7 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the existing technology, the replication or backup between the master library and the slave library is usually based on the data table (Table) level, but in some scenarios with high write throughput

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database synchronization method and device, server, and storage medium
  • Database synchronization method and device, server, and storage medium
  • Database synchronization method and device, server, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] In order to make the purpose, technical solution and advantages of the application more clear, the technical solution in the embodiment of the application will be described in more detail below in conjunction with the drawings in the embodiment of the application. In the drawings, the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The described embodiments are some, but not all, embodiments of the application. The embodiments described below by referring to the figures are exemplary, and are intended to explain the present application, and should not be construed as limiting the present application. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of this application. Embodiments of the present application will be described in detail below in conjunction with th...

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

No PUM Login to view more

Abstract

The invention provides a database synchronization method and device, a server and a storage medium, belonging to the field of databases. One embodiment of the method comprises the following steps: obtaining a data change log; analyzing a data change log to obtain a data change record having a tablespace name and a page number, and distributing the data change record to a plurality of areas to be synchronized according to the tablespace name and the page number; starting the same number of working threads as the area to be synchronized, and processing the change of the data change record in thearea to be synchronized in parallel; and after all the worker threads finish the change of the data change record, executing the transaction operation of the data change record, and completing the database synchronization. The database synchronization method and device, server, and storage medium of the present invention can improve the parallel granularity of the data table by copying the analyzed change record in parallel according to the data page level, thereby greatly improving the synchronization speed of the data.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a database synchronization method, device, server and storage medium. Background technique [0002] In database applications, in order to deal with the huge amount of data access, the master-slave (Master-Slave) database architecture mode is usually adopted. Query operations to reduce the access pressure on the main library and improve business capabilities. In the master-slave database mode, in order to meet the read-write consistency of the business, it is necessary to shorten the data delay between the master database and the slave database as much as possible. [0003] In the existing technology, the replication or backup between the master library and the slave library is usually based on the data table (Table) level, but in some scenarios with high write throughput pressure, the data volume of the data table can reach gigabytes (GB) level , in this case, the d...

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
no application Login to view more
IPC IPC(8): G06F16/27G06F16/23
Inventor 王天宇
Owner BEIJING BAIDU NETCOM SCI & TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap