Forum Discussion

AngryCat_52750's avatar
AngryCat_52750
Icon for Nimbostratus rankNimbostratus
Jan 03, 2014

SQL and iRules

We are looking at fronting our SQL servers with F5 VIPs (hostnames).

 

Current web server -> sql server (by name)

 

Future idea web server -> f5 VIP (listening on 1433) -> sql server

 

We are thinking of multiple hostnames for separate databases on the SQL server.. would i be able to phrase the hostnames with an iRule just like a HTTP request??

 

thoughts??

 

application delivery
deployment
design
devops
iRules

2 Replies

Sort By
  • Chris_Miller's avatar
    Chris_Miller
    Icon for Altostratus rankAltostratus
    Jan 06, 2014

    Just to add to what kulastone is trying to do here - parse a SQL hostname and do pool sorting as necessary.

     

  • Fred_Slater_856's avatar
    Fred_Slater_856
    Historic F5 Account
    Mar 20, 2014

    Do either of you have an answer for https://devcentral.f5.com/questions/apm-or-iapp-for-ms-sql ?