Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

Thanks!!
Mannoj

share|improve this question
Do you have a specific question you need help with? If so, please edit this question to clarify it. As written you are posting a list of specs and asking for suggestions. – JNK♦ Oct 8 '12 at 15:51

closed as not a real question by JNK♦ Oct 8 '12 at 15:48

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

Browse other questions tagged or ask your own question.