I have several servers with www.linode.com. If I restart my Linode from the Linode console, when it restarts the database is down. MySQL wont restart because it says a mysql process is already running. I have to login via SSH and delete the var/lib/mysql/mysql.sock file, then do a service mysql start.
So I wondered if this can be avoided? I am sure it only does it on one of my servers, the others seem to restart Ok when I reboot. So wondered if its a configuration issue somewhere.
Hmm, which distro/version are you using there?
That issue actually appears to be a RHEL/CentOS bug… there’s some information on how to correct it here:
There’s also some folks in the forums here who resolved in by just adding a line to their MySQL init script that deleted the .sock file if it exists.
Ah great, thanks for finding that. Didnt come across that on my googling. Now I know I shall look into it more.