Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Double stickyness (HTTP & SQL)

Hi all,

I have two webservers (IIS) in front of two SQL servers. The CSS load-balances between both webservers then sticks the client to either webserver. The webserver turns around and queries the SQL database to provide the information back to the client. Stickyness is required between the client, the webserver and the SQL server. I can get the client to stick to the webserver and I can get the webserver to stick to the SQL server but I do not know how to stick the client to the SQL server (double stickyness).

1- Is it feasible?

2- How do I parse through SQL code to find the session ID and use it for stickyness?

Thanks

Martin

1 REPLY

Re: Double stickyness (HTTP & SQL)

CSS is not SQL aware. It doesnt look deep into SQL transactions. Only option you have is to use Layer 4 information to loadbalance/Stick trffic.

Syed Iftekhar ahmed

123
Views
0
Helpful
1
Replies
CreatePlease login to create content