[ic] SessionDB - storing sessions in a mysql table ?

Dan B interchange-users@lists.akopia.com
Thu Jul 12 19:42:01 2001


At 11:58 AM 7/12/2001 -0500, you wrote:
>Yo,
>
>I recall someone mentioned a while back that it's possible to store sessions
>in mysql - via SessionDB?  I looked at the config docs under SessionDB, and
>added "SessionDB   sessions" - assuming that catalog will then look for a
>'sessions' table in my store's db, but how does one format the sessions
>table?  What else needs to happen besides just creating the table?
>
>Thanks,
>Jud

Haven't done this myself yet, but I plan to once the ads hit and we need a 
cluster.  (It turns out that IC was so fast we didn't need a cluster as 
soon as we thought).  But I've kept notes on clustering, and here are some 
about getting SessionDB into Mysql (including table definitions).

They might be out of date, but here they are:

http://developer2.akopia.com/archive/interchange-users/2000/msg03202.html

http://developer2.akopia.com/archive/interchange-users/1999/msg01404.html

In my opinion, someone needs to pony up the cash to strike a deal with RH 
regarding a certified official clustering solution for IC, which probably 
only involves a few patches to the construct template and a new 
advertisement on the "Red Hat High Availability Server" web site 
(http://www.redhat.com/products/software/linux/haserver/).  Who knows, it 
might be us in a little while.

I digress.  But I HTH,

Dan Browning, Cyclone Computer Systems, danb@cyclonecomputers.com