Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-24 Thread Lennart Sorensen
On Fri, Aug 24, 2007 at 12:48:29AM +0200, Michael wrote: I just tweaked all ext3 partitions to something like /dev/sda10 / ext3noatime,nodiratime,errors=remount-ro 0 1 to see what will happen. (The option data=writeback caused boot trouble) So far, anything unchanged but

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-24 Thread Jim Crilly
On 08/23/07 04:07:46PM -0700, [EMAIL PROTECTED] wrote: Quoting Jim Crilly [EMAIL PROTECTED]: On 08/23/07 10:03:24AM -0700, [EMAIL PROTECTED] wrote: The problem of zeroing files of XFS still exists, however its not some mythical type of corruption. You'll only see it on files recently

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-24 Thread Lennart Sorensen
On Thu, Aug 23, 2007 at 09:47:13PM -0500, Neil Gunton wrote: Eh? I've been using replication for years now. It works out of the box, rock solid, and nothing special on the backend at all. Master produces binary log, which is replayed on the slave(s). Nothing questionable about it, it's used

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-24 Thread michael
Quoting Jim Crilly [EMAIL PROTECTED]: I tested the exact same thing again but waited 60 seconds after saving the file, and then yanked the power out. Upon a boot up, the file was intact and the save worked. So you still have about a 60 second window of newly written files and a power loss for

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-24 Thread Stefano Rivera
Hi michael (2007.08.24_17:10:24_+0200) limited of its mechanics, but since XFS will never journal data, only meta-data, then won't there always be the chance that a file can get corrupted on a timely power loss? A file can get corrupted, but hopefully not the file metadata (i.e. the

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-24 Thread Jo Shields
On Fri, 2007-08-24 at 08:10 -0700, [EMAIL PROTECTED] wrote: Quoting Jim Crilly [EMAIL PROTECTED]: I tested the exact same thing again but waited 60 seconds after saving the file, and then yanked the power out. Upon a boot up, the file was intact and the save worked. So you still have

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-24 Thread Jim Crilly
On 08/24/07 08:10:24AM -0700, [EMAIL PROTECTED] wrote: Quoting Jim Crilly [EMAIL PROTECTED]: I tested the exact same thing again but waited 60 seconds after saving the file, and then yanked the power out. Upon a boot up, the file was intact and the save worked. So you still have about a 60

Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Neil Gunton
Hi, I am wondering if anyone has any real-world advice on the best filesystem to use for an AMD64 LAMP server. I know that the different systems have their pros and cons, but a lot of the comparisons out there seem to be rather old. So I'll describe below exactly what it is I'm doing. The

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Lennart Sorensen
On Thu, Aug 23, 2007 at 10:19:44AM -0500, Neil Gunton wrote: I am wondering if anyone has any real-world advice on the best filesystem to use for an AMD64 LAMP server. I know that the different systems have their pros and cons, but a lot of the comparisons out there seem to be rather old.

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Neil Gunton
Lennart Sorensen wrote: So my opinion is to use ext3 for it all. Then one repair tool is all you will ever need (and in my experience you are unlikely to really ever need that one tool either). The repair tools for reiserfs have historically been awful (in many cases making the problem worse

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Lennart Sorensen
On Thu, Aug 23, 2007 at 11:15:56AM -0500, Neil Gunton wrote: Great advice, thanks a lot! This is just what I'm after. I'd be interested to hear whether other people have wildly different experiences... if not, then I'll probably just go with ext3 for all of it. Also, is there any downside

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread michael
Quoting Neil Gunton [EMAIL PROTECTED]: Hi, I am wondering if anyone has any real-world advice on the best filesystem to use for an AMD64 LAMP server. I know that the different systems have their pros and cons, but a lot of the comparisons out there seem to be rather old. So I'll describe below

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Freddie Cash
On August 23, 2007 09:15 am Neil Gunton wrote: Lennart Sorensen wrote: So my opinion is to use ext3 for it all. Then one repair tool is all you will ever need (and in my experience you are unlikely to really ever need that one tool either). The repair tools for reiserfs have

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Christopher Browne
On 8/23/07, Neil Gunton [EMAIL PROTECTED] wrote: I am wondering if anyone has any real-world advice on the best filesystem to use for an AMD64 LAMP server. I know that the different systems have their pros and cons, but a lot of the comparisons out there seem to be rather old. So I'll describe

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Jim Crilly
On 08/23/07 10:03:24AM -0700, [EMAIL PROTECTED] wrote: The problem of zeroing files of XFS still exists, however its not some mythical type of corruption. You'll only see it on files recently written to within seconds (say approx 60 secs) of a hard power off. If you can't risk it, or

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Neil Gunton
Christopher Browne wrote: 3. I have seen filesystems lost to corruption on all of [JFS, XFS, and ReiserFS], so I have at least vague, anecdotal evidence against their use. Thanks, this is useful. 4. If you look at ongoing development efforts, you'll find that: a) IBM isn't working all that

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Neil Gunton
Freddie Cash wrote: We use XFS for everything except /boot as GRUB doesn't play nice with XFS. Haven't had any performance issues. And the resizing features play nicely with LVM. Our servers include a pair of Xen boxes using XFS-on-LVM for each VM, several web servers running Apache vhost

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Lennart Sorensen
On Thu, Aug 23, 2007 at 01:43:09PM -0500, Neil Gunton wrote: Yes, that did occur to me (the bankruptcy of SGI and the trial of Hans). However I just assumed that there was enough of an open source development following behind each of these efforts that someone would pick up the slack and

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Neil Gunton
Lennart Sorensen wrote: I think some people don't like MySQL due to historical license reasons, lack of many features requires to be a proper SQL implementation, crappy locking granularity, etc. Sure it has improved over the years, but once people decide postgresql is a better choice, it is

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Freddie Cash
On August 23, 2007 12:31 pm Neil Gunton wrote: Freddie Cash wrote: We use XFS for everything except /boot as GRUB doesn't play nice with XFS. Haven't had any performance issues. And the resizing features play nicely with LVM. Our servers include a pair of Xen boxes using XFS-on-LVM for

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Stefano Rivera
Hi Neil (2007.08.23_21:31:40_+0200) From your experience, do you feel that XFS has significant performance advantages over ext3? Just remember that XFS has a reputation for not handling unexpected power-downs very well. ext2/3 has legendary reliability, and a great armoury of repair tools.

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Michael
I just tweaked all ext3 partitions to something like /dev/sda10 / ext3noatime,nodiratime,errors=remount-ro 0 1 to see what will happen. (The option data=writeback caused boot trouble) So far, anything unchanged but the firefox history where is no 'Today' anymore. MySQL, Apache,

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread michael
Quoting Jim Crilly [EMAIL PROTECTED]: On 08/23/07 10:03:24AM -0700, [EMAIL PROTECTED] wrote: The problem of zeroing files of XFS still exists, however its not some mythical type of corruption. You'll only see it on files recently written to within seconds (say approx 60 secs) of a hard power

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Peter Yorke
23 16:07:46 2007 Subject: Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server Quoting Jim Crilly [EMAIL PROTECTED]: On 08/23/07 10:03:24AM -0700, [EMAIL PROTECTED] wrote: The problem of zeroing files of XFS still exists, however its not some mythical type of corruption. You'll only see

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Neil Gunton
Lennart Sorensen wrote: That is pretty much still true since the replication option on mysql requires using a different backend which looses a bunch of the other mysql features, and is as far as I can tell still rather questionable in use. Eh? I've been using replication for years now. It

Re: Opinions on ext3 vs XFS vs reiserfs for LAMP server

2007-08-23 Thread Jaime Ochoa Malagón
sorry but I'm not sure about subquerys I belive mysql now have support of it... http://dev.mysql.com/doc/refman/5.0/en/subqueries.html On 8/23/07, Neil Gunton [EMAIL PROTECTED] wrote: Lennart Sorensen wrote: That is pretty much still true since the replication option on mysql requires using