A kind of hot backup method and system of mysql database

A database and hot backup technology, which is applied in the direction of data error detection and response error generation, which can solve the problem of stopping the database and achieve the effect of fast backup speed, high speed and less server resource occupation.

Active Publication Date: 2019-09-17
广州鼎甲计算机科技有限公司
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to solve the technical problem that existing physical backup technology needs to stop the database

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
  • A kind of hot backup method and system of mysql database
  • A kind of hot backup method and system of mysql database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to facilitate the understanding of the present invention, the present invention will be further described below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the case of no conflict, the following embodiments and technical features can be combined arbitrarily to form a new implementation.

[0028] Such as figure 1 Shown, a kind of hot backup method of MySQL database, comprises:

[0029] Step S101: when the backup starts, first check the log sequence number of the MySQL database, and then back up the data files of the MySQL database;

[0030] Step S201: in the process of backing up the data files, check the redo log of the MySQL database cyclically at the same time, back up the modification of the data files in the backup process, and record the log sequence number in the redo log greater than the log sequence number at the beginning of the backup to A file, stored to the shared storage device;

[0031] St...

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 present invention relates to the technical field of backup and restoration of databases, in particular to a hot backup method for MySQL databases, comprising: when the backup starts, first checking the log sequence number of the MySQL database, and then backing up the data files of the MySQL database; During the process, the redo log of the MySQL database is checked cyclically at the same time, and the modification of the data file is backed up during the backup process. The log sequence number in the redo log is greater than the log sequence number at the beginning of the backup. The log is recorded in a file and stored in the shared storage Device; after the backup is completed, record the log sequence number at this time to prepare for the next backup. The invention also provides a hot backup system of MySQL database. Compared with the prior art, the technical scheme of the present invention has fast backup speed and fast recovery speed, overcomes the shortcoming that the MySQL database must be stopped before backup, and has less impact on the MySQL database business.

Description

technical field [0001] The invention relates to the technical field of database backup and restoration, in particular to a method and system for hot backup of a MySQL database. Background technique [0002] At present, the main backup methods of MySQL database are logical backup and physical backup. [0003] Logical backup mainly queries the table structure and data of the MySQL database, converts them into corresponding SQL statements, and stores them in a text file. It is a hot backup, and the database can still be used during the backup, but because it needs to occupy the resources of the MySQL database server for query, when the amount of data is large, the speed of logical backup is too slow, and it will have a great impact on the business of the database. Because it is backed up as an SQL statement, the SQL statement is re-executed when restoring, and the recovery speed is slow. [0004] Physical backup is mainly to copy data files directly from disk as a backup. It...

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/14
Inventor 范华王子骏樊立明马立珂杨海锋
Owner 广州鼎甲计算机科技有限公司
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