Configure mysql InnoDB to use data files or log files on NFS volumes??
I was reading http://dev.mysql.com/doc/refman/5.1/...trictions.html which as the following in "Warning":
Warning It is not a good idea to configure InnoDB to use data files or log files on NFS volumes. Otherwise, the files might be locked by other processes and become unavailable for use by MySQL. What does that mean, and how can one configure or check to ensure the above is being followed? |
You ~really~ don't want your databases sitting on a shared NFS volume... it's a bad idea, NFS can cause a wide variety of locking issues even above and beyond what is listed there. You would be better off setting up replication or something similar if you need multiple hosts accessing the same data.
|
I guess NFS implies "shared" like a mounted drive accessible to other? If so, I just connected the dots.
|
NFS = Network File System
http://en.wikipedia.org/wiki/Network...stem_(protocol) http://en.wikipedia.org/wiki/Distributed_file_system |
Hi -
I agree with rweaver. In general, you ~really~ don't want your databases sitting on ANY network shared volume: Quote:
IMHO .. PSM |
All times are GMT -5. The time now is 07:13 AM. |