For example sometimes you can get an error like this : $ service mysqld status ERROR! The server quit without updating PID file (/var/lib/mysql/pid). Check the log file at /var/lib/mysql/err $ tail /var/lib/mysql/err 120602 mysqld_safe mysqld from pid file /var/lib/mysql/pid ended This line tells us that we have a compatibility problem with some of our tables and mysql fails to start in safe mode.
My SQL is not running, but lock file (/var/lock/subsys/mysql) exists Well, it’s kind of obvious, just remove the lock file and restart the server. Now let’s change the way mysql starts to work around this situtation.
I would also like to Thank Jeff @ No Baloney for his warm voice and a few quick jokes while speaking with him on the phone.
It's always a laugh or three when talking to Jeff and since this was a critical server (high traffic) I thought first to call him to see if he has hit this yet...
111208 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 111208 mysqld_safe mysqld from pid file /var/lib/mysql/web2ended  Done ./bin/mysqld_safe --user=mysql --defaults-file=/etc/Anybody take up and help me here please? Anybody clarify if there is any problem with ubuntu or with cluster config? I have to implement this on cloud servers once I am successful. Update:1 Now on SQL/Data nodes I have had already removed Neither I am satisfied with the answer nor I am willing to accept and award myself as I have many more to do in this clustering. We thought of using My SQL Cluster for production web servers where apache-tomcat serving some static and jsp pages but because of slow and so on...
This step-by-step guide is mainly for Free BSD, however the idea is the same for Linux.
I'm not sure why this line above didn't cause any issues with 5.1.55 and threw 5.1.56 into a frizzy...
however I wanted to mention this in case anyone else run into this issue.
It can be the problem of using an unsupported variable, or something similar.
The easiest way is to remove your configuration file, and try to start the My SQL server again: Backup your My SQL configuration first.
$ rm /var/lock/subsys/mysql $ service mysqld restart If none of these help, and you’re getting an error like this: $ service mysqld restart ERROR! $ /etc/init/Time to restart $ /etc/init.d/mysqld restart You should a get successfull restart. $ mysql_upgrade If it says you have the latest version, still force it.