Mysql 5.0 in RHEL 5.0

[Sudarshan A]

We are using MySql 5 in RHEL 5.0 for a application.The scenario is as below with regards to the problem we are facing regarding startup and stopping of mysql.

There is a NAS device of around 250 GB and two linux servers running RHEL 5.0 with Mysql and tomcat .

The data directory is pointed to the NAS device and only the applications reside in the two servers .In my.cnf ,the data directory path is pointed to the NAS device path .

The sock files are created in the respective servers in the path /var/lib/mysql .

For creating redundancy incase of a Server failure ,we have created 2 servers and the data is stored centrally ( ibddata1 ) in the NAS device .

When only one server is working ,Mysql works fine .But when both the servers are on ,Mysql gets locked and we get an error as MYSQL IS RUNNING ,BUT PID FILE DOES NOT EXIST .

And as a result Mysql doesnt start .Then sometimes after we delete the file mysql in the path /var/lock/subsys and restart again ,it works .

So ,in the final analysis ,i want to say ,that when both the servers are on and running mysql ,it gets locked .

Any suggestions and solutions or atleast ,pl let me know ,how to stop mysql from starting in linux .I tried chkconfig ,but it doesnt work.

We need both the servers to be on .

Any viable sugestions would be highly appreciated.