From owner-freebsd-stable@FreeBSD.ORG Tue Oct 31 23:37:35 2006 Return-Path: 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 AAC9B16A4D0 for ; Tue, 31 Oct 2006 23:37:35 +0000 (UTC) (envelope-from karl@FS.denninger.net) Received: from FS.denninger.net (wsip-70-169-168-7.pn.at.cox.net [70.169.168.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3B55843D4C for ; Tue, 31 Oct 2006 23:37:09 +0000 (GMT) (envelope-from karl@FS.denninger.net) Received: from fs.denninger.net (localhost [127.0.0.1]) by FS.denninger.net (8.13.6/8.13.1) with SMTP id k9VNav8r016675 for ; Tue, 31 Oct 2006 17:36:57 -0600 (CST) (envelope-from karl@FS.denninger.net) Received: from fs.denninger.net [127.0.0.1] by Spamblock-sys (LOCAL); Tue Oct 31 17:36:57 2006 Received: (from karl@localhost) by FS.denninger.net (8.13.6/8.13.1/Submit) id k9VNavbO016672; Tue, 31 Oct 2006 17:36:57 -0600 (CST) (envelope-from karl) Date: Tue, 31 Oct 2006 17:36:57 -0600 From: Karl Denninger To: Mike Jakubik Message-ID: <20061031233657.GA16540@FS.denninger.net> References: <453D49D2.1010705@rogers.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <453D49D2.1010705@rogers.com> User-Agent: Mutt/1.4.2.1i Organization: Karl's Sushi and Packet Smashers X-Die-Spammers: Spammers cheerfully broiled for supper and served with ketchup! 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 31 Oct 2006 23:37:35 -0000 On Mon, Oct 23, 2006 at 07:01:38PM -0400, Mike Jakubik wrote: > 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. I ran a database of this general size on FreeBSD + Postgresql in 1998! Definitely not crazy to do this, but I'd run Raid10 instead of 5, as performance will be much better. I would not use mysql for this - but that's my personal preference coming through here. I believe Postgresql has far better data integrity in a corporate-style environment. -- -- Karl Denninger (karl@denninger.net) Internet Consultant & Kids Rights Activist http://www.denninger.net My home on the net - links to everything I do! http://scubaforum.org Your UNCENSORED place to talk about DIVING! http://genesis3.blogspot.com Musings Of A Sentient Mind