By djalloway on

My company currently hosts Drupal sites for 100+ clients.
We have one server running Apache 2.x, PHP 5.x and MySQL 5.x along with Drupal 6.x

Lately we have been running into a bit of a performance slow-down (nothing drastic... yet)
What I am looking for is in-sight into a better MySQL Database configuration to really handle such a load.

I've been running the MySQL Tuning Primer script from (http://www.day32.com/MySQL) which has really helped me along so far.

In the future we are looking at eventually hosting over 200+ clients all with their own unique Drupal installation and would hate to dead-end myself or run into some serious performance trouble.

What are the key MySQL configuration variables I need to be aware of to tune/modify?
Does anyone have experience in this scale of Drupal hosting?
Just looking for some resources / article / tips to point me in the right direction. (I don't just want to keep dumping more hardware to compensate for lack of Drupal DB Optimization knowledge).

Thanks in advance for anything anyone might have to offer.

⋅ Categories: Drupal 6.x

Comments

aitala’s picture

aitala commented

I would get a second server... some tuning may help, but doubling the number of clients will swamp whatever improvements you'll be able to make. All it takes would be one site to get a big traffic spike to take down the entire server...

E

__________
Eric Aitala - ema13@psu.edu
Penn State

224b8605113373e086cb27708ff301ba18ce394db1996e7e22928e4555e0d20b1b6cecc7f67c9bd9e536cb915779c485

djalloway’s picture

djalloway commented

Thanks for the reply Eric.
In my specific situation this is probably the way to go.

I just wish there was more information on configuring web server for use specifically with Drupal.

aitala’s picture

aitala commented

This link - http://wiki.cposc.org/_media/cposc2009_clark_mysqltuning.pdf - might be useful for MySQL tuning.

There are also some efforts into improving Drupal performance, but they usually modify core...

Eric

__________
Eric Aitala - ema13@psu.edu
Penn State

224b8605113373e086cb27708ff301ba18ce394db1996e7e22928e4555e0d20b1b6cecc7f67c9bd9e536cb915779c485

vm’s picture

vm commented

2bits.com has quite a bit of information regarding tuning and benchmarking. The performance group on groups.drupal.org may also be worth a visit or 10