homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

How to Spec MySQL DB Server Requirements
How do I make sure I buy the right hardware for the job?

 10:27 pm on Jun 14, 2012 (gmt 0)

I'm trying to ask this in a way that allows other people to learn from the responses rather than just answering the question for me.

When trying to determine hardware specs for use with a machine that will be a dedicated MySQL DB server what factors should be considered? And how do you determine minimum hardware requirements to assure a responsive machine without overpaying? (Why buy a $10k machine when a $1k would suffice.)

CPU(s), RAM, Storage (RAID vs SSD vs stand alone drive).

I'm sure the size of table(s) and interaction with table(s) are impacted by DB type as well.



 11:44 pm on Jun 14, 2012 (gmt 0)

RAM is important, and SQL will want to use as much as possible for caching. Get as much RAM as possible.

CPU is not a huge deal, something mid-range will be fine.

I would suggest Raid 6 with SSD's.


 3:26 am on Jun 15, 2012 (gmt 0)

These are some of the considerations:

1: Will the database(s) be mainly read only?
2: If read/write, what is the projected numbers of writes and the read/write ratio?
3: What is the size of the indices?
4: What kind of traffic will the server have to cope with?
5: Will it be running as a single server or as a master with slave servers?
6: What kind of backup protocols will you need?



 3:03 pm on Jun 15, 2012 (gmt 0)

--> ID,date,varchar(32),int,bigint
--> 17,000,000 records
--> Once daily batch INSERT of 500k records, DELETE of 500k records, once daily SELECT, no UPDATES

--> ID,date,varchar(32),int,bigint
--> Table reset daily
--> Daily 500k INSERTS, 1m SELECTS daily, no UPDATES

--> ID,bigint,int,int
--> Table reset daily
--> Once daily INSERT OF 250k records
--> 1m SELECTS daily

--> ID,bigint,date,varchar(32)
--> 100k records normally
--> 500k INSERT, 500k SELECT, 50k DELETE daily

--> ID,date,date,varchar(32),varchar(512)
--> 1,000,000 records
--> 500k SELECT, 450k UPDATE, 50k INSERT daily

several other smaller tables w/ < 50k records with with < 1k inserts, 100k selects daily

single server
mysql dump export weekly

looking for capacity for 100% growth.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved