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

A network-based system, the network-based system comprising:

• an initial server comprising an administrative database (admin DB);
• a target server coupled to the initial server and comprising a target database (target DB) 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;
• redirect the request to connect to the target DB from the initial server to the target server if the target DB does not reside on the initial server;
• 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;
• perform an 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.

A computer-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 a location of the target DB residing in the target server;
• switching an execution context from no database in the target server to a copy of the admin DB in the target server;
• performing 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.