From owner-freebsd-stable@FreeBSD.ORG  Mon Oct 23 23:44:35 2006
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
X-Original-To: stable@freebsd.org
Delivered-To: freebsd-stable@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 6EF1816A4B3
	for <stable@freebsd.org>; Mon, 23 Oct 2006 23:44:35 +0000 (UTC)
	(envelope-from mikej@rogers.com)
Received: from smtp100.rog.mail.re2.yahoo.com (smtp100.rog.mail.re2.yahoo.com
	[206.190.36.78]) by mx1.FreeBSD.org (Postfix) with SMTP id EE0E143D7E
	for <stable@freebsd.org>; Mon, 23 Oct 2006 23:44:31 +0000 (GMT)
	(envelope-from mikej@rogers.com)
Received: (qmail 37748 invoked from network); 23 Oct 2006 23:44:30 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=rogers.com;
	h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding;
	b=1/XmPG7X/P7s+9vBuVtra06JqaEThKXLpK6qWFmzDhy6/RPaZC/yFf2b2XFINRTfAxvWYZNM8BnqkaGIEDG7nKvo1iqRVXmpWMykJu71UfpCbVk7OsG0MuZYi45C8GZhJcmEi0P31azKRh0HzShkcbO5ew29Ts9O7KO1eVkFPrI=
	; 
Received: from unknown (HELO ?172.16.0.200?) (mikej@rogers.com@74.111.253.239
	with plain)
	by smtp100.rog.mail.re2.yahoo.com with SMTP; 23 Oct 2006 23:44:30 -0000
Message-ID: <453D53ED.5050403@rogers.com>
Date: Mon, 23 Oct 2006 19:44:45 -0400
From: Mike Jakubik <mikej@rogers.com>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
To: Chuck Swiger <cswiger@mac.com>
References: <453D49D2.1010705@rogers.com>
	<3861E2E8-4232-4C46-8D0A-1B6079BCA07D@mac.com>
In-Reply-To: <3861E2E8-4232-4C46-8D0A-1B6079BCA07D@mac.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: stable@freebsd.org
Subject: Re: Running large DB's on FreeBSD
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 23 Oct 2006 23:44:35 -0000

Chuck Swiger wrote:
> On Oct 23, 2006, at 4:01 PM, Mike Jakubik wrote:
>>    So, first of all, am i crazy for choosing fbsd+mysql for this 
>> rather than something like Solaris + Oracle? :)
>
> Moderately...it kinda depends on the budget available.  I regard 
> Solaris + Oracle as one of the most reliable combinations for moderate 
> to extreme load, for a system that might well be in operation for five 
> to ten years.  If I was going to do FreeBSD, I might look into 
> Postgres instead of MySQL; well, I might look into something else than 
> MySQL under many circumstances.  I've gotten some pretty good use out 
> of OpenBase, for another choice.
>

I believe the front-end application is MySQL dependent, but what is so 
much better about PostgreSQL? I understand that it has some more 
advanced features, but if they are not used, then what is the advantage? 
(I really like the InnooDB storage in MySQL)

> As for the disk configuration, using RAID-5 is one of the worst 
> possible choices for a database; using multiple RAID-1 mirrors or a 
> RAID-10 config would probably do a lot better in terms of performance 
> and reliability.


Is RAID5 really that bad when a lot of fast disks are used and the 
controller has a decent cache with a BBWC? Thanks for the feedback guys.