Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What are some guidelines to follow when it comes to sizing MySQL Servers? CPUs, RAM, Disk Space, Clock Speeds, etc?

We're going to go with either the community edition or the enterprise edition, and use it to run Drupal for a www and other top-level sites. OS is RHEL 6.x, on VMWare. We'll also probably run a caching tool, like memCache or Varnish. At the moment we are looking at two load balanced web servers that connect to one or more MySQL servers. There is talk of possibly using a master-slave or multi-master configuration. DB engine is going to be InnoDB.

We're looking at about 6000 pages of content to start, and grow quickly. Our normal throughput is about 40Mbps (observed over one hour), although we've seen it as high as 70Mbps occasionally.

Thanks,

KM

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

I answered a question like this in another StackExchange site but only from the MySQL point of view

Please follow all links in this answer. Thank You !!!

share|improve this answer
add comment

I was waiting for more experienced people to answer, but one thing I will point out, since you're using innodb engine. You'll want sizeable amount of RAM to increase the innodb_buffer_pool_size so that it can hold your dataspace, if possible. So if your database takes up 6GB, it's feasible to set the buffer_pool_size to catch it in RAM (assuming you can address that much RAM...see below). But if the database takes up 64GB, it might be a stretch (at least for something like my small company's budget) to get a server with enough RAM.

You'll need to make sure your CPU architecture and OS is 64-bit. I ran into this recently, where an old xserve upgraded to Mac OSX 10.6 can't utilize >4GB of RAM per process. Probably not an issue with modern servers.

share|improve this answer
    
Thanks @DTest, +1 for innodb buffer pool size suggestion. Hopefully this encourages others to chime in as well (-: –  KM. Apr 20 '11 at 16:48
    
as a followup, an old (but probably still relevant) performance blog post: mysqlperformanceblog.com/2007/11/03/… –  Derek Downey Apr 20 '11 at 17:22
    
Read your answer carefully. +1 !!! –  RolandoMySQLDBA May 12 '11 at 19:06
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.