Log backup method and log backup device

A backup and log technology, applied in the database field, can solve the problems of binary log loss, unrecoverable data, and failure to realize centralized management of logs, so as to achieve the effect of centralized management

Active Publication Date: 2014-04-30
BEIJING QIHOO TECH CO LTD
View PDF3 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] (1) To find the log, you need to find the server where the main library is located and log in to get the log. Centralized management of the log is not realized
[0005] (2) The real-time backup of the log is not implemented. If the server (Master) where the main library is located is down, the binary log is likely to be lost
[0006] (3) The binary log records all operations on the database and the time and execution time of the database operation. Therefore, once the data at a certain point in time (Point-in-time) needs to be restored, if there is no complete binary log log, even if there is a cold backup of the database, the data recovery cannot be completed
Since a cold backup occurs when the database has been shut down normally, a complete database is provided during a normal shutdown, therefore, performing a database file system backup while the database is open is ineffective, and cold backups alone can only provide For recovery to a certain point in time, the data not backed up to the point in time cannot be recovered

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
  • Log backup method and log backup device
  • Log backup method and log backup device
  • Log backup method and log backup device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0030] The technical scheme of the present invention can be applied to backing up log files, especially to backing up binary logs in a MySQL relational database. All changes to the database in the MySQL relational database are recorded in the binary log, and the database can be restored by backing up the binary log and combining the backup of the database.

[0031] like figure 1 as shown, figure 1 is a general flowchart of a log ...

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 log backup method and a log backup device. The log backup method includes starting one or a plurality of backup processes for performing backup on one or a plurality of log files corresponding to examples; scanning log files which are segmented by each backup process in each preset period and storing the log files segmented by each backup process. According to the technical scheme, the log backup method and the log backup device have the advantages that real-time backup can be performed on the log files, and the log files can be managed in a centralized manner.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a log backup method and device. Background technique [0002] The binary log file of the MySQL relational database is used to record all user operations on the database. Therefore, when an accident occurs in the database, the binary log file can be used to view the operations performed by the user during the time period recorded in this file, and then compare with the database Used in conjunction with backup, user operations can be reproduced to restore the database. [0003] However, there is no real-time backup solution for the binary log in the prior art. If the master server goes down, the binary log is likely to be lost, and data recovery cannot be completed. Moreover, since all records of database operations will be recorded in binary files, when the binary files are opened for a long time, the log files will become very large and occupy disk space. In the prior art, the...

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 QIHOO 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