Infrastructure Software

Hi All,

Nice and simple one (I hope). I'm running a clustered MySQL service on two nodes, and I'd like for the pid files to be stored under /var/run.

As this service runs as the mysql user, I have had to create a subdirectory /var/run/mysql owned by this user - however, this vanishes after a reboot, which means I have to remember to recreate it if I reboot a node.

Is there a startup script (like /etc/init.d/boot.local, in some Linuxes) where I can shove the commands to recreate the required directory, or is there a better way of making this directory (and it's permissions) persistant?

Thanks in advance,

Pete