Data Corruption Issues

Hi all,

We are finding corruption in mysql database files that are being copied from 16 Linux 2.4.20 servers to a Linux 2.4.21 backup server on an hourly basis.

Here are the details:

The backup server was originally a FreeBSD box that was having some hardware issues. We decided to swap it out and replace with a Linux server (running 2.4.21). We had no issues of data corruption until we swapped machines.

The 16 linux 2.4.20 servers have the backup machine mounted locally and after each hour a script is run that flushes the tables and then copies them to the mounted backup drive. There's no real pattern of which machines create a corrupt file on the backup machine. It appears fairly random. We are seeing about 20% of them corrupted.

Our network is running at 100MB.

The files are around 25MB each.

We have tried the following settings:

Increasing the number of nfsd server threads to 20 on the backup
machine.

Changes in the mount options in the 16 fstabs:

    specifying:  tcp, nfsvers=3
    specifying:  udp, nfsvers=2
    specifying:  rsize=1024,wsize=1024

There was no real change in the corruption rate after any of these changes.

Any ideas of what we should try next are appreciated.

Thank you,

-Lisa

-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
NFS maillist - [email protected]
https://lists.sourceforge.net/lists/listinfo/nfs