llm32514_55149
Aug 09, 2010Nimbostratus
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?