Systems and methods for intelligent availability in a database availability group
A method may include in response to a power event of a power system of an information handling system, determining if an uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to a database availability group. The method may also include if the uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to the database availability group, causing a shutdown of the information handling system initiated by a power manager of the uninterruptible power supply to abort, determining which of the one or more other information handling systems to switchover the database resources to, and causing switchover of the database resources based on such determination.
1. An information handling system comprising:
a processor;
a program of instructions implementing an application-level protocol, the program of instructions embodied in a computer-readable medium and configured to, when read and executed by the processor:
in response to a power event of a power system of the information handling system, determine if an uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to a database availability group; and
if the uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to the database availability group:
cause a shutdown of the information handling system initiated by a power manager of the uninterruptible power supply to abort;
determine which of the one or more other information handling systems to switchover the database resources to; and
cause switchover of the database resources based on such determination.
2. The information handling system of claim 1 , wherein determining if the uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to the database availability group comprises:
estimating a remaining available time of charge of the uninterruptible power supply; and
estimating a time required to switchover the database resources.
3. The information handling system of claim 1 , wherein determining which of the one or more other information handling systems to switchover the database resources to includes determining a power state of the one or more other information handling systems.
4. The information handling system of claim 1 , wherein determining which of the one or more other information handling systems to switchover the database resources to includes load balancing in order to distribute resources as evenly as possible among the one or more information handling systems.
5. The information handling system of claim 1 , wherein determining which of the one or more other information handling systems to switchover the database resources to includes determining resource utilizations of the one or more other information handling systems.
6. A method comprising:
in response to a power event of a power system of an information handling system, determining if an uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to a database availability group; and
if the uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to the database availability group:
causing a shutdown of the information handling system initiated by a power manager of the uninterruptible power supply to abort;
determining which of the one or more other information handling systems to switchover the database resources to; and
causing switchover of the database resources based on such determination.
7. The method of claim 6 , wherein determining if the uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to the database availability group comprises:
estimating a remaining available time of charge of the uninterruptible power supply; and
estimating a time required to switchover the database resources.
8. The method of claim 6 , wherein determining which of the one or more other information handling systems to switchover the database resources to includes determining a power state of the one or more other information handling systems.
9. The method of claim 6 , wherein determining which of the one or more other information handling systems to switchover the database resources to includes load balancing in order to distribute resources as evenly as possible among the one or more information handling systems.
10. The method of claim 6 , wherein determining which of the one or more other information handling systems to switchover the database resources to includes determining resource utilizations of the one or more other information handling systems.
11. An article of manufacture comprising:
a non-transitory computer-readable medium; and
computer-executable instructions carried on the computer-readable medium, the instructions readable by a processor, the instructions, when read and executed, for causing the processor to:
in response to a power event of a power system of the information handling system, determine if an uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to a database availability group; and
if the uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to the database availability group:
cause a shutdown of the information handling system initiated by a power manager of the uninterruptible power supply to abort;
determine which of the one or more other information handling systems to switchover the database resources to; and
cause switchover of the database resources based on such determination.
12. The article of claim 11 , wherein determining if the uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to the database availability group comprises:
estimating a remaining available time of charge of the uninterruptible power supply; and
estimating a time required to switchover the database resources.
13. The article of claim 11 , wherein determining which of the one or more other information handling systems to switchover the database resources to includes determining a power state of the one or more other information handling systems.
14. The article of claim 11 , wherein determining which of the one or more other information handling systems to switchover the database resources to includes load balancing in order to distribute resources as evenly as possible among the one or more information handling systems.
15. The article of claim 11 , wherein determining which of the one or more other information handling systems to switchover the database resources to includes determining resource utilizations of the one or more other information handling systems.