homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
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?

5+ Year Member

Msg#: 4465652 posted 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.



WebmasterWorld Senior Member 5+ Year Member

Msg#: 4465652 posted 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.


WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

Msg#: 4465652 posted 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?



5+ Year Member

Msg#: 4465652 posted 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