homepage Welcome to WebmasterWorld Guest from 54.211.231.221
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe and Support WebmasterWorld
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

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




msg:4465654
 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.

 

StoutFiles




msg:4465666
 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.

jmccormac




msg:4465702
 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?

Regards...jmcc

Chrispcritters




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

TABLE 1
--> 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

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

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

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

TABLE 6
--> 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.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved