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.
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
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...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com