Date: Tue, 24 Oct 2006 14:34:25 +0200 (CEST) From: Oliver Fromme <olli@lurza.secnetix.de> To: freebsd-stable@FreeBSD.ORG, mikej@rogers.com Subject: Re: Running large DB's on FreeBSD Message-ID: <200610241234.k9OCYPDJ016930@lurza.secnetix.de> In-Reply-To: <453D49D2.1010705@rogers.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Mike Jakubik wrote: > 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. As others have noted, RAID5 is worst-case for databases. For both reliability and performance I recommend RAID1 or RAID10. > So, first of all, am i crazy for choosing fbsd+mysql for this rather > than something like Solaris + Oracle? :) My recommendation is FreeBSD + PostgreSQL. I've worked quite a lot with various Mysql and PostgreSQL databases in the past, and the latter outperforms other combinations in general. Also it is my impression that PostgreSQL is much more reliable and resistant against evil things like crashes (power failure or whatever), thanks to its WAL data storage which is similar to a journaled file system (transaction-aware, of course). A few years ago (2002) I fed the German phone book into a PostgreSQL database running on a Pentium-III 800 MHz with 256 MB RAM (FreeBSD 4-stable). I was just curious how well it would cpe with that. Importing the 35.6 million rows and creating an index took 40 Minutes (I think I didn't even use the optimized COPY instruction, so it could have been even faster). Select commands on the table were processed surprisingly fast, but I didn't really hammer on it because the machine was running a production Apache at the same time. :-) Best regards Oliver -- Oliver Fromme, secnetix GmbH & Co. KG, Marktplatz 29, 85567 Grafing Dienstleistungen mit Schwerpunkt FreeBSD: http://www.secnetix.de/bsd Any opinions expressed in this message may be personal to the author and may not necessarily reflect the opinions of secnetix in any way. "If you aim the gun at your foot and pull the trigger, it's UNIX's job to ensure reliable delivery of the bullet to where you aimed the gun (in this case, Mr. Foot)." -- Terry Lambert, FreeBSD-hackers mailing list.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200610241234.k9OCYPDJ016930>