I'm trying to figure the best way to handle sessions in an e-Commerce web farm environment. What my setup is that I have a website that connects to a remote ODBC server to grab data for the website. The shopping cart generates server side session files, no client cookies at all are being used. What is the best way to handle sessions in a web farm without using cookies at all? Is it possible to handle cookies with a database? In my server session files, I keep a lot of data on my users, so I can't image putting all this info into a database since there would be hundreds of records per user. The session table would also be hit tremendously so I'm weary about putting this load on the database server. How is this usually handled?
What I'm trying to do is have a farm of webservers with my website copied on all the boxes, then a load balancer on the front of the network would route to the least used server. This would be constantly happening, even in the middle of user's sessions, which is why I have to come up with something better than server side sessions residing on each webserver. Any ideas? I would greatly appreciate any help or feedback.