Methods and Systems for Auto-Starting and Auto-Stopping Databases

摘要

Systems and methods are presented for auto-starting and auto-stopping databases in a cloud server environment. In some embodiments, a method can include 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 also include determining, by an administrative database (admin 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 admin 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 admin 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 DB.

主权项

1. A method comprising:
accessing, by 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; switching an execution context from no database in the target server to a copy of the admin DB in the target server; performing, by the admin DB in the target server, an 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.