datadir on nfs

[roycrom]

Hello,

First of all, I know it isn't recommended to use an NFS share for my datadir, but I am doing some testing for a fault tolerant cluster and nfs is the best way for me to test this.

I am running RH4 64-bit and mysql 4.1.22 (built from source, not from RPM).

If my datadir is on the local disk - /g00/mysql/mysql-4.1.22/data - then mysql starts up no problems.
If I then shut down, mv /g00/mysql to /g00/mysql.tmp, mount an NFS share on /g00/mysql, copy /g00/mysql.tmp/mysql-4.1.22 to /g00/mysql/mysql-4.1.22 then mysql will not start up correctly.

The processes start, /tmp/mysql.sock gets created, but the startup script says it fails and no pid file is created. I have "su'd to the mysql user and verified that I can create this file manually, so it is not permissions.

There will now be two mysql processes started, but I can only kill one of them.

I have compiled mysql with debug, but I don't know how to understand the /tmp/mysqld.trace file.

Can anyone help? Do I have to mount - export nfs share with specific options? (I am currently exporting with sync,rw,no_root_squash.

Any help would be greatly appreciated. Any more info required, pls let me know and I shall post it up.

------------------------------------------
Somethings come from nothing, nothing seems to come from somethings - SFA - Guerilla

roycrom

 

[roycrom]

This was a firewall issue. I thought that I had all ports required to map NFS through the firewall were open as I could mount via NFS. They were not - now they are - and I have mysql working.

------------------------------------------
Somethings come from nothing, nothing seems to come from somethings - SFA - Guerilla

roycrom