Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 04-15-2010, 04:05 PM   #1
LQ Newbie
Registered: Apr 2010
Posts: 8

Rep: Reputation: 0
Configure mysql InnoDB to use data files or log files on NFS volumes??

I was reading which as the following in "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?
Old 04-15-2010, 04:18 PM   #2
Senior Member
Registered: Dec 2008
Location: Louisville, OH
Distribution: Debian, CentOS, Slackware, RHEL, Gentoo
Posts: 1,833

Rep: Reputation: 164Reputation: 164
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.
Old 04-15-2010, 05:58 PM   #3
LQ Newbie
Registered: Apr 2010
Posts: 8

Original Poster
Rep: Reputation: 0
I guess NFS implies "shared" like a mounted drive accessible to other? If so, I just connected the dots.
Old 04-15-2010, 07:40 PM   #4
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,396

Rep: Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395
NFS = Network File System
Old 04-15-2010, 08:15 PM   #5
LQ Guru
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

I agree with rweaver. In general, you ~really~ don't want your databases sitting on ANY network shared volume:
* Performance:
- Networks are usually orders of magnitude SLOWER than direct hard-disk
- Expensive alternatives (like fibre channel SANs) are an exception ... but you're probably not running fibre channel, are you ?

* Availability
- "locking" is one thing that will reduce availability and reduce performance
- You can easily saturate your LAN if your application is database intensive
- Basic connectivity:
Networks can fail - that's a fact of life.
MySQL (and most contemporary databases) can recover pretty robustly if the physical network layer hiccups during a client/server connection
It's a whole different story, however, if the physical layer hiccups while server is trying to read a database file that happens to be a network share.
If you're going to use a client/server architecture (like MySQL, SQL Server, Oracle, DB2 or Postgres), then your server's database files should be on local disks.




Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
rebuilding mysql data files Red Squirrel Linux - Server 2 02-13-2008 10:38 PM
Where to place mysql data files TaaDow Linux - Newbie 2 01-04-2006 11:46 PM
MySQL Log Files cli_man Linux - Software 6 10-20-2002 10:24 PM
Can log files be time stamped? (such as FTP login and transfer log files) bripage Linux - Networking 6 08-08-2002 10:55 PM
messages file and other log files on NFS share Supp0rtLinux Linux - Security 1 04-16-2002 09:19 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:50 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration