Home » Performance » MySQL » Advice on server layout
Advice on server layout [message #462] Sun, 10 December 2006 19:18 Go to next message
sprbck  is currently offline sprbck
Messages: 2
Registered: December 2006
Junior Member
Hello,

I was asked to layout a server that will serve as a centralized db server for a small scale hosting company. This server will substitute MySQL on 3 servers, with a current total of 2GB db data.

I was thinking of the following:

- DELL PE2950
- 1 x Xeon 5130 (2Ghz)
- 2GB RAM
- 6 x 36.4 GB SAS 15K RPM
- PERC 5/i RAID (256MB, battery backed)
- CentOS 4.4

I was thinking of RAID10 for the 6 disks, for best performance.
Or, 8 disks, one extra for system and MySQL logs (will be replicated eventually), and another extra as hotspare.

Anyone has tried similar setup? I'm not sure of it, because we are not talking about one single database, it's dozens of them, with all sorts of apps.

Any comment will be appreciated, tks.

Re: Advice on server layout [message #679 is a reply to message #462 ] Tue, 06 February 2007 14:00 Go to previous message
Peter  is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
This is decent hardware. I would however invest in RAM more if your database is more than few GB in size.

RAID10 is better for writes and HA than RAID5 while last one provides more space.

For reads RAID10 and fully operational RAID5 are close.


Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Previous Topic:Using inner selects
Next Topic:GROUP BY with ORDER BY without using filesort/tmp table
Goto Forum:
  



Current Time: Fri Dec 5 11:32:09 EST 2008

Total time taken to generate the page: 0.00544 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge