Well the aim of this thread is to see if there are large wpmu hosts (in terms of number of blogs hosted) visiting here regularly, and maybe do so sharing of specific tweaks we may have applied to have wpmu behave better / done specifically due to large numbers of visitors. Probably to be considered a "large" host in wpmu terms would mean at least 1000 blogs hosted.
I run a french language wpmu blog hosting service, got past 12000 blogs hosted today. It is about 1 month and a half old, growing quickly (300-400 new blogs daily, not all of them becoming active though).
It runs with other sites (a few of them quite popular) off a dual xeon 3.2 box with 2 gigs of ram and scsi raid disks.
I'm having it updated to 4 gigs due to swap problems, that seem to be related to the growth of the blog hosting site.
I'd be particularly interested myself in discussing database optimizations / changes others may have made on the db side.
- Has any of you made changes in mysql configuration that lead to significant improvements of performance?
- How do you manage a database of multiple thousands tables?
- Has anyone implemented yet a multiple database instances installation?
- In such case, how did you do it, and how did you migrate from the single db to multiple db version?
- Talking about migration, has anyone tried yet moving versions of wpmu, what is your feedback on how easy / complex that was?
It'd be nice if we could get this thread into a tip-sharing discussion for handling large wpmu sites.