Re: Which Filesystem to choose?

[Daniel Kasak]

chris@stripped wrote:

>Hi,
>
>I'm trying to set up a new Opteron-Based MySQL-Server.
>The only thing I'm unsure about is which filesystem to choose..
>
>ext3? ReiserFS? XFS?
>What's your experience?
>
>Thanks 
>
>chris
>  
>
I've found XFS to be painfully slow.
I haven't tried ext3.
I have used reiser3 on our servers ( mysql, apache, squid, sendmail, 
courier-imap, samba ) for almost 5 years with no issues. It's quite fast 
and is excellent at disaster recovery - we've had a couple of 'issues' 
where the power cord has been pulled from the server, and everything 
came back up quite nicely.

I've also been building desktops here at work with reiser4. I haven't 
had any issues with it yet, but it's up to you whether you consider it 
stable enough yet. If I was rebuilding our server, I'd do it, but I know 
many people would call me a fool for doing so. Works for me. It's *very* 
fast. You have to patch your kernel as it's not yet included in the 
vanilla sources.

If you want to play it safe, you really can't go wrong with reiser3.

You can also use raw partitions with MySQL, which will make it a 
*little* bit faster than what you can get from putting your data into a 
filesystem. I haven't done it myself, but I've seen it mentioned in the 
mailing list. Check the archives / web site. I think you have to use 
InnoDB to use raw partitions, but I might be wrong.

Dan

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: ([phone] / F: ([phone]
email: dkasak@stripped
website: http://www.nusconsulting.com.au