Database Backup with Corrupted-Page Inspection for Recovery Reliability
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database backup methods fail to effectively handle corrupted pages, leading to incomplete backups and potential database crashes, especially in high-availability scenarios.
Innovation Solution
Perform corrupted-page inspection on metadata and data pages within a database, skipping backup for corrupted metadata pages and backing up corrupted data pages, ensuring a check and failure tolerance capability in the backup process.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If traditional backup methods are used without corrupted-page inspection, then backup speed is maintained, but backup completeness and reliability deteriorate due to silent errors in storage media
Solution Approach 1:
The patent performs corrupted-page inspection on the first page (metadata) before proceeding with the backup process. This preliminary check allows the system to identify and handle corrupted pages in advance, ensuring backup reliability without compromising overall backup speed by skipping inspection for subsequent pages when corruption is detected.
Solution Approach 2:
The patent divides the backup process into segments: first-page inspection, conditional second-page inspection, and backup execution. By segmenting the inspection process and applying it selectively rather than uniformly to all pages, the system maintains high reliability for critical metadata while preserving backup speed for data pages.
2Reliability
If corrupted-page inspection is performed on all pages, then backup reliability is improved, but system complexity and processing overhead increase
Solution Approach 1:
The patent applies different inspection strategies to different parts of the database structure: rigorous corrupted-page inspection is performed on the first page (metadata) which is critical for database integrity, while subsequent data pages receive conditional inspection only when the first page is normal. This local differentiation of inspection quality ensures reliability where most needed while reducing overall complexity.
3Loss of time
If backup is skipped when first page is corrupted, then processing time is reduced, but data loss risk increases
Solution Approach 1:
The patent implements a feedback mechanism where the inspection result of the first page determines the subsequent backup action. When the first page is corrupted, the system provides feedback to skip the backup process, preventing potential data loss from incomplete or corrupted backups. When the first page is normal, feedback allows the backup to proceed with conditional second-page inspection, balancing time efficiency with data protection.
Data Source
AI summary
This disclosure describes a database backup method and apparatus, and a computing device cluster. In embodiments, a first corrupted-page inspection operation is performed on a first page in a data table of a database, to determine a first inspection result, where the first is used to record metadata of the data table; the first page is backed up when the first inspection result indicates that the first page is a normal page; a second corrupted-page inspection operation is performed on a second page in the data table based on the first page, to determine a second inspection result, where the second is used to record data in the data table; and the second page is backed up when the second inspection result indicates that the second page is a corrupted page.