Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data backup method and data backup device

A data backup and quantity technology, applied in the field of communications, can solve the problems of low data backup speed and low accuracy of transaction processing.

Active Publication Date: 2014-12-03
BEIJING OCEANBASE TECH CO LTD
View PDF5 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0033] The embodiment of the present application provides a data backup method and device to solve the problems of low data backup speed and low accuracy of transaction processing in the prior art

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 backup method and data backup device
  • Data backup method and data backup device
  • Data backup method and data backup device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] In order to improve the backup speed of the main library data by the standby database, the embodiment of the present application adopts multiple threads to process the operation records contained in multiple transactions in the relay log in parallel, and in order to ensure that all operation records contained in the same transaction Consistency of processing, all operation records contained in a transaction are processed by only one thread, so that the standby database can ensure the accuracy of transaction processing while improving the backup speed.

[0048] The embodiments of the present application will be described in detail below in conjunction with the accompanying drawings.

[0049] figure 2 The data backup process provided by the embodiment of this application specifically includes the following steps:

[0050] S201: The standby database uses unprocessed transactions recorded in the relay log as transactions to be allocated, and for the transactions to be all...

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 backup method and a data backup device, aiming at solving the problems that in the prior art, data backup is slower in speed and lower in accuracy. The method comprises the steps of aiming at an event to be dealt with, confirming a table identity (ID) and a sub-library ID corresponding to the table ID which are contained by the event to be dealt with; judging whether the assigned event which is in conflict with the event to be dealt with exists or not at present; if yes, assigning an event to be assigned into a waiting queue where the conflicting assigned event is positioned, and waiting for processing; if not, selecting one in waiting queues of all threads, and assigning the event to be assigned into the selected waiting queue, and waiting for processing. The method is used for dealing with the multiple events which are not in conflict with one another by arranging the multiple threads in parallel, and all the operating record contained in one event can be processed by one thread, so that the backup speed of a backup library can be effectively accelerated, the processing consistency of all the operating record contained in the same event can be guaranteed, and the event dealing accuracy of the backup library is improved.

Description

technical field [0001] The present application relates to the technical field of communications, and in particular to a data backup method and device. Background technique [0002] MySQL is a small relational database management system. Generally, MySQL includes a main database and a standby database. The main database is used to provide functions such as data management and data query, and the standby database is used to back up the data in the main database to provide corresponding functions instead of the main database when the main database fails. . [0003] figure 1 The process of backing up the data of the main library in MySQL to the backup library in the prior art specifically includes the following steps: [0004] S101: When the main library operates on its own data, it generates a corresponding operation record and records it in a binary log (binlog). [0005] Wherein, the operations performed by the main library on its own data include: update operations, inse...

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): G06F11/14G06F17/30
Inventor 刘辉翟卫祥
Owner BEIJING OCEANBASE TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products