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.
As long as you're not sharing the data files between multiple database servers, this should work fine, with the understanding that it "won't be as fast" (greater latency) necessarily as local/block disk.
The normal caveats for DB stuff applies, no softmounts, use TCP, Use GbE etc. etc. etc.
Regards, Max
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.