MySQL Forums
Forum List  »  Install & Repo

Pre-Requisite for new installation
Posted by: Mannoj Kumar
Date: October 08, 2012 05:29AM

To standardize the resource procurement for the below consolidated one.

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?


Options: ReplyQuote

Written By
Pre-Requisite for new installation
October 08, 2012 05:29AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.