which NFS implementation is safe for sqlite database accessed by multiple processes

user_6772507 0
Viewed 4387

here mentioned that "...But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem. This is because fcntl() file locking is broken on many NFS implementations. You should avoid putting SQLite database files on NFS if multiple processes might try to access the file at the same time..."

But the document doesn't mention which NFS implementation works well on this. Any suggestions? What about sqlite3?

sqlite c++
1 Answers

Locking with fcntl works with both NFS versions 3 and 4. As long as you can mount with vers=3 or vers=4, you should be set. You can also use locktests to verify that locking works, and nfsstat to verify the available versions on the client and server.

Admin1
Related