Methods and systems for auto-starting and auto-stopping databases
First Claim
1. A method comprising:
- accessing, by one or more processors of a target server in a network-based system, a redirect request to connect to a target database (target DB) located in the target server, the redirect request to connect derived from an initial request to connect to the target DB accessed by an initial server in the network-based system, a location of the target DB in the target server determined by an administrative database (admin DB) residing in the initial server, the admin DB including locations for a plurality of target DBs with a portion of the plurality of target DBs configured for auto-start procedures;
switching, by the one or more processors of the target server, an execution context from no database in the target server to a copy of the admin DB in the target server;
determining, by the one or more processors of the target server using the admin DB in the target server, that the target DB is configured for an auto-start procedure, the configuration of the target DB determined by matching an identification of the target DB within the initial request to an identification, of an auto-start database of the target server, stored in the admin DB;
determining, by the one or more processors of the target server using the admin DB in the target server, the target DB is executing an auto-stop procedure;
performing, by the one or more processors of the target server using the admin DB in the target server, an interrupt procedure resetting the target DB back to a running state, the interrupt procedure including at least a portion of the auto-start procedure to auto-start the target DB in the target server;
switching the execution context from the admin DB in the target server to the target DB in the target server; and
transmitting, via a network, a completion acknowledgement indicating the target server is connected to the target DB.
1 Assignment
0 Petitions
Accused Products
Abstract
Systems and methods are presented for auto-starting and auto-stopping databases in a cloud server environment. In some embodiments, a method includes accessing, by an initial server in a network-based system, a request to connect to a target database located in a target server of the network-based system. The method can include determining, by an administrative database residing in the initial server, a location of the target database residing in the target server, switching an execution context from no database in the target server to a copy of the administrative database in the target server, performing an auto-start procedure to auto-start the target database in the target server, switching the execution context from the administrative database in the target server to the target database in the target server, and transmitting a completion acknowledgement indicating the target server is connected to the target database.
-
Citations
18 Claims
-
1. A method comprising:
-
accessing, by one or more processors of a target server in a network-based system, a redirect request to connect to a target database (target DB) located in the target server, the redirect request to connect derived from an initial request to connect to the target DB accessed by an initial server in the network-based system, a location of the target DB in the target server determined by an administrative database (admin DB) residing in the initial server, the admin DB including locations for a plurality of target DBs with a portion of the plurality of target DBs configured for auto-start procedures; switching, by the one or more processors of the target server, an execution context from no database in the target server to a copy of the admin DB in the target server; determining, by the one or more processors of the target server using the admin DB in the target server, that the target DB is configured for an auto-start procedure, the configuration of the target DB determined by matching an identification of the target DB within the initial request to an identification, of an auto-start database of the target server, stored in the admin DB; determining, by the one or more processors of the target server using the admin DB in the target server, the target DB is executing an auto-stop procedure; performing, by the one or more processors of the target server using the admin DB in the target server, an interrupt procedure resetting the target DB back to a running state, the interrupt procedure including at least a portion of the auto-start procedure to auto-start the target DB in the target server; switching the execution context from the admin DB in the target server to the target DB in the target server; and transmitting, via a network, a completion acknowledgement indicating the target server is connected to the target DB. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A network-based system, the network-based system comprising:
-
an initial server comprising an administrative database (admin DB), the admin DB including locations for a plurality of target databases (target DB) with a portion of the plurality of target DBs configured for auto-start procedures; a target server coupled to the initial server and comprising a target DB of the plurality of target DBs and a copy of the admin DB; the initial server configured to access a request to connect to the target DB located in the target server of the network-based system; the admin DB of the initial server configured to; determine a location of the target DB residing in the target server; and redirect the request to connect to the target DB, from the initial server to the target server, upon determining the target DB resides on the target server; and the copy of the admin DB in the target server configured to; switch an execution context from no database in the target server to the copy of the admin DB in the target server; determine that the target DB is configured for an auto-start procedure, the configuration of the target DB determined by matching an identification of the target DB within the initial request to an identification, of an auto-start database of the target server, stored in the admin DB; determine the target DB is executing an auto-stop procedure; perform an interrupt procedure resetting the target DB back to a running state, the interrupt procedure including at least a portion of the auto-start procedure to auto-start the target DB in the target server; switch the execution context from the admin DB in the target server to the target DB in the target server; and transmit a completion acknowledgement indicating the target server is connected to the target DB. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A machine-readable medium embodying instructions that, when executed by a processor, perform operations comprising:
-
accessing a request at an initial server to connect to a target database (target DB) located in a target server of the network-based system; determining, by a processor using an administrative database (admin DB) of the initial server, a location of the target DB residing in the target server, the admin DB including locations for a plurality of target DBs with a portion of the plurality of target DBs configured for auto-start procedures; switching an execution context from no database in the target server to a copy of the admin DB in the target server; determining, by a processor using the admin DB in the target server, that the target DB is configured for an auto-start procedure, the configuration of the target DB determined by matching an identification of the target DB within the initial request to an identification, of an auto-start database of the target server, stored in the admin DB; determining by the one or more processors of the target server using the admin DB in the target server, the target DB is executing an auto-stop procedure; performing an interrupt procedure resetting the target DB back to a running state, the interrupt procedure including at least a portion of the auto-start procedure to auto-start the target DB in the target server; switching the execution context from the admin DB in the target server to the target DB in the target server; and transmitting a completion acknowledgement indicating the target server is connected to the target DB. - View Dependent Claims (18)
-
Specification