Date: Tue, 24 Oct 2006 13:58:11 +0200 From: "Patrick M. Hausen" <hausen@punkt.de> To: Chuck Swiger <cswiger@mac.com> Cc: Mike Jakubik <mikej@rogers.com>, stable@freebsd.org Subject: Re: Running large DB's on FreeBSD Message-ID: <20061024115811.GA10499@hugo10.ka.punkt.de> In-Reply-To: <3861E2E8-4232-4C46-8D0A-1B6079BCA07D@mac.com> References: <453D49D2.1010705@rogers.com> <3861E2E8-4232-4C46-8D0A-1B6079BCA07D@mac.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hello! On Mon, Oct 23, 2006 at 04:10:19PM -0700, Chuck Swiger wrote: > 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. I second that. And I just want to add: you can easily and reliably run this configuration in software by the means of gmirror and gstripe. Saves you some $$ that you would have spent on a "hardware RAID controller". And it's neither slower nor less reliable. For anything besides RAID 5, 6 or similar (and you don't want RAID 5 for a transaction heavy system) there is no need for dedicated hardware anymore. Just get a decent SCSI system with a hot plug backplane, of course. HTH, Patrick -- punkt.de GmbH Internet - Dienstleistungen - Beratung Vorholzstr. 25 Tel. 0721 9109 -0 Fax: -100 76137 Karlsruhe http://punkt.de
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20061024115811.GA10499>