Welcome to WebmasterWorld Guest from 54.234.129.215

Forum Moderators: open

Message Too Old, No Replies

How to Spec MySQL DB Server Requirements

How do I make sure I buy the right hardware for the job?

     

Chrispcritters

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

5+ Year Member



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

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

WebmasterWorld Senior Member 5+ Year Member



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

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

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



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

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

5+ Year Member



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.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month