I am looking to setup 250+ sites on one machine using a standard Drupal Multisite setup with one codebase. None of the sites gets many hits (no more than a thousand a day). They do have a fair amount of users with some sites having 1,000+ users. I was wondering if anyone had any experience with having that many sites and if there were any special configurations that needed to happen in MySQL 5.1 or Linux.
Also, is there any performance difference putting them all in one database with site prefixing vs. having one database per site? And does it matter if you are using innoDB or MyISAM tables?
I came across this article: http://www.askbjoernhansen.com/2008/02/14/10000_tables_in_one_mysql_data... that had some hints for configuring a database with a ton of tables, and was wondering if that was good advice or not.
Thanks,
Matt
Comments
We have approximately 100
We have approximately 100 sites running off of one webserver and one db server. Our load is similar to what your describing. We have a central table that stores users and some other tables thhat are referrenced by all sites. Haven't had any db / performance issues. Only thing we had to watch for was innapropriate setting of log files that madde them astronomically large bc we were logging everything going on and weren't purging them.
Anything special though no for us. This setups running fine for another on campus who has a similar size/scale.
Ex Uno Plures
http://elmsln.org/
http://btopro.com/
http://drupal.psu.edu/