Date: Mon, 23 Oct 2006 19:44:45 -0400 From: Mike Jakubik <mikej@rogers.com> To: Chuck Swiger <cswiger@mac.com> Cc: stable@freebsd.org Subject: Re: Running large DB's on FreeBSD Message-ID: <453D53ED.5050403@rogers.com> 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
Chuck Swiger wrote: > On Oct 23, 2006, at 4:01 PM, Mike Jakubik wrote: >> So, first of all, am i crazy for choosing fbsd+mysql for this >> rather than something like Solaris + Oracle? :) > > Moderately...it kinda depends on the budget available. I regard > Solaris + Oracle as one of the most reliable combinations for moderate > to extreme load, for a system that might well be in operation for five > to ten years. If I was going to do FreeBSD, I might look into > Postgres instead of MySQL; well, I might look into something else than > MySQL under many circumstances. I've gotten some pretty good use out > of OpenBase, for another choice. > I believe the front-end application is MySQL dependent, but what is so much better about PostgreSQL? I understand that it has some more advanced features, but if they are not used, then what is the advantage? (I really like the InnooDB storage in MySQL) > 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. Is RAID5 really that bad when a lot of fast disks are used and the controller has a decent cache with a BBWC? Thanks for the feedback guys.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?453D53ED.5050403>