Standby Database Backup Automation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database backup processes incur delays and resource contention, and require human intervention for authentication, making automation challenging and costly, especially in mission-critical systems.
Innovation Solution
Utilizing a disaster recovery infrastructure to perform backups on a standby database system, eliminating the need for additional password entries and allowing automated backup processing without human intervention.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If backup is performed on the primary database system, then data backup is completed, but system latency increases and workloads are delayed
Solution Approach 1:
The patent uses a standby database as a copy of the primary database to perform backup operations. The standby database replicates data from the primary database in real-time, allowing backup to be performed on the copy rather than the original, thus avoiding disruption to primary database workloads while maintaining backup reliability
Solution Approach 2:
The database system is segmented into a primary database for active workloads and a standby database for backup operations. This segmentation allows backup activities to be isolated from primary database operations, eliminating resource contention and latency issues while ensuring both functions can operate simultaneously
2Reliability
If backup is performed on the primary database system, then data backup is completed, but resource contention increases
Solution Approach 1:
By creating a copy (standby database) of the primary database, the system can perform backup operations on the copy without consuming resources from the primary database. This eliminates resource contention between backup processes and active workloads while maintaining backup integrity
Solution Approach 2:
The system segments database operations into two separate instances: the primary database handles transactional workloads while the standby database handles backup operations. This segmentation eliminates resource contention by ensuring backup activities do not compete for system resources with active database operations
3Adaptability or versatility
If backup is managed at a different computing node, then backup operations are distributed, but authentication requirements create automation barriers
Solution Approach 1:
The standby database is configured with the same authentication credentials and permissions as the primary database, merging the authentication context. This allows the standby database to perform backup operations autonomously without requiring separate authentication mechanisms or human intervention, enabling full automation of distributed backup operations
Data Source
AI summary
Disclosed is an improved system, method, and computer program product for generating backups in a database system. This is accomplished by using a disaster recovery infrastructure of a database system to generate the database backup, where the backup activities are performed on a standby database system, thereby freeing up the primary database system. To avoid authorization/authentication requirements between the primary and standby that may require human intervention to type passwords when backups are performed on the standby, a backup solution is provided that does not require human intervention to enter passwords when automating the backup process.