Hot backup method and system for 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, fast speed and saving storage space.

Active Publication Date: 2017-01-25
广州鼎甲计算机科技有限公司
View PDF2 Cites 20 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
  • Hot backup method and system for MySQL database
  • Hot backup method and system for 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 invention relates to the technical field of backup and recovery of databases, in particular to a hot backup method for a MySQL database. The hot backup method includes the steps: firstly checking a log sequence number of the MySQL database when backup begins, and then performing backup for data files of the MySQL database; simultaneously and circularly checking redo logs of the MySQL database in the backup process of the data files, performing backup for modification of the data files in the backup process, recoding logs into a file when log sequence numbers in redo logs are larger than log sequence numbers beginning backup, and storing the file to a shared storage device; recording a log sequence number after backup is finished to prepare for next backup. The invention further provides a hot backup system for the MySQL database. Compared with the prior art, the technical scheme is rapid in backup and recovery and overcomes the shortcoming that running MySQL database must be stopped before backup, and MySQL database services are less affected.

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