Forum Discussion
James_124570
Nimbostratus
May 02, 2014Using 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 serve...
Kevin_Stewart
Employee
May 02, 2014The 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.
Help guide the future of your DevCentral Community!
What tools do you use to collaborate? (1min - anonymous)Recent 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