From owner-freebsd-stable@FreeBSD.ORG  Mon Oct 23 23:01:26 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 74A1E16A416
	for <stable@freebsd.org>; Mon, 23 Oct 2006 23:01:26 +0000 (UTC)
	(envelope-from mikej@rogers.com)
Received: from smtp109.rog.mail.re2.yahoo.com (smtp109.rog.mail.re2.yahoo.com
	[68.142.225.207])
	by mx1.FreeBSD.org (Postfix) with SMTP id 9155643D46
	for <stable@freebsd.org>; Mon, 23 Oct 2006 23:01:25 +0000 (GMT)
	(envelope-from mikej@rogers.com)
Received: (qmail 65095 invoked from network); 23 Oct 2006 23:01:24 -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:Subject:Content-Type:Content-Transfer-Encoding;
	b=ZzDfQ2n2tYizNyw9WnBb9LRdrJOJdwqhcmy/bb7MOHVxZYoHwdEy3cfpbu4+ROPGdqPgaOGpPaKXft0YK7l+ZUhYysMMzPpSetu/GIGXprv1j5hI4fCsp1SoW8xsYXOsb+hN4/91hNj9LKhBGIXgthnq/iY026Dz0fVUiV8dP4U=
	; 
Received: from unknown (HELO ?172.16.0.200?) (mikej@rogers.com@74.111.253.239
	with plain)
	by smtp109.rog.mail.re2.yahoo.com with SMTP; 23 Oct 2006 23:01:24 -0000
Message-ID: <453D49D2.1010705@rogers.com>
Date: Mon, 23 Oct 2006 19:01:38 -0400
From: Mike Jakubik <mikej@rogers.com>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
To: stable@freebsd.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: 
Subject: 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:01:26 -0000

Greetings,

    I am in the process of implementing a fairly large mysql server for 
an even larger company, and naturally i want to use FreeBSD. The 
hardware will be an HP DL385, 2 x dual-core Opterons, 16GB RAM,  7 x 15k 
rpm disks in a RAID5 setup. I'm not exactly informed as to the specific 
workload yet, however i know the database will have several million rows 
and be larger than 10GB.

    So, first of all, am i crazy for choosing fbsd+mysql for this rather 
than something like Solaris + Oracle? :) Secondly, i am just looking for 
some suggestions, opinions, success/failure story's that may help me 
out. Is anyone out there using FreeBSD for something of this size? I am 
hoping that everything will work out well, and the client will be happy. 
This would generate some good PR for FreeBSD, as it is a very large 
international company and it would be the first FreeBSD server (that i 
know of) of this type there.

Thanks, any input will be appreciated.