Forum Discussion
NimbostratusUsing an iRule to route SQL traffic
Here is our setup. We have a SharePoint farm, four BISM (SSAS) SQL Servers and 4 ETL Servers, all 2008 R2 Servers. We are trying to setup 2 "pods" each with 2 BISM/2ETL Servers.
THe BISM servers go through an F5. We need to an have iRule route traffic, so we can segregate BISM traffic to the 'pods" according to a certain value, maybe a token, whatever will work. The problem is that between the SP Farm and BISM Server there is TCP (SQL) traffic.
Questions: 1. How can tell what the TCP traffic contains from the SP Farm to the BISM Servers? I have tried TCP::collect and not sure where to look to see the traffic. 2. I need to use a variable of from the packets to compare to a data group, is that possible? 3. Any help with writting an iRule would be greatly appreciated.
Thank you!
9 Replies
- Kevin_Stewart
Employee
The new MS SQL profile in 11.5 allows you to balance across SQL pools based on command (read or write) and user (from a defined list). Beyond this there's no built-in SQL parsing function, so you'd necessarily have to build a pretty complex binary-based iRule, which I wouldn't recommend. That said, if 1) you can define a value early on in the SQL data, and b) that data is in every request (or at least 1 per TCP session), then there's still a chance you could read this and do something useful.
- nitass
as Kevin mentioned, TDS command and event are introduced in 11.5.0.
TDS
https://devcentral.f5.com/wiki/iRules.TDS.ashx 
Dmitry_ShermanFor some reason this feature is missing in both 11.5 and 11.5.1 LTM (VE) GUI, but found it in tmsh, any ideas why it was removed?
- nitass
For some reason this feature is missing in both 11.5 and 11.5.1 LTM (VE) GUI, but found it in tmsh, any ideas why it was removed?
it is fixed in 11.6.0.
ID434414 - MS SQL Proxy Profile is visible in al Virtual Server GUI configuration screens
- Dmitry_Sherman
thanks! Is it considered stable? When can I get the 11.6 release?
nitass_89166Noctilucent
Is it considered stable?
i understand it is not experimental.
When can I get the 11.6 release?
it is not determined yet.
James_124570Now that 11.6 version is released. Is there any documentation on how to setup/configure MS SQL profiles?
- nitass
Is it considered stable?
i understand it is not experimental.
When can I get the 11.6 release?
it is not determined yet.
- James_124570Now that 11.6 version is released. Is there any documentation on how to setup/configure MS SQL profiles?
