We'd like to have our database storage resident on a Filer with NFS. Do any of you have experience or insight into this for MySQL or PostgreSQL? I understand Oracle's happy to work like this but my google searches seem to indicate it's a bad idea to use NFS storage for PostgreSQL or MySQL.
Thanks.
http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance/...
NFS and other remote file systems are not recommended for use by POSTGRESQL. NFS does not have the same file system semantics as a local file system, and these inconsistencies can cause data reliability or crash recovery problems.
http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html
The warning against sharing a data directory among servers also applies in an NFS environment. Allowing multiple MySQL servers to access a common data directory over NFS is a very bad idea.
* The primary problem is that NFS is the speed bottleneck. It is not meant for such use.