Database backup method and device

A database and backup technology, applied in database indexing, structured data retrieval, electronic digital data processing, etc., can solve the problems of large space occupied by backup files, long backup cycle, long recovery cycle, etc., to speed up backup speed and improve efficiency And, the effect of reducing space occupation

Active Publication Date: 2017-02-22
INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF10 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to provide a database backup method and device to solve the problems of long backup period, long recovery period and large space occupied by backup files in the existing mysql large-scale database scene

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0075] As a specific implementation manner, this embodiment may further include:

[0076] Cleanup module, used to clean up expired data when preset conditions are met

[0077] The data backup device provided by this application quickly realizes the backup of the database in the scenario of a large mysql database, reduces the time for backup and recovery, reduces the space occupied by backup files, and improves the efficiency of backup and recovery and the security guarantee capability of the database.

[0078] Taking a specific project as an example, the annual capacity of the database that needs to be backed up in this project is estimated to be 2.5T, of which the business table data is only about 5G, and the rest is all historical data. After calculation, the historical data generated every day is about 10G. Assuming a full database Backup, the backup rate is 500G / H takes about 5 hours and the backed up files have no space to store; using the sub-table backup strategy only n...

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 database backup method and device. Data tables in a database are classified into historical data tables and real-time service data tables; full-volume backup is conducted on the service data tables; incremental backup is conducted on the historical data tables; the backed-up service data tables and historical data tables are stored in a medium to complete backup of the database. Due to the fact that historical data in a large mysql database occupies a large amount of storage space and real-time service data is less, the historical data tables and the real-time service data tables are backed up in a separated mode, the data volume each time of backup can be decreased, the backup time and recovery time can be shortened, and the backup speed can be improved. It is thus clear that backup of the database in a large mysql database scene is rapidly achieved, the backup recovery time is decreased, backup file space occupation is decreased, and the backup recovery efficiency and the safety guarantee capability of the database are improved.

Description

technical field [0001] The invention relates to the technical field of database backup, in particular to a database backup method and device. Background technique [0002] Data backup is the basis of disaster recovery, which refers to the process of copying all or part of the data set from the application host to other storage media in order to prevent data loss caused by system operation errors or system failures. Mysql is an open source relational database management system (RDBMS). The mysql database system uses the most commonly used database management language - Structured Query Language (SQL) for database management, and provides a community open source version of mysql. The backup tools provided are mysqldump, mysqlhotcopy, and text backup. The community open source version of Mysqlhotcopy only supports myisam engine backup. The Mysqldump command is a logical backup tool that comes with mysql, which can realize database-level and table-level backups. When backing u...

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
CPCG06F11/1451G06F16/22
Inventor 王萌
Owner INSPUR SUZHOU INTELLIGENT 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