From owner-freebsd-hardware@FreeBSD.ORG  Tue Aug 26 22:51:25 2008
Return-Path: <owner-freebsd-hardware@FreeBSD.ORG>
Delivered-To: freebsd-hardware@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id AA589106567B
	for <freebsd-hardware@freebsd.org>;
	Tue, 26 Aug 2008 22:51:25 +0000 (UTC)
	(envelope-from fhard@ccstores.com)
Received: from mail.qcislands.net (mail.qcislands.net [209.53.238.4])
	by mx1.freebsd.org (Postfix) with ESMTP id 6DE0D8FC19
	for <freebsd-hardware@freebsd.org>;
	Tue, 26 Aug 2008 22:51:25 +0000 (UTC)
	(envelope-from fhard@ccstores.com)
Received: from [209.53.237.85] (helo=dick.ccstores.com)
	by mail.qcislands.net with esmtp (Exim 4.69)
	(envelope-from <fhard@ccstores.com>)
	id 1KY76u-0005XN-Ms; Tue, 26 Aug 2008 15:34:00 -0700
Received: from [192.168.1.4] by dick.ccstores.com with esmtp (Exim 4.69)
	(envelope-from <fhard@ccstores.com>)
	id 1KY77x-000JbW-Ha; Tue, 26 Aug 2008 15:35:05 -0700
Message-ID: <48B484D8.1050406@ccstores.com>
Date: Tue, 26 Aug 2008 15:34:00 -0700
From: Jim Pazarena <fhard@ccstores.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: freebsd-hardware@freebsd.org
References: <B302EFD3-19ED-43B5-B4AD-07BDCF9273A9@netmusician.org>
	<43B3F341.5030906@mac.com>
In-Reply-To: <43B3F341.5030906@mac.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-local_scan: locally submitted (85)
Subject: Re: your advice on vinum, RAIDs
X-BeenThere: freebsd-hardware@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: General discussion of FreeBSD hardware <freebsd-hardware.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hardware>, 
	<mailto:freebsd-hardware-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-hardware>
List-Post: <mailto:freebsd-hardware@freebsd.org>
List-Help: <mailto:freebsd-hardware-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hardware>, 
	<mailto:freebsd-hardware-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 26 Aug 2008 22:51:25 -0000

Chuck Swiger wrote: (in freebsd-questions)
>
> When choosing RAID levels, you are making a tradeoff between
> performance, reliability, and cost:
>
> If you prefer...             ...consider using:
> -----------------------------------------------
> performance, reliability:    RAID-1 mirroring
> performance, cost:           RAID-0 striping
> reliability, performance:    RAID-1 mirroring (+ hot spare, if possible)
> reliability, cost:           RAID-5 (+ hot spare)
> cost, reliability:           RAID-5
> cost, performance:           RAID-0 striping
>
> If you've got enough drives, using RAID-10 or RAID-50 will also improve
> performance compared to stock RAID-1 or RAID-5 modes.

I just upgraded from MySQL 4 to MySQL 5 on a dual processor AMD-64 system,
and MySQL now cannot keep up with the processing it needs to do.

I need at least 500Gb for my MySQL customers, and am using a couple of
750Gb SATA drives - non raid.

I was advised to switch to SAS for better performance. And to RAID for the
500Gb which I need.

I see the RAID section in the 7.0 GENERIC kernel of:
aac
aacp
ida
mfi
mlx
pst
twe


Could someone please advise my best course of action for RAID? That is,
the best controller (driver) to be using, and the most advisable method
to provide myself with perhaps 750Gb of storage in a SAS & AMD environment?
Or, would SATA work just as well for me under the correct RAID environment?

Extreme thanks!

Jim