-> >>Has anyone considered, demoed or implemented a session-affinity
-> >>mechanism in mod_scgi? In other words, once a "session" has been
-> >>instantiated for a user from an SCGI process, all future requests in
-> >>that session will be handled by the same process. (Definition of
-> >>"session" is intentionally vague, since I'm fishing.)
-> >
-> >Would the purpose be to get the process
-> >that probably has the best cache for this session,
-> >or are you thinking of some kind of guaranteed condition?
->
-> Good question. Although I could see caching benefits, I'm looking for
-> the guaranteed condition. I would like keep a given (rather large)
-> dataset in process memory, bound to a user session. I'd like to
-> accomplish this with multiple SCGI processes, without an ACID database,
-> and without my own IPC between SCGI processes. Since only one user
-> session may have a given dataset at one time, a session-affinity
-> mechanism would work well.

I know this isn't the solution you wanted, but it's something you might
consider:

http://www.danga.com/memcached/

There's a Python API for it, too.

cheers,
--titus