LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 04-15-2010, 04:05 PM   #1
novice32
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 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?
 
Old 04-15-2010, 04:18 PM   #2
rweaver
Senior Member
 
Registered: Dec 2008
Location: Louisville, OH
Distribution: Debian, CentOS, Slackware, RHEL, Gentoo
Posts: 1,833

Rep: Reputation: 163Reputation: 163
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
novice32
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
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,261

Rep: Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028
NFS = Network File System
http://en.wikipedia.org/wiki/Network...stem_(protocol)
http://en.wikipedia.org/wiki/Distributed_file_system
 
Old 04-15-2010, 08:15 PM   #5
paulsm4
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:
Quote:
* 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.

IMHO .. PSM
 
  


Reply

Tags
mysql


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


All times are GMT -5. The time now is 04:41 PM.

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