MySQL on Linux on NFS on Netapp

I recently moved some storage from a local volume on a Linux virtual server over to an NFS volume on one of our Filers. This was all well and good until the users ran their backup script which stops the software and MySQL, copies some files about* and then restarts everything. MySQL was failing to restart with error log messages complaining about locks on the InnoDB files (ibdata1, ib_logfile0, ib_logfile1). It turns out that the Linux NFS client doesn't do locking in the same way as other clients (e.g. Solaris) and was never clearing the locks out. The simplest solution I found, and which looks to work, is to add the 'nolock' mount parameter to the Linux boxes /etc/fstab.

* Of course they don't really need to be doing traditional backups now, because they can tell the filer to create a snapshot instead.