FreeBSD hardware solution for a database server

[jmc]

For the best database-write performance on the DL380G4, make sure you
have the Battery-Backed Write Cache (BBWC) option.

The more spindles you have, the better.  Are you using all 6 drive
bays in the 380?  Make sure they're all Ultra320 drives.  15K will
give the best performance, but the 10K drives aren't too shabby. 
RAID0 will give the best performance, but it's not redundant.  Next is
RAID1, then RAID5 or ADG.

You might also try a DL385 (dual socket Opteron) or DL585 (quad socket
Opteron) which will give you either 4 or 8 procs (if they are dual
core).

Regards,
John
http://people.freebsd.org/~jcagle/

On 8/19/05, Uzi <uzi at bmby.com> wrote:
> Hi
> 
> I am looking for a FreeBSD 5.4 hardware/configuration solutions for a MySQL
> database server.
> 
> My server is currently running FreeBSD 5.4 with a web/mail/database server
> on a Proliant DL380 G4 (dual Xeon 3.2, 2 GB ram), and the speed isn't fast
> enough.
> 
> We have a pretty big database with allot of complex joins/indexes, so a
> dedicated database server seems like the next step (among with
> optimizing/normalizing the database).
> 
> 
> 
> Proliant DL580 looks fair to my eyes (as I'm pretty happy with HP)
> 
> But I have a few indecisions:
> 
> 
> 
> 1. 2/4 CPU
> 
> 2. Amount of ram (4 GB+)
> 
> 3. And most important (AFAIK) - Storage configuration (RAID 5 / RAID 0+1
> etc.)
> 
> 
> 
> What would be the preferred solution?
> 
> 
> 
> Thanks,
> 
> Uzi
> 
> 
> 
> P.S - Please CC me the replies as I'm not subscribed. Thanks.
> 
> 
> 
> 
> 
> 
> _______________________________________________
> freebsd-hardware at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-hardware
> To unsubscribe, send any mail to "freebsd-hardware-unsubscribe at freebsd.org"
>