Mozdev sysadmin meeting minutes for 2008-03-04

Present: davidwboswell (David Boswell), gjm (Gerry Murphy), silfreed (Doug Warner)

Discussion was held publically in #mozdev

Discussed developer priorities

- working on the UI to allow project owners to verify and release their downloads and extensions - working on mockups for a project overview page that would contain the publicly available downloads - trying to cleanup the queries used on D.MD.o

-   reduce CPU usage a bit by throwing users to a random mirror for
    update requests instead of their best mirror
-   able to speed up the query that gave users their best mirror

  • the extension list and tagged projects for an application are now merged into one list that shows both
  • notified POs that the Apache upgrade will be happening March 31st and helping POs prepare for that

Discussed sysadmin priorities

- stats processing is up to date and the cause of the backlog is being addressed - more spam blocks are in place - there's a problem w/ spamassassin dying and letting spam through but the cause hasn't been found yet - thinking about discarding all spam to lists that has a high spam score

Firefox 3 release

- mycroft is currently the biggest bottleneck when mass updates happen - we should focus on helping them get static updates provided - mycroft and downloads might have problems with updates not going through their scripts because stats will no longer be counted

Staging server migration

- no updates

SSL Cert renewal

- new cert is in place for 02/2008 - 03/2009

Protected wiki for sysadmin docs

- server docs were setup on a protected wiki page that only "mozdev" people can view/edit - we can setup perms per-page on the www wiki or setup a protected wiki on admin

Per-project databases

- we don't know what projects currently have access to mysql - projects currently can't configure db access w/o exposing the password - need to work to move projects w/ existing mysql access to their own dbs and then work on improving the policy to allow general access