Database Backup Load Balancing via Host-Database Mapping
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The existing methods for backing up databases inefficiently utilize computing resources, leading to performance issues due to uneven distribution of backup loads across hosts, which can result in bottlenecks and inefficient use of resources.
Innovation Solution
A method that generates a Database-Host Mapping (DHM) and a Host-Database Mapping (HDM) based on a preferred server order list (PSOL) to distribute the backup load among hosts, prioritizing hosts with greater resources and capacity, thereby optimizing the backup process.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If databases are backed up using existing methods, then backup operations are performed, but computing resources are inefficiently utilized leading to performance issues
Solution Approach 1:
The patent assigns different backup tasks to different hosts based on their specific resource capacities and current load conditions. Each host's backup capability is evaluated locally and matched with appropriate database backup tasks, ensuring that resources are optimally utilized according to local conditions rather than using a uniform allocation approach.
Solution Approach 2:
The system dynamically adjusts the distribution of backup loads among hosts based on real-time resource availability and load conditions. The backup management system continuously monitors host capacities and redistributes backup tasks dynamically, allowing the system to adapt to changing conditions and maintain optimal performance throughout the backup process.
2Productivity
If backup loads are distributed across multiple hosts, then backup capacity is increased, but uneven distribution causes bottlenecks
Solution Approach 1:
The patent implements a feedback mechanism where the backup management system continuously monitors the load and performance of each host during backup operations. Based on this feedback information, the system dynamically adjusts task allocation to balance loads and prevent bottlenecks, ensuring stable and reliable backup processes while maintaining high throughput.
Solution Approach 2:
The system transitions from static task allocation to dynamic load distribution, where backup tasks are continuously reassigned based on real-time host performance and load conditions. This dynamic approach allows the system to maintain optimal backup throughput while preventing bottlenecks by automatically adjusting to changing conditions.
3Quantity of substance
If more hosts are used for backups, then resource capacity is increased, but resource allocation becomes less efficient
Solution Approach 1:
The patent creates a universal backup management system that can efficiently allocate tasks across multiple hosts with different capabilities. The system evaluates and matches backup tasks with appropriate hosts based on their specific resources and capacities, ensuring that all available hosts are effectively utilized without waste, thereby converting heterogeneous resources into a coordinated multi-functional backup capacity.
Data Source
AI summary
A method for backing up databases includes generating a Database-Host Mapping (DHM) associated with a backup request in response to receiving the backup request, performing a database redistribution analysis based on the DHM and a preferred server order list (PSOL) to generate a Host-Database Mapping (HDM), and initiating a backup of a plurality of databases using the plurality of hosts specified in the HDM.