Mozdev sysadmin meeting minutes for 2007-12-04

Present: cdn-work (Chris Neale), davidwboswell (David Boswell), gjm (Gerry Murphy), kinger (Brian King), silfreed (Douglas Warner), tanker (Michael Dosser)

Discussion was held publically in #mozdev

Discussed developer priorities

- theme cleanups for w.r.t. http/https - updates - redirection to closest mirror and serving files directly from D.MD.o - work is staged, waiting deployment later today - mirror work is almost done; the "secure installs" feature is kind-of mirror work, but not lumped in there right now. we'll discuss this during the roadmap updates - bugzilla permissions have been requested by about 10 projects so far - upcoming this week is to deploy the download server changes and start working on categorization of projects

Discussed sysadmin priorities

- cleaned up the bugzilla db; errors reported by the sanity check are fixed - mailman messages are still stuck in the held queue - web stats are being reprocessed to correctly handle our "unique" log format - apache config was modified to reduce the number of requests per child in order to free up memory - current theory is that there is a memory leak in php-mysql because the problems started around when new features were added to and drupal was released - both of which make much more use of mysql than before

Open sourcing more code?

- there have been project owners in the past and recently who have been interested in contributing to the site but are unable to - the goal is mostly just to make the code available; not so much to get to a "packageable" state as in the hovercraft project - the code under /sandbox/php is available in the hovercraft project but is very out of date - getting this code into CVS would ease the barrier-of-entry to new developers - they most likely wouldn't need server access as early - Pete and Chris probably have more ideas on why this isn't in CVS yet - Doug will write them to check

Revising roadmap priorities (reversing order of 2nd stage?)

- adding secure installs to the first priority block - flipping order of second block so that subversion is first - there are still a lot of questions about how we will support SVN, CVS, and potentially other VCSes and general web space - apache 2 + PHP 5 upgrade will need done soon, but won't be added to the roadmap

CVS mysql auth patches

- we don't know where the MySQL patches to CVS are currently - our CVS server is fairly old (v1.11.11) and it would be good to update it - Doug will contact Pete to find out where the most recent patches are - it would probably be best to put this under and advertise the patches

Bugzilla UTF-8 upgrade

- will require some downtime after testing on

Amazon VM discussion - VM vs Physical Machine

- VMs are fast to deploy, but slow at I/O - push spam or other email processing to the VM? possible, but Amazon charges for bandwidth as well as CPU time and disk space, so might not be cost effective. - OSUOSL is offering VM services - this might be the best solution for us for adding quick horsepower