Intelligent Log Gap Detection for Database Backup Promotion
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In high availability databases, gaps in the backup chain often occur due to unawareness among different backup platforms, leading to data loss during restoration, as they do not cross-share information effectively.
Innovation Solution
Implementing an intelligent log gap detection system that determines whether to perform a differential database backup or promote it to a full backup by matching or mismatching log sequence numbers (LSNs) across database failover clusters, ensuring data integrity and preventing data loss.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If multiple independent backup platforms are used for high availability databases, then backup redundancy is improved, but information sharing between platforms deteriorates, leading to backup chain gaps
Solution Approach 1:
The patent merges information from multiple independent backup platforms by implementing a centralized backup chain tracking system that collects and correlates backup information across different platforms. This allows the system to maintain backup redundancy while eliminating information silos, preventing backup chain gaps by providing a unified view of all backup operations across the distributed backup infrastructure.
2Productivity
If differential backup is performed without log gap detection, then backup speed is improved, but data integrity deteriorates due to potential data loss from backup chain gaps
Solution Approach 1:
The patent implements preliminary log gap detection before executing differential backup operations. By checking for log sequence number continuity and identifying potential backup chain gaps in advance, the system can determine whether a full backup is needed before attempting a faster differential backup. This preliminary action ensures data integrity is maintained while still allowing differential backups to proceed when safe, thus preserving both speed and reliability.
Data Source
AI summary
An intelligent log gap detection to ensure necessary backup promotion. Specifically, a method and system are disclosed, which entail determining whether to pursue a differential database backup or promote the differential database backup to a full database backup, in order to preclude data loss across high availability databases. The deduction pivots on a matching or mismatching between log sequence numbers (LSNs).