From owner-freebsd-questions@FreeBSD.ORG Sat Jan 3 11:34:30 2009 Return-Path: Delivered-To: questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 475E0106566B for ; Sat, 3 Jan 2009 11:34:30 +0000 (UTC) (envelope-from lenzi@k1.com.br) Received: from netuno.levier.com.br (netuno.levier.com.br [201.47.3.162]) by mx1.freebsd.org (Postfix) with ESMTP id 862EC8FC16 for ; Sat, 3 Jan 2009 11:34:28 +0000 (UTC) (envelope-from lenzi@k1.com.br) Received: from levier.com.br (localhost [127.0.0.1]) by netuno.levier.com.br (8.14.2/8.14.2) with ESMTP id n03AfNns063141 for ; Sat, 3 Jan 2009 09:34:27 -0200 (BRST) (envelope-from lenzi@k1.com.br) X-MessageWall-Score: 0 (levier.com.br) Received: from [201.86.10.16] (authenticated as k1) by levier.com.br (MessageWall 1.0.8) with SMTP; 3 Jan 2009 11:34:26 -0000 From: Sergio de Almeida Lenzi To: freebsd-questions In-Reply-To: <495F2919.6040103@isafeelin.org> References: <495E17AD.30707@isafeelin.org> <20090102160727.A38841@wojtek.tensor.gdynia.pl> <495F2919.6040103@isafeelin.org> Date: Sat, 03 Jan 2009 09:34:24 -0200 Message-Id: <1230982465.7117.29.camel@lenzix.cwb.casa> Mime-Version: 1.0 X-Mailer: Evolution 2.24.2 Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Subject: Re: Using HDD's for ZFS: 'desktop' vs 'raid / enterprise' -edition drives? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 03 Jan 2009 11:34:30 -0000 Hello.... About your zfs experience... please let me tell mine.. I was having toubles with ufs2 on some small servers (desktop grade) machines running postgresql (64 bits, or 32 bits) all running FreeBSD 7.X some still 6.X... the problem is that sometimes the database brokes because the ufs2 fsck wipes out the pg_log files (that holds metadata, and so the database is lost/compromiesed) it used to be aobout 1 or 2 times a week, well you willl say that it is very often... but there are more thatn 1200 servers... that is about a database problem in 16 years the machines are in remote zones and cannot stop.. So a month ago I decided to try zfs... first on onpensolaris (that, as expected, works very well...) than in a "set" of 4 machines running FreeBSD 7.0/7.1 (a small partition to boot, than filesystem / on zfs). 1 of them with 2gb of memory, the others with 1g, 512m, 256m (I know that zfs is unstable with less than 512mb...) but it is only for testing.... the machines varies from amd64 to celeron... (64 and 32 bits..) NO RAID on the small machine, a buildworld lasted 2 days... All running a database (test of course) without no break. with a custom application that updates tables (several thousand rows, with foreing keys and triggers...) and then rollback... the drives area always with access light on... Sometimes (several times a day, random..) the machines are switched off.. without shutdown... and than switched on again... about (5 -10 times) that is about 60 * 8 -> 480 power on/power off cycles each machine Well. I can say that I still have not lost a database... it is incredible fast, reliable comes up without any fsck wait time. in less than a minute... Now I will start to put it on Dells and those PERC controllers... That is my experience... Sergio