At 10:23 AM 11/29/01 -0500, Jeff Johnson wrote: >We actually have a hardware load balancer that is collecting dust >because I had already written oodles of cold fusion using sessions and >getting primary keys from MS SQL Server by "select max(primaryKey) + 1". > >The load balancer doesn't have the option to use cookies to keep users >on the same server. That option cost $4,000 :). Cold Fusion does >support database storage of session variables, called client variables. >That would solve the session problem.
What do you think of the option we sort of outlined yesterday: - Software or hardware load balancer distributes incoming requests randomly to a pool of machines running Apache (call them APACHE1, APACHE2, etc). - APACHE1, APACHE2, etc have a modified version of the WebKit adapter running on them. The modification is: if no session ID is found in the request, it sends the request to a random machine, otherwise it parses the session ID to find which particular machine to send the request to, from a pool of available WebKit machines (WEBKIT1, WEBKIT2, etc). The pool of machines would be configurable in the adapter's config file. - WEBKIT1, WEBKIT2, etc have a modified version of Session.py that encodes the machine name into the session key. This would be configured in Application.config. The session key would be something like "WEBKIT1_237480927". The idea being to keep requests for the same session on the same machine. Would this work for you? I'm interested in helping to write the WebKit modifications needed. The other option is, as you said, to write a SessionSQLStore.py to store sessions in a database. You have to be a little bit careful about locking here, since multiple requests for the same session may be coming from different appservers at the same time. I'm not sure how to avoid wiping out one appserver's changes with another appserver's changes in that case. -- - Geoff Talvola [EMAIL PROTECTED] _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
