Check patentability & draft patents in minutes with Patsnap Eureka AI!

Database log backup method, device and server

A database and server technology, applied in relational databases, database models, database distribution/replication, etc., can solve problems such as security risks, security and reliability risks, etc.

Active Publication Date: 2019-03-15
北京三快网络科技有限公司 +1
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the existing log backup technology, the database log files can be transferred in the form of files. The way of transferring database logs by means of files needs to obtain the login authority of the master server and the slave server to be backed up, which has certain security risks, and in the event of network problems, such as network When disconnected, it is often necessary to add additional mechanisms such as log retransmission and log content verification to improve the reliability of log transmission
It can be seen that there are certain risks in the security and reliability of database logs based on file transfer at present.

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 log backup method, device and server
  • Database log backup method, device and server
  • Database log backup method, device and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present application as recited in the appended claims.

[0035] The terminology used in this application is for the purpose of describing particular embodiments only, and is not intended to limit the application. As used in this application and the appended claims, the singular forms refer to the same or similar elements. The implementations described in the following exemplary embodiments do not represent all implementations consistent with ...

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 relates to a database log backup method and apparatus, and a server. The method comprises the steps of receiving a database log transmitted based on a master-slave synchronization mechanism by a master server; determining an operation type of database operation recorded in the database log; based on the operation type, determining a storage engine used for executing the database operation; and executing the database operation based on the storage engine and outputting a log backup file. In a configuration process, a slave server receives the database log by utilizing the master-slave synchronization transmission mechanism of MySQL, so that the reliability of log backup is improved; and the slave server executes the database log sent by the master server by using a black hole engine, so that the data storage overhead of the slave server can be reduced.

Description

technical field [0001] The present application relates to the technical field of database backup, in particular to a backup method, device and server for database logs. Background technique [0002] As a relational database widely used by Internet companies, MySQL database often needs to provide fixed-point recovery functions to support fault recovery and troubleshooting. In order to achieve fixed-point recovery of the database at any point in time, database backup technology often needs to combine regular full backup and incremental Volume backup, log backup is a commonly used incremental backup method. In the existing log backup technology, the database log files can be transferred in the form of files. The way of transferring database logs by means of files needs to obtain the login authority of the master server and the slave server to be backed up, which has certain security risks, and in the event of network problems, such as network When disconnected, it is often nec...

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 Patents(China)
IPC IPC(8): G06F11/14G06F16/28G06F16/27
CPCG06F11/1469G06F16/275G06F16/284
Inventor 易涵赵应刚
Owner 北京三快网络科技有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com