From owner-freebsd-stable@FreeBSD.ORG Tue Oct 24 14:44:14 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 6B1CF16A492 for ; Tue, 24 Oct 2006 14:44:14 +0000 (UTC) (envelope-from vivek@khera.org) Received: from yertle.kcilink.com (yertle.kcilink.com [65.205.34.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id BFD9343D69 for ; Tue, 24 Oct 2006 14:44:13 +0000 (GMT) (envelope-from vivek@khera.org) Received: from [192.168.7.103] (host-103.int.kcilink.com [192.168.7.103]) by yertle.kcilink.com (Postfix) with ESMTP id 9260FB821 for ; Tue, 24 Oct 2006 10:23:52 -0400 (EDT) Mime-Version: 1.0 (Apple Message framework v752.2) In-Reply-To: <453D49D2.1010705@rogers.com> References: <453D49D2.1010705@rogers.com> Content-Type: multipart/signed; micalg=sha1; boundary=Apple-Mail-2-856521675; protocol="application/pkcs7-signature" Message-Id: <6DBE5906-CD84-44C5-AF40-FFCC78C7561E@khera.org> From: Vivek Khera Date: Tue, 24 Oct 2006 10:23:51 -0400 To: stable@freebsd.org X-Mailer: Apple Mail (2.752.2) X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: 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, 24 Oct 2006 14:44:14 -0000 --Apple-Mail-2-856521675 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On Oct 23, 2006, at 7:01 PM, Mike Jakubik wrote: > 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 First thing, choosing mysql for anything truly relational is a bit crazy... but your choice of FreeBSD is very sound, and your hardware seems reasonable, except RAID5 is generally not the best choice for a heavily written-to database. You can't really compare mysql to oracle at all, and mentioning them in the same breath sounds funny to me... Take a good look at postgres. In the end, it really depends on your workload and how much truly relational qork you're expecting the DB to do. If all you're using the DB for is a file store, you might as well use mysql, but then you have to worry about all of your data integrity in your application. Personally, I prefer to put that burden on the DB engine. The size of your DB is not all that large. There are people running terabyte DB's under postgres. Our big DB is around 60Gb with hundreds of millions of rows spread across dozens of tables which are regularly joined with each other for reports. It is pounded on 24x7 with lots and lots of inserts, updates, and selects going on all the time. --Apple-Mail-2-856521675--