Forum Discussion

llm32514_55149's avatar
llm32514_55149
Icon for Nimbostratus rankNimbostratus
Aug 09, 2010

Automating SQL 2008 failover using F5

We have two SQL 2008 clusters each located in a different Data Center. We've setup SQL Cluster Endpoints and enabled mirroring between the sites. We've setup GTM pools for geo-failover which monitor these SQL clusters. So one site is designated as a "primary" or active site and the other location is our "secondary" or passive site. In the event of the primary SQL instance going off-line we'd like to have the F5 send a SQL query language command string to the passive instance making it become active. Is this possible on the F5?

 

microsoft
partner
  • hoolio's avatar
    hoolio
    Icon for Cirrostratus rankCirrostratus
    Aug 10, 2010
    Hi,

     

     

    You could potentially implement this type of logic by calling a custom script from the user_alert.conf file when a SQL instance is marked down. See this post for details:

     

     

    Generic command in user_alert.conf

     

    http://devcentral.f5.com/Default.aspx?tabid=53&view=topic&postid=55956&ptarget=56007

     

     

    Aaron