Method and equipment for replaying of binary-system log of relation-type database

A binary and database technology, applied in the computer field, can solve problems such as low binlog replay efficiency, binlog replay failure, and error codes, etc., to achieve the effect of improving replay efficiency

Active Publication Date: 2017-08-29
ALIBABA GRP HLDG LTD
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of this application is to provide a method and device for replaying binary logs of relational databases, so as to solve the problem of analyzing the binary logs (binlog) that need to be replayed by sampling binary log analysis tools in the prior art. Threads lead to low efficiency of binlog replay, and the execution event (event) in the binlog that needs to be replayed is too large or there is an error code in the event record, which may cause the replay failure of the binlog replay process

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
  • Method and equipment for replaying of binary-system log of relation-type database
  • Method and equipment for replaying of binary-system log of relation-type database
  • Method and equipment for replaying of binary-system log of relation-type database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The application will be described in further detail below in conjunction with the accompanying drawings.

[0032] figure 1 A schematic structural diagram of a device for replaying binary logs of a relational database according to one aspect of the present application is shown. The device 1 comprises acquisition means 11 , determination means 12 , modification means 13 and playback means 14 .

[0033] Wherein, the acquiring means 11 acquires the replay-related data to be restored from the backup set of the relational database service device to be replayed; the determining means 12 acquires the replay start point of the replay-related data, and obtains The binary log that needs to be replayed from the replay start point to the replay target point; the update device 13 stores the binary log that needs to be replayed in the corresponding relay log based on the relay log rule directory, and update the corresponding relay log site information file and relay log index file; ...

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 application aims to provide a method and equipment for replaying of a binary-system log of a relation-type database. Replaying related data to be recovered is acquired from a backup set of service equipment of the relation-type database to be replayed; a replaying starting site of the replaying related data is acquired, and the binary-system log to be replayed from the replaying starting site to a replaying target site is acquired; based on a relay log rule, the binary-system needing to be replayed is stored in a catalog corresponding to a relay log, and an information document of a corresponding relay log site and a relay log index document are updated; and a replication application thread is started and the relay log is analyzed and executed, so that the binary-system log can be replayed, replaying failure appearing during replaying of the binary-system log to be replayed can be avoided, and replaying efficiency of the binary-system log to be replayed is effectively increased.

Description

technical field [0001] The present application relates to the computer field, in particular to a technique for replaying binary logs of a relational database. Background technique [0002] With the continuous development of computer technology, due to misoperation and other reasons, there is often a need to restore the data in the database to a past point in time. For example, the binary log (binlog) in the relational database system (MySQL) will record the update operations related to the data in the database, and the regular backup set for the database is equivalent to the data archive point, so the binlog can be The records are applied to the backup set sequentially from front to back, and the database can be restored to the state at any point in time in the past. [0003] In the prior art, since the binary log (binlog) is a binary file and the relational database server (MySQL Server) can only execute a structured query statement (StructuredQuery Language, SQL), the use...

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/34G06F17/30
CPCG06F11/3476G06F16/284
Inventor 王波
Owner ALIBABA GRP HLDG 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