NFS with MySQL / Apache..

Portal Home > Knowledgebase > Articles Database > NFS with MySQL / Apache..

Posted by joeshacks, 02-07-2008, 03:03 AM
So i am setting up a new load balanced cluster for the first time. It is turning out pretty well so far, I was wondering if you guys see any future problems with this setup. So far it is working well. I have one server that is the dedicated network file server. Then two others that mount the file system from the NFS. I have mysql and apache installed on both servers. They both share the NFS mount using read and write privs. I haven't put a load on the setup yet, but I was under the assumption that this couldn't be done with MySQL, but it seems to be working great. If this does work out, it seems MySQL would be scaled just as easy as apache. Everysite in the system could be setup to use localhost which would be the same server it is served up with apache. I hope this makes since. Has anyone ventured down this road?
Posted by RyanD, 02-07-2008, 03:16 AM
long term MySQL will not scale over NFS. On top of that you can not have multiple instances accessing the same data files.
Posted by joeshacks, 02-07-2008, 07:57 PM
I do have multiple instances accessing the same data files, and it is working well.. At least for now it is..
Posted by Lightwave, 02-08-2008, 05:00 AM
Expect data corruption. All the MySQL documentation clearly explains this as a "very bad idea."
Posted by YYamagishi, 02-08-2008, 06:04 AM
Yes you will face data corruption. Try MySQL Replication, Clustering or Load Balancing with MySQL Proxy

Add to Favourites Print this Article