A big headache in my experience. Different NFS servers lie about whether or not they really fsync writes when the clients request it, so you can end up with clobbered writes and corrupted databases in the worst case, and lots of "database is locked" errors that persist for longer than they should in the best case.