Mysql Session tmp var store

Anon

We are setting up a cluster of four linux, mysql, php servers and wish to share the session temp files created by php (usually stored in /tmp [defined in php.ini]) across all four servers in the event of a server failure. The problem lies in that when a session is created it is created on one server.. then due to the load balancing the next page may come from another server.. this means that if it hits onto another server the session isnt registered!!! which would mean that in theory a user would have to logon to all four servers.

Help would be MUCH appreciated..

Carl

neuromancer

Use NFS mounted directory for session files

Anon

my organisation considers that as insecure... is there anyother way?

neuromancer

Do it like this

Web servers 1-4 have two network interfaces, nfs/mysql server 1 has one network interface

The first interface is connected to a switching or load balancing internet device

The second network interface has a internal address on the same subnet connected to a switch/hub

nfs server 1 is connected with the same internal network to the hub or switch.

At that point it doesn't really matter what security issues are introduced by adding the nfs machine because the nfs machine is behind other machines (that don't have ipforwarding or bridging support enabled).

gushy

Of course if the nfs machine goes down you are screwed.

The optimum solution (if you have the money) is to have a shared raid system.

-- Nick Gushlow.

neuromancer

www.netapp.com, if you have the money. Same diffrence.

Anon

ahhhhh... but to say we just spent £90,000 on server equipment we were looking for a cheap(ish) or free sollution which wouldnt mean scrapping existing hardware...

Anon

you can write a program that bind a socket on localhost port nnn at every webserver
set session store mode to user define
operate session by socket.
the socket program broadcast session data each other.

all session data will be saved in every webserver's memory.

if one of them halt, you don't worry about it.

if you select mysql store session , you can find many connection at mysql server.

if mysql server halt, you site will goto hell. Web Server Loadavg could reach 1000+,
planty of http requestion halt.

this has already running at my site.

you can try, be success! good luck!

sorry , so pool english