Jeff_Nyquist_44
Mar 26, 2010Nimbostratus
MS SQL Database Redirect
I have a problem that I am wondering if iRules can assist with.
We have a MS SQL server running 120-150 databases. Unfortunately, we only have a single generic "token" that the development teams have been using to call the SQL server. For lots of reasons, it would be helpful to be able to move those databases around behind the scenes, but since the token only points to a server name, we're very stuck without rewriting a lot of code.
Can I create a VIP for the SQL server and have iRules redirect SQL server traffic to various backend servers based on an incoming database request?
Hopefully this makes sense... any help would be greatly appreciated. Thanks!
Jeff