Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We are working in a new website (a typical web 2.0 website). We are going to use drupal and mysql. We expect to have an estimated traffic of 2000 users per day (perhaps 200 - 300 new users per day). Based on your experience, could you recommend the adecuate hardware to support this? We can have 2 separate servers (for MySQL and for Apache).

Thanks,

Ezequiel.

EDIT: Basically site will serve a lot of static information. Also will contain a blogging section. EDIT2: Information won´t change so frequently, lot of queries are expected because of drupal.

share|improve this question

closed as off topic by sysadmin1138 Jan 5 '12 at 3:25

Questions on Server Fault are expected to relate to professional server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

    
How long is a piece of a string? More information is required. What is the site going to be doing/serving? Lots of files? Just basic page impressions? –  Izzy Aug 24 '09 at 15:55
    
Will it be like the StackOverflow traffic? Will it serve high updates, lots of queries, etc? –  MarlonRibunal Aug 24 '09 at 16:17
    
Product and service recommendations are specifically off topic for ServerFault (see point 4 in the NOT About section of the FAQ) –  sysadmin1138 Jan 5 '12 at 3:25

4 Answers 4

up vote 1 down vote accepted

I used to work for an e-commerce company. We had in the vicinity of several hundred thousand unique visitors per day, most of whom visited on average around 10 pages. This website was run off 2 x 1U Dell PowerEdge 1750 with 2GB RAM, SCSI RAID1 drives (web servers, Debian, Apache) and 1 x 2U Dell PowerEdge 2950 with 4GB RAM and SCSI RAID10 drive(databases, Debian, MySql).

If you translate this back into your situation, I would suggest that just about any 1U server will do the trick for you, if configured correctly. There are probably plenty of people here that will scream in horror, but realistically anything more than your plain vanilla 1U server would be just overkill in your situation.

As traffic increases, you'll get the biggest boost out of separating the database from the web server (saves a lot of context switching).

share|improve this answer

Check out the "resourceful hosting" document on the Drupal site. Even though the document was targeted for the year 2008, I think they have a good baseline to help you understand what you need.

share|improve this answer

Drupal is highly relational so MySQL will bear the brunt of the performance hit so I'd spec accordingly.

Thankfully the Drupal community has come up with lots of strategies to overcome some of Drupal's scalability shortcomings.

For example, use of the memcache module (http://drupal.org/project/memcache) to get the cache tables out of the database.

Cheers

share|improve this answer

You might want to look into Project Mercury for this- it bundles a couple different performance enhancements (Pressflow Drupal + APC for PHP + Varnish for handling anonymous users) into one convenient EC2 Amazon Machine Image. It's late in the Alpha stage, but you can spin it up for dev pretty cheaply on Amazon and pick up config tips for your own hardware there.

share|improve this answer

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