Database shutdown and restart stability optimizer
A separate, central server operating in a system including one or more database server machines and a graphical user interface displayed on a user's computer is disclosed and provides a technological improvement. In one example, computer-readable instructions are stored in computer memory on this shutdown control server. A user, such as a database administrator, may access the shutdown control server to initiate the shutdown, reboot, and/or restart of database services on one or more separate database servers. At least one advantage of such an arrangement is that the shutdown control server provides plug-and-play capabilities that may allow one or more database servers of one or more different database types to concurrently connect to the shutdown control server.
1. A method involving a central server machine, separate from a database server machine, communicatively coupled with a database administrator machine and the database server machine, the method comprising:
sending, by the central server machine to the database server machine, a sequence of commands;
receiving, by the central server machine from the database server machine, an indication that a predetermined criterion, for completing execution of the sequence of commands at the database server machine, has not been met;
postponing shutdown of the database server machine until the predetermined criterion has been met; and
sending, by the central server machine to the database server machine after the predetermined criterion has been met, a confirmation message for executing at least one of the sequence of commands.
2. The method of claim 1 , wherein the predetermined criterion has not been met when the database server machine has a future job scheduled during a downtime resulting from the shutdown of the database server machine, and the predetermined criterion has been met once the future job is completed.
3. The method of claim 1 , wherein the central server machine is configured to concurrently communicate with a plurality of database server machines.
4. The method of claim 1 , wherein the central server machine obtains a snapshot of the database server machine before issuing a restart command, and compares the snapshot of the database server machine to a saved snapshot of the database server machine to determine if the predetermined criterion has been met.
5. A device comprising a central server machine, separate from a database server machine, communicatively coupled with a database administrator machine and the database server machine, the central server machine comprising:
a processor configured to executed computer-executable instructions;
a memory storing computer-executable instructions that, when executed by the processor, cause the central server machine to:
receive a request to evaluate shutdown status of the database server machine comprising a service control manager;
send, by the central server machine to the database server machine, a sequence of commands;
receive, from the database server machine, an indication that a predetermined criterion, for completing execution of the sequence of commands at the database server machine, has not been met;
postpone shutdown of the database server machine until the predetermined criterion has been met; and
send, to the service control manager after the predetermined criterion has been met, a confirmation message to execute shutdown of the database server machine.
6. The device of claim 5 , wherein the predetermined criterion has not been met when the database server machine has a future job scheduled during a downtime resulting from the shutdown of the database server machine, and the predetermined criterion has been met once the future job is completed.
7. The device of claim 5 , wherein the memory of the central server machine stores database administration rules, database configuration information, and historical data about database discrepancies with corresponding responses.
8. The device of claim 7 , wherein the sequence of commands concludes with a restart command.
9. The device of claim 7 , wherein the sequence of commands comprises at least one of: a restart command and a shutdown command.
10. The device of claim 5 , wherein the central server machine is configured to concurrently communicate with a plurality of database server machines.
11. The device of claim 5 , wherein the central server machine stores database configuration information comprising database name and database type to permit a dynamic, plug-and-play feature for connecting with a plurality of database server machines of different database types.
12. The device of claim 5 , wherein the central server machine obtains a snapshot of the database server machine before issuing a restart command.
13. The device of claim 12 , wherein the central server machine compares the snapshot of the database server machine to a saved snapshot of the database server machine to determine if the predetermined criterion has been met.
14. The device of claim 5 , wherein the database server machine runs a relational database.
15. The device of claim 5 , wherein the database server machine runs a non-relational database.
16. The device of claim 5 , wherein the predetermined criterion has not been met when a log file of the database server machine is substantially full.
17. A non-transitory computer-readable storage medium storing computer-executable instructions that, when executed by a processor, cause a computing device to at least perform operations comprising:
sending, by a central server machine to a database server machine, a sequence of commands, wherein the central server machine is separate from the database server machine, but communicatively coupled with a database administrator machine and the database server machine;
receiving, by the central server machine from the database server machine, an indication that a predetermined criterion, for completing execution of the sequence of commands at the database server machine, has not been met;
postponing shutdown of the database server machine until the predetermined criterion has been met; and
sending, by the central server machine to the database server machine after the predetermined criterion has been met, a confirmation message for executing at least one of the sequence of commands.
18. The non-transitory computer-readable storage medium of claim 17 storing computer-executable instructions, wherein the predetermined criterion has not been met when the database server machine has a future job scheduled during a downtime resulting from the shutdown of the database server machine, and the predetermined criterion has been met once the future job is completed.
19. The non-transitory computer-readable storage medium of claim 17 storing computer-executable instructions, wherein the central server machine is configured to concurrently communicate with a plurality of database server machines.
20. The non-transitory computer-readable storage medium of claim 17 storing computer-executable instructions, wherein the central server machine obtains a snapshot of the database server machine before issuing a restart command, and compares the snapshot of the database server machine to a saved snapshot of the database server machine to determine if the predetermined criterion has been met.