Forum Discussion
lardyboy_lardyb
Nimbostratus
Oct 05, 2004using iControl to down SQL svr based on BigIP node status
Guys
I have a customer who needs to shutdown a SQL server which is part of a MS Cluster based on the status of a node as presented on the BigIP. This control should then extend to disa...
Oct 05, 2004
I'm not sure what the best way to shutdown SQL Server is. I guess this depends on the platform you are using your monitoring application. It should be fairly straight forward to build an iControl app that monitors the status of a node. I'm assuming that you are using a SQL Monitor to get the status of the node. If so, then you can poll for the Availability state of the current monitor poll.
enum AvailabilityState
{
AVAILABILITY_UNCHECKED = 0,
AVAILABILITY_DOWN = 1,
AVAILABILITY_UP = 2,
AVAILABILITY_CHECKING = 3,
AVAILABILITY_FORCED_DOWN = 4,
AVAILABILITY_ADDR_DOWN = 5,
AVAILABILITY_UNKNOWN = 6,
AVAILABILITY_MAINT = 7,
AVAILABILITY_ENABLED = 8,
AVAILABILITY_DISABLED = 9,
AVAILABILITY_ADDR_DISABLED = 10,
AVAILABILITY_PORT_DISABLED = 11
}
AvailabilityState
ITCMLocalLB::Node::get_availability
(
in IPPortDefinition node_def
);
Then, if you determine that the associated monitor is down, you can use the set_state() method to disable or re-enable the given node. enum EnabledState
{
STATE_DISABLED = 0,
STATE_ENABLED = 1
}
void
ITCMLocalLB::Node::set_state
(
in IPPortDefinition[] node_defs,
in EnabledState state
);
EnabledState
ITCMLocalLB::Node::get_state
(
in IPPortDefinition node_def
);
Hope this helps... -JoeRecent Discussions
Related Content
DevCentral Quicklinks
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com
Discover DevCentral Connects