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:
registering a database node associated with a database system based on registration information;
causing a backup agent to be installed on the registered database node;
automatically discovering properties of one or more databases running in the database system that includes the registered database node and one or more other database nodes, comprising:
determining architectures and corresponding failover roles associated with the one or more databases, wherein one database of the database system hosts an active database service and another database of the database system hosts a passive database service, wherein the one database is used as a failover in the event that the other database is not accessible; and
configuring the backup agent based on the determined architectures and the determined corresponding failover roles;
providing a command to perform a backup snapshot to the backup agent installed on the registered database node; and
receiving, by the database system, updated database role information from the backup agent, wherein the updated database role information changes a role of at least one of the one database and the other database;
updating system configuration information based on the received updated database role information; and
providing a set of one or more backup commands to the backup agent based on the updated system configuration information.
2. The method of claim 1 , further comprising receiving the registration information.
3. The method of claim 1 , wherein the registration information includes at least one of a single client access name (SCAN) name associated with a database, a virtual internet protocol address with the database node, or an internet protocol address associated with the database node.
4. The method of claim 1 , wherein a corresponding backup agent is installed on each of the one or more other database nodes.
5. The method of claim 1 , wherein causing the backup agent to be installed on registered database node includes sending, based on the registration information, a request to the registered database node.
6. The method of claim 1 , wherein the backup agent sends to a processor of the registered database node a list of the one or more other database nodes associated with the registration information.
7. The method of claim 6 , wherein the processor provides the backup agent a corresponding identifier associated with each of the one or more other database nodes.
8. The method of claim 7 , further comprising receiving the corresponding identifier associated with each of the one or more other database nodes.
9. The method of claim 8 , further comprising causing a corresponding backup agent to be installed on each of the one or more other database nodes.
10. The method of claim 9 , further comprising receiving from each of the corresponding backup agents a list of the one or more databases running on the one or more other database nodes.
11. The method of claim 1 , wherein the registration information is received for each of the one or more database nodes.
12. The method of claim 1 , wherein automatically discovering properties of one or more databases running in the database system further includes receiving one or more corresponding lists and corresponding role information associated with each of the one or more other database nodes.
13. The method of claim 1 , wherein in response to receiving the command the registered database node performs the backup snapshot.
14. A non-transitory computer readable storage medium comprising computer instructions for:
registering a database node associated with a database system based on registration information;
causing a backup agent to be installed on the registered database node;
automatically discovering properties of one or more databases running in the database system that includes the registered database node and one or more other database nodes, comprising:
determining architectures and corresponding failover roles associated with the one or more databases, wherein one database of the database system hosts an active database service and another database of the database system hosts a passive database service, wherein the one database is used as a failover in the event that the other database is not accessible; and
configuring the backup agent based on the determined architectures and the determined corresponding failover roles;
providing a command to perform a backup snapshot to the backup agent installed on the registered database node; and
receiving, by the database system, updated database role information from the backup agent, wherein the updated database role information changes a role of at least one of the one database and the other database;
updating system configuration information based on the received updated database role information; and
providing a set of one or more backup commands to the backup agent based on the updated system configuration information.
15. The non-transitory computer readable storage medium of claim 14 , further comprising computer instructions for receiving the registration information.
16. The non-transitory computer readable storage medium of claim 14 , wherein the registration information includes at least one of a SCAN name associated with a database, a virtual internet protocol address with one of the one or more database nodes, or an internet protocol address associated with the one of the one or more database nodes.
17. A system, comprising:
one or more processors configured to:
register a database node associated with a database system based on registration information;
cause a backup agent to be installed on the registered database node;
automatically discover properties of one or more databases running in the database system that includes the registered database node and one or more other database nodes, comprising to:
determine architectures and corresponding failover roles associated with the one or more databases, wherein one database of the database system hosts an active database service and another database of the database system hosts a passive database service, wherein the one database is used as a failover in the event that the other database is not accessible; and
configure the backup agent based on the determined architectures and the determined corresponding failover roles;
provide a command to perform a backup snapshot to the backup agent installed on the registered database node; and
receive, by the database system, updated database role information from the backup agent, wherein the updated database role information changes a role of at least one of the one database and the other database;
update system configuration information based on the received updated database role information; and
provide a set of one or more backup commands to the backup agent based on the updated system configuration information; and
a memory coupled to the one or more processors and configured to provide the one or more processors with instructions.