From owner-freebsd-database@FreeBSD.ORG  Tue Aug 23 14:41:31 2005
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 6335916A41F;
	Tue, 23 Aug 2005 14:41:31 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: from flake.decibel.org (flake.decibel.org [67.100.216.10])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 0276F43D45;
	Tue, 23 Aug 2005 14:41:30 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: by flake.decibel.org (Postfix, from userid 1001)
	id 37C471529B; Tue, 23 Aug 2005 09:41:30 -0500 (CDT)
Date: Tue, 23 Aug 2005 09:41:30 -0500
From: "Jim C. Nasby" <decibel@decibel.org>
To: Uzi Klein <uzi@bmby.com>
Message-ID: <20050823144129.GE43820@decibel.org>
References: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi>
	<6863f0c905081906061290c642@mail.gmail.com>
	<43088442.7000704@bmby.com> <20050823011954.GM17203@decibel.org>
	<430AD329.4090601@bmby.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <430AD329.4090601@bmby.com>
X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.9i
Cc: freebsd-database@freebsd.org, jmc <jcagle@gmail.com>,
	freebsd-hardware@freebsd.org
Subject: Re: FreeBSD hardware solution for a database server
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 23 Aug 2005 14:41:31 -0000

On Tue, Aug 23, 2005 at 09:41:29AM +0200, Uzi Klein wrote:
> Jim C. Nasby wrote:
> >On Sun, Aug 21, 2005 at 03:40:18PM +0200, Uzi Klein wrote:
> >
> >>2 mirrored drives mounted as /
> >>3 RAID 5 drives mounted as /var
> >
> >
> >RAID5 pretty much sucks for databases that do anything more than 1-5%
> >writes.
> 
> would you suggest RAID 0+1 instead?

I'd suggest whichever one is a stripe of mirrors (you don't want a
mirror of 2 stripe sets).
-- 
Jim C. Nasby, Database Architect                decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"