Performing a database backup based on automatically discovered properties
Properties of one or more databases of nodes of a database system are automatically discovered. The automatically discovered properties for at least one of the databases include a database architecture and a corresponding failover role for each of at least some of the nodes. Based at least in part on the discovered properties, a corresponding one of the nodes as a corresponding backup source node is selected for each of the one or more databases. One or more database backups are allowed to be performed via the one or more selected backup source nodes.
1. A method, comprising:
automatically discovering, by a secondary storage system, properties of one or more databases running in a database system that includes a plurality of nodes, wherein the automatically discovered properties for at least one of the databases include a corresponding database architecture and a corresponding failover role for each of at least some of the nodes, wherein automatically discovering properties of one or more databases running in the database system includes receiving at the secondary storage system from each of the plurality of nodes a corresponding list that indicates one or more corresponding databases running on the corresponding database node;
based at least in part on the discovered properties, selecting, by the secondary storage system, for each of the one or more databases, a corresponding one of the nodes as a corresponding backup source node; and
allowing one or more database backups to be performed via the one or more selected backup source nodes.
2. The method of claim 1 , wherein automatically discovering properties of the one or more databases of the nodes of the database system includes determining whether a database of the one or more databases is a stand-alone database or a database instance that is part of a database cluster.
3. The method of claim 2 , wherein one of the selected backup source nodes hosts an active database service.
4. The method of claim 2 , wherein one of the selected backup source nodes hosts a stand-alone database that has a standby role.
5. The method of claim 1 , wherein the corresponding failover role for the at least one of the databases is active, standby, or passive.
6. The method of claim 1 , further comprising registering one or more of the nodes.
7. The method of claim 6 , further comprising installing a corresponding backup agent to the one or more registered nodes.
8. The method of claim 7 , wherein the corresponding backup agent is configured to send to a processor of the node on which the corresponding backup agent is installed a first request for the corresponding list of one or more databases running on the node.
9. The method of claim 8 , wherein at least one of the one or more databases included in the corresponding list of one or more databases is part of a database cluster.
10. The method of claim 9 , wherein the corresponding backup agent is configured to send to the processor of the node on which the corresponding backup agent is installed a second request for a list of one or more other nodes associated with the database cluster.
11. The method of claim 1 , further comprising receiving from a backup agent installed on one of the nodes updated role information associated with the database.
12. The method of claim 11 , further comprising updating primary system configuration information based on the updated role information.
13. The method of claim 12 , wherein a set of one or more commands used to perform a database backup is based on the updated role information.
14. The method of claim 12 , wherein a set of one or more commands used to perform a database backup is based on the corresponding database architecture.
15. The method of claim 1 , wherein the corresponding database architecture is a database cluster and the corresponding failover role for each of at least some of the nodes is a primary database role or a standby database role.
16. A system, comprising:
one or more processors configured to:
automatically discover properties of one or more databases running in a database system that includes a plurality of nodes, wherein the automatically discovered properties for at least one of the databases include a corresponding database architecture and a corresponding failover role for each of at least some of the nodes, wherein automatically discover properties of one or more databases running in the database system, the one or more processors are configured to receive from each of the plurality of nodes a corresponding list that indicates one or more corresponding databases running on the corresponding database node;
based at least in part on the discovered properties, select for each of the one or more databases, a corresponding one of the nodes as a corresponding backup source node; and
allow one or more database backups to be performed via the one or more selected backup source nodes; and
a memory coupled to the one or more processors and configured to provide the one or more processors with instructions.
17. The system of claim 16 , wherein to automatically discover properties of the one or more databases of the nodes of the database system, the one or more processors are further configured to determine whether a database of the one or more databases is a stand-alone database or a database instance that is part of a database cluster.
18. The system of claim 17 , wherein one of the selected backup source nodes hosts an active database service.
19. The system of claim 17 , wherein one of the selected backup source nodes hosts a stand-alone database that has a standby role.
20. A non-transitory computer readable storage medium comprising computer instructions for:
automatically discovering, by a secondary storage system, properties of one or more databases running in a database system that includes a plurality of nodes, wherein the automatically discovered properties for at least one of the databases include a corresponding database architecture and a corresponding failover role for each of at least some of the nodes, wherein automatically discovering properties of one or more databases running in the database system includes receiving at the secondary storage system from each of the plurality of nodes a corresponding list that indicates one or more corresponding databases running on the corresponding database node;
based at least in part on the discovered properties, selecting, by the secondary storage system, for each of the one or more databases, a corresponding one of the nodes as a corresponding backup source node; and
allowing one or more database backups to be performed via the one or more selected backup source nodes.