MD1000 or PV220S for MySQL cluster

[Robert von Bismarck]

Hello,

We are looking into upgrading the database backend that handles our RADIUS accounting data.
We currently run a PE2650 dual-cpu, 4GB of RAM, with twelve 9Gb SCSI disks in a sun D1000 array, connected to an old sun NCR53C785 scsi card (it works, don't ask :). This is of course using software raid5, the PERC array is used only for the system/swap devices, the mysql data is on the raid array. This runs Mysql 4.0 on SuSE 9.3, with default kernel.

The system we're looking at, would be a couple of PE1950 dual-core, 4Gb of RAM as mysql master-slave replicas, each server attached to the same MD1000 or PV220 by a PERC4 or PERC5. We don't need a huge amount of disk space, as we're legally bound to keep only 12 months of data, which currently amounts to about 60Gb of data, so two arrays with 4*146Gb drives in RAID 0+1 plus one spare each is plenty.

Now comes the tricky question, which PERC is more stable under linux, knowing that we'd run CentOS 4.4 with MySQL 5.1 ?
Of course our sales rep tried to sell us an MD3000, but this is really so much bleeding edge, that I'm suspicious :)

The current db load averages at 12'000'000 rows INSERTed each month in a new table, and a potential wholesale customer that will double or triple this load. SELECT load is very limited.

Thank you for any experiences, hints, suggestions, free t-shirts, etc :)

Cheers,

Robert von Bismarck
Senior UNIX Systems Engineer
RHCT

VTX Network Solution SA (une société du groupe Smart Telecom)
==============================================================
Tél. direct : 021 721 11 11 - Mobile : 079 541 37 28
Avenue de Lavaux 101 - 1009 Pully
http://www.vtx.ch - robert.vonbismarck at smart-telecom.ch
==============================================================