FreeBSD hardware solution for a database server

[Jim C. Nasby]

On Sun, Aug 21, 2005 at 03:40:18PM +0200, Uzi Klein wrote:
> 2 mirrored drives mounted as /
> 3 RAID 5 drives mounted as /var

RAID5 pretty much sucks for databases that do anything more than 1-5%
writes.

> Are you suggesting AMD based boxes outperforms Intel based machines?
> That's what I'm really interested in...

At least with PostgreSQL they do, by a large margin.

> I know it's time for a dedicated fast database server.
> If i optimized my database and hardware settings, i could gain months, 
> not more.
> The question is upgrade to what (Assuming my DL380 isn't enough)

Keep in mind that a poorly designed app will completely kill you once
you try and scale past a certain level.

Also, I've heard that PostgreSQL tends to do better on complex queries
than MySQL if migrating is an option. Might be worth looking at. Note
that the out-of-the-box config for PostgreSQL is appropriate for like a
486, so you'd need to do some tweaking.
-- 
Jim C. Nasby, Database Architect                decibel at decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"