To standardize the resource procurement for the below consolidated database requirement.
Max TPS per table can have 200 inserts and size can round range upto 30GB of data and records can go upto 50 million per day on cdr_details table. Good news is that this table will be rotated every EOD. And selects may go for every now and then on this table. Can someone suggest me initial hardware/software/DB config requirements that I should have in place. Like below?
Server Memory : 16 GB RAM
Disk Space :
/ -> 840 GB ((30 GB data + 30 GB Binary Log) *14 days )
/data -> 420 GB ((30 GB mysqldump + 30 GB Binary log) * 7 days)
RAID : RAID 1+0 (Stripped then mirroring - For better read/write IO.)
PCI : HDD With Intel SSD SATA ( For 200+ concurrent connections /s and data trfr rate over n/w).
Processor : Quad Core
OS : CentOS release 5.8 (Final) - (Company standard and goes well with mysql too)
Mysql Version: 5.5.26 GA - Latest GA for Asynchronous IO on innodb algorithm for greater IO performance on tables.
Can someone add or modify if any required?