I'm logged in as hallman on groups.drupal.org and trying to comment on a post --
http://groups.drupal.org/comment/reply/26213 -- and get the message:
"Your submission has triggered the spam filter and will not be accepted."
This is what I'm trying to post...
Attempting my first major upgrade
I got interested in Drupal because of multi-site hosting and CiviCRM. I'd like to make it easy for nonprofits to use CiviCRM. Right now I'm working on upgrading my sites from Version 5 to 6 and am concerned about having to do them all at once. I'm currently evaluating each of the modules I'm using and making changes (like changing from the Events module to Calendar/Date/Views). I'll try to remember to post again when I'm done.
Allen, do you have scripts or other tools that you use to take all your sites off-line for maintenance, run update.php, and then put them all back online again? It takes me a while to complete an update doing each site manually -- the total time the sites are offline is longer than it would be if each site had its own code.
So I tried commenting on another post and got the same thing ...
http://groups.drupal.org/comment/reply/26125
Your submission has triggered the spam filter and will not be accepted.
My attempted post was this post with subject "Problem commenting."

Comments
Sorry you ran afoul of the
Sorry you ran afoul of the spam filter. I haven't had any problems with it here so I have no clue what might have set it off.
I don't have any special scripts or tools for updating/migrating multi-site installations because we don't do mass updates. With 30+ sites and a single core codebase the downtime associated with updating everything simultaneously is simply unacceptable. Upgrades (and especially migrations) are performed on a site-by-site basis.It avoids the potential creeping nightmare of having three or four sites simultaneously b0rked by a module upgrade.
As far as migrations go, while I've migrated some of our simplest sites (think single user blog, no custom code, fewer than 10 contrib modules installed) at the same time a lot of our sites have quite a bit of custom code that has to be ported over & tested so we generally treat migrations as an opportunity to "refactor", so these are definitely done one at a time as well.
Generally what I end up doing is creating a separate migration installation that uses a copy of a site's database. Once I've gotten the kinks worked out so update.php runs cleanly and all of the site's custom code is ported to the next version of Drupal I'll drop the live site into maintenance mode, take a final snapshop of the database, port it over to the dev site, run update.php, then change the site's virtual host settings to point to the dev site. Once that goes live I delete the original and go on with my day. Kinda wonky but it works well.
I don't know if this helps or not. Let me know if you have any specific questions. :)
-Allen
hi
I am very happy to find this post very useful for me, as it contains lot of information. I always prefer to read the quality content and this thing I found in you post. Thanks a ton for sharing !
That helps a lot. I can't
That helps a lot. I can't change the virtual host settings for my sites. I have a test site and check things out there, but then have to do all the real sites at once. There aren't many, and they are very small and not very active.
Judy Hallman
The virtual host stuff is an
The virtual host stuff is an artifact of our hosting environment (we're using a convoluted series of reverse proxies and external caching). It isn't really necessary for "normal" hosting setups. This probably goes without saying but if you do opt to do a mass migration I urge you to back up your databases before you make any code changes. Good luck!
Mass Updates
I feel the same way about mass updates: it's just not worth the trouble.
Every time you do an update, even a simple one, the "right way" is some variation of: copy to development, run the update, make sure it worked, take live down for maintenance, run update on live. You can't make sure the update didn't break your sites in bulk, not really.
Also, I strongly recommend against using Drupal multisite unless you actually need to share data. Having all those sites be reliant on each other will be painful at some point down the line. A better approach is to use SVN externals to have a central code repository (Drupal core in on repo, shared modules in another, each site having all/default in one of its own). Then, you can update each individual site easily, but you aren't forced to do them all at once.
We don't mess with virtual hosts for consistency reasons but that may be acceptable for you if your maintenance periods absolutely have to be as small as possible.
Ken Winters
I'm curious, how are you
I'm curious, how are you using multi-site to facilitate data sharing?
Multi-Site
Right now the only place we use multisite is basically an affiliate system, and each affiliate has a separate DB prefix / subdomain. In this case we made the affiliates not share data directly (so that affiliates can't see each others' data), but if that wasn't a restriction we may have just had them share data instead of just code.
The main site has a content type for affiliates, including the DB prefix and what the URL is for the subsite. This mainly just facilitates aggregates and other reports on the main site.
Ken Winters
Ah cool. If it came out that
Ah cool. If it came out that you'd figured out some way to use multi-site to make db integration suck less I was going to start plying you with free meals until you divulged your secrets.
Multi-Site
Dang, so close! ;-)
Sometimes people want to have multiple sites that are related but do different things and share data (blog.example.com, www.example.com, etc. and share login info), and in almost all cases I'd tell them just to have one site with everything integrated.
If you want to share nodes, etc. it's probably less hassle to just export the important nodes as a feed and sync them with feedapi (or some similar shared data source) than try to share the tables directly.
Ken Winters
SVN
Would you be willing to share some more information about your SVN setup? I currently have a multisite Drupal install that has a handful of very similar sites. I have it set up within a single SVN repository. The main thing that I'm struggling with is how to create a dev/staging/live setup with an ever-changing database...
SVN
There isn't much more to our SVN setup than my previous comment. Core repo pulls in sites/all/modules as an svn external to a shared repo, and sites/all/themes & sites/default are in the per-site repos (though really there's little reason the theme couldn't be in sites/default).
The database isn't something you should try and back up with SVN, that's a lost cause. We make mysqldumps as needed, and occasionally use http://drupal.org/project/backup_migrate as a helper. Server-wide automatic backups are done with a separate cron script.
Getting live data to devel is easy, but going the other way is hard. Sometimes it's better to just set up http://drupal.org/project/patterns and use that to script your data creation, or get all of the nodes / blocks / views etc. into modules that you can just enable on live to push.
I don't have a really good solution for major content editing on staging and then pushing live when happy, yet. It gets rough when you have public user-created data to merge in, like comments or public user profiles (don't even try it with OG). Everything I've done so far has required someone with core knowledge to do.
Ken Winters
Thanks! I have some cron
Thanks! I have some cron scripts that do a nice job of getting data from live -> dev and I had kind of expected that there isn't a good way to get staging -> live. I had not heard about the patterns module and it seems like that could actually be pretty useful for our situation.
How this can happen
Spam filter is often set by the sites admin to accept quality debate in comments and so that only quality comments gets publish. But I have one question as one of my friend asked you above also that, how we can use multi-site to facilitate data sharing? Engineering Jobs
Spam Filter Problem
I am rattling glad to deed this aggregation real utilizable for me, as it contains lot of information. I always raise to construe the quality content and this occurrence I launch in you post. Thanks a ton for distribution
This is a big help for as a blog poster.well done!
WhichBrace