Automated discovery of databases
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.
1. A system, comprising:
a memory storing instructions; and
one or more processors coupled with the memory storing instructions that, when executed, perform operations comprising at least:
registering a host database at a backup service by connecting a backup node cluster to a host database node cluster;
triggering, based on host registration, an automatic host database discovery process to discover one or more undiscovered databases, the automatic host database discovery process using file metadata obtained by the host database node cluster;
discovering one or more databases based at least in part on one or more changes in the file metadata;
monitoring for changes in the one or more discovered databases based at least in part on changes in the file metadata; and
modifying a quantity of the one or more discovered databases based at least in part on the discovery of the one or more databases, wherein the modifying comprises adding or removing the one or more discovered databases from the host database node cluster.
2. The system of claim 1 , wherein modifying the quantity of the one or more discovered databases comprises:
adding or removing the one or more discovered databases from the host database node cluster in accordance with a periodicity, wherein the periodicity is based at least in part on the changes in the file metadata.
3. The system of claim 1 , wherein modifying the quantity of the one or more discovered databases comprises:
adding or removing the one or more discovered databases from the host database node cluster in real time based at least in part on the changes in the file metadata.
4. The system of claim 1 , wherein the operations further comprise:
installing a backup agent on at least one node of the host database node cluster, wherein the backup agent is associated with the backup service or a data management platform.
5. The system of claim 1 , wherein the host database is one of an Oracle, Linux, or AIX database and wherein a backup agent is supported to run on the host database.
6. The system of claim 1 , wherein the host database node cluster includes a Real Application Cluster (RAC).
7. The system of claim 1 , wherein the operations further comprise:
displaying the changes in the file metadata of one or more files in the host database on a user interface.
8. A method, comprising:
registering a host database at a backup service by connecting a backup node cluster to a host database node cluster;
triggering, based on host registration, an automatic host database discovery process to discover one or more undiscovered databases, the automatic host database discovery process using file metadata obtained by the host database node cluster;
discovering one or more databases based at least in part on one or more changes in the file metadata;
monitoring for changes in the one or more discovered databases based at least in part on changes in the file metadata; and
modifying a quantity of the one or more discovered databases based at least in part on the discovery of the one or more databases, wherein the modifying comprises adding or removing the one or more discovered databases from the host database node cluster.
9. The method of claim 8 , wherein modifying the quantity of the one or more discovered databases comprises:
adding or removing the one or more discovered databases from the host database node cluster in accordance with a periodicity, wherein the periodicity is based at least in part on the changes in the file metadata.
10. The method of claim 8 , wherein modifying the quantity of the one or more discovered databases comprises:
adding or removing the one or more discovered databases from the host database node cluster in real time based at least in part on the changes in the file metadata.
11. The method of claim 8 , further comprising:
installing a backup agent on at least one node of the host database node cluster, wherein the backup agent is associated with the backup service or a data management platform.
12. The method of claim 8 , wherein the host database is one of an Oracle, Linux, or AIX database and wherein a backup agent is supported to run on the host database.
13. The method of claim 8 , wherein the host database node cluster includes a Real Application Cluster (RAC).
14. The method of claim 8 , further comprising:
displaying the one or more changes in the file metadata in the host database on a user interface.
15. A non-transitory machine-readable medium including instructions, which when read by a machine, cause the machine to perform operations comprising:
registering a host database at a backup service by connecting a backup node cluster to a host database node cluster;
triggering, based on host registration, an automatic host database discovery process to discover one or more undiscovered databases, the automatic host database discovery process using file metadata obtained by the host database node cluster;
discovering one or more databases based at least in part on one or more changes in the file metadata;
monitoring for changes in the one or more discovered databases based at least in part on changes in the file metadata; and
modifying a quantity of the one or more discovered databases based at least in part on the discovery of the one or more databases, wherein the modifying comprises adding or removing the one or more discovered databases from the host database node cluster.
16. The non-transitory machine-readable medium of claim 15 , wherein modifying the quantity of the one or more discovered databases comprises:
adding or removing the one or more discovered databases from the host database node cluster in accordance with a periodicity, wherein the periodicity is based at least in part on the changes in the file metadata.
17. The non-transitory machine-readable medium of claim 15 , wherein modifying the quantity of the one or more discovered databases comprises:
adding or removing the one or more discovered databases from the host database node cluster in real time based at least in part on the changes in the file metadata.
18. The non-transitory machine-readable medium of claim 15 , wherein the operations further comprise:
installing a backup agent on at least one node of the host database node cluster, wherein the backup agent is associated with the backup service or a data management platform.
19. The non-transitory machine-readable medium of claim 15 , wherein the host database is one of an Oracle, Linux, or AIX database and wherein a backup agent is supported to run on the host database.
20. The non-transitory machine-readable medium of claim 15 , wherein the operations further comprise displaying the one or more changes in the file metadata of one or more files in the host database on a user interface.