D5

So supposing you have several sites on D5 that won't get upgraded to D6 (to take advantage of the syslog support) for several months yet due to workload, what are good ways to optimize InnoDB so that Watchdog can write faster, i.e more concurrent INSERT statements, rather than taking down the site if things get fubar'd? Thanks :)

I am the back-end engineer/architect working on consolidating a number of production web sites using Drupal 5.11 with the Drupal Memcache API as a base along with the multi-site configuration.

Here's the architecture so far...
- 2-node load balancer front-end (2 Cisco ASA 5510s)
- 4-node web/app servers: RHEL 5 + GFS + Drupal Memcache API + Memcached (Quad Xeon, 8GB Ram each)
- 1-node MySQL 5.x database server with two other MySQL servers in hot stand-by mode (Quad Xeon, 16GB Ram each)
- EMC SAN Storage (1.5TB allocated)

I set up a staging server for a multi site and it seemed that is was working fine. I then install the blog module as use1. I had no problems. when I tried to give an authorize user access the select boxes looked good. after submitting the page I looked and the box we empty (not changed.)

Perms on the files and directories all seem right and match the production site.
checked node access and reentered the code, no difference.

on the staging site a new install was done the sites directory was copied from production.