Advice on server layout

MySQL & MariaDB Other MySQL® Questions
1

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.

2

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.