Automated Database Discovery Through Backup Agent Registration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database detection and registration in backup systems are manually error-prone and inefficient, particularly in large and complex enterprise environments, necessitating improved data management and storage solutions for reliable backup and fast recovery.
Innovation Solution
A networked computing system with a backup node cluster that automatically discovers undiscovered databases by installing a backup agent, registering the host, triggering a discovery process, receiving metadata, and communicating with the discovered database, utilizing a backup service to streamline the detection and registration process.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If manual database detection and registration is performed, then the backup system can identify databases, but the process is error-prone and inefficient
Solution Approach 1:
The backup agent automatically performs database discovery and registration by querying the host system for database instances, eliminating the need for manual detection and reducing human error while improving efficiency
Solution Approach 2:
The backup agent is installed on the host system in advance to continuously monitor and automatically register databases before backup operations are required, ensuring databases are discovered without manual intervention
2Productivity
If automated backup agent is installed and discovery process is triggered, then database discovery efficiency is improved, but system complexity increases
Solution Approach 1:
A backup agent is introduced as an intermediary component between the backup system and the host database system, automating the discovery process while managing complexity through a dedicated intermediary layer
Solution Approach 2:
The backup system is segmented into separate components: the backup node cluster, the backup agent installed on hosts, and the database discovery process, allowing each component to handle specific tasks and reducing overall system complexity
Data Source
AI summary
Techniques for database discovery are described. A networked computing system comprises a backup node cluster of a backup service in communication with a host database node cluster of a host, a host database at least initially undiscovered by the backup node cluster, one or more processors coupled with memory storing instructions that, when executed, perform operations comprising at least installing a backup agent on at least one node of the host database node cluster, registering the host at the backup service, based on the host registration, triggering a host database discovery process to discover the undiscovered database automatically, the discovery process including a discovery call, in response to the discovery call, receiving metadata relating to the discovered database, and communicating with the discovered database.