Data replication method and device, computer equipment and storage medium

A data replication and data technology, applied in the database field, can solve problems such as long time consumption, complicated parsing and playback work, and affecting data replication efficiency

Active Publication Date: 2019-09-06
SHENZHEN TENCENT COMP SYST CO LTD
View PDF4 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a data replication method, device, computer equipment, and storage medium, which can solve the problems of long time consumption, complex analysis and playback work, and affecting data replication efficiency when replicating data based on redo logs

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
  • Data replication method and device, computer equipment and storage medium
  • Data replication method and device, computer equipment and storage medium
  • Data replication method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0076] In order to make the object, technical solution and advantages of the present invention clearer, the implementation manner of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0077] Before introducing the embodiments of the present invention, some basic concepts in database technology need to be introduced:

[0078] The database involved in the embodiment of the present invention stores multiple data tables, and each data table can be used to store tuples. Wherein, the database may be any type of database based on MVCC (multi-version concurrency control, multi-version concurrency control). In this embodiment of the present invention, the type of the database is not specifically limited. It should be noted that the data in the above database is based on state attributes and can include three states: current state, transition state, and historical state. Each of the different status attributes in the data c...

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 discloses a data replication method and device, computer equipment and a storage medium, and belongs to the technical field of databases. The data replication method comprises the following steps: when a submitting operation of any transaction is detected, adding historical data of the transaction into a data queue; adding at least one piece of historical data in the data queue to any one of at least one sending buffer area; and when a first preset condition is met, replicating at least one piece of historical data in the sending buffer area to cluster equipment. According to theinvention, the node device does not need to convert the original historical data format into the log format, and the cluster equipment does not need to analyze the log into the data original format and then store the data original format, so that the tedious log playback process is avoided, and the efficiency of the data replication process is improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data duplication method, device, computer equipment and storage medium. Background technique [0002] In database technology, especially in OLAP (online analytical processing, online real-time analysis) processing systems, data warehouses, big data analysis and other scenarios, it is often necessary to copy data from the database and back up existing data in time. [0003] The replication process usually involves two devices, the host and the backup. For current databases (such as Oracle, MySQL, or InnoDB, etc.), the host can periodically copy the data files in the database to the backup to implement data file-based Master-standby synchronization. Further, in order to avoid data inconsistency between the master and the standby due to data file damage during the copy process, after the master and the standby establish a communication connection, a redo log (REDOLOG) is synchro...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/27
CPCG06F16/27G06F16/273G06F16/2365G06F16/2282G06F16/258
Inventor 李海翔
Owner SHENZHEN TENCENT COMP SYST 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