Since I'm currently looking at upgrading my own database server, maybe some
of the experts can give a comment on one of the following controllers:
- Promise Technology Supertrak ES4650 + additional BBU
- Adaptec RAID 5405 SGL/256 SATA/SAS + additional BBU
- Adaptec RAID 5405Z SGL/512 SATA/SAS
My personal favourite currently is the 5405Z, since it does not require
regular battery replacements and because it has 512MB of cache.
Since my server only has room for four disks, I'd choose the following
one:
- Seagate Cheetah 15K.6 147GB SAS
Drives would be organized as RAID-0 for fast access, I do not need
terabytes of storage.
The database currently is about 150 GB in size (including indexes), the
main table having a bit less than 1 billion rows (maximum will be about 2
billion) and getting about 10-20 million updates per day, so update speed
is critical.
Currently the database is running on a mdadm raid-0 with four S-ATA drives
(7.2k rpm), which was ok when the database was half this size...
Operating System is Gentoo Linux 2.6.31-r1 on a Fujitsu Siemens Primergy
200 S2 (2xXEON @ 1.6 GHz) with 4 GB of RAM (which also would be increased
to its maximum of 8 GB during the above update)
--
Jochen Erwied | home: jochen@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: joe@mbs-software.de +49-2151-7294-24, FAX: -50
D-45470 Muelheim | mobile: jochen.erwied@vodafone.de +49-173-5404164
