As always with these things, horses for courses. In my situation,
I have a mysql server mounted off a netapp, It is the backend for
a website serving 10m+ page impressions per month.
I wanted to put the data on a netapp for easy backup ( I can shutdown
the server do a snapshot and bring it bac
For mysql, if your datafiles will not fit in ram, I would highly
recommend not putting it on nfs. Mysql doesn't have any data caching,
so every query will have to go thru the network to get the data. if,
however, you do have enough ram on the machine to store all the
datafiles in memory, the
I have done oracle on NFS and it is not really the best option due to NFS
locking.
ie a poor network or if the NFS server drops, or the NIS/NIS+ (assuming you
are using automount maps) dies this will hold your development/production up
no end. Also oracle's table locking (not sure if mysql has th
