If people would prefer this, that's fine with me. Here are some of my thoughts though.
I think not being able to query bugs across projects is a big limitation. I'm not sure how often this happens though. Having hundreds of projects in bugzilla is a mess, but there are other ways to deal with this. We could talk with the bugzilla developers about interface improvements that would be able to handle this many projects. We could also clear out the abandoned projects that are in bz. I had looked into removing abandoned projects at one point and opened a bug to track this. If people are interested in pursuing this, the bug is at http://bugzilla.mozdev.org/show_bug.cgi?id=2713 If there is agreement here to split bz, we can look into what would be involved in making the switch and report back. David > Forwarding this to project_owners for discussion as suggested by > David > Boswell: > > -------- Original Message -------- > Subject: Splitting up Bugzilla on MozDev? > Date: Thu, 15 Dec 2005 15:48:19 +0100 > From: Wladimir Palant <[EMAIL PROTECTED]> > To: David Boswell <[EMAIL PROTECTED]> > > Hi, > > I always wondered about the reasoning behind having one Bugzilla > instance for all projects. When I want to file a bug I have to choose > one of 473 (!) products. Searching is no better. And it is impossible > to > give project owners the necessary rights to manage their projects > themselves. > > My suggestion would be having one Bugzilla instance per project. This > doesn't have to mean a physical Bugzilla installation for every > project, > it can be as simple as having symlinks in the document root showing > all > to the same Bugzilla installation. With a simple change in the > localconfig file it will check which Bugzilla instance was called and > choose the database name appropriately, like this: > > http://bugzilla.mozdev.org/adblock/query.cgi: query.cgi is called > with > $db_name adblock > > http://bugzilla.mozdev.org/livehttpheaders/show_bug.cgi: show_bug.cgi > is > called with $db_name livehttpheaders > > Now having a separate Bugzilla database for each project has its > drawbacks. People shouldn't have to register and authorize in each > Bugzilla instance. My understanding is that MySQL starting with > version > 4.0 supports symlinks for tables. Most user info tables could be made > global (separate databases have only a symlink to the global table) > including the login table. Group tables on the other side would be > local > which allows giving permissions for one project only. > > I looked through the source code of Bugzilla 2.20 and it seems that > all > this can be accomplished without even touching Bugilla's code. The > only > disadvantage that I can see: searches over multiple projects won't be > possible (this is a major speedup at the same time). Updating > Bugzilla > might also be painful if the database structure changed, though > definitely less painful than managing Bugzilla for 473 projects all > by > yourself. But before I dig further into it I need confirmation that > there is interest of course. And if my suggestion is unacceptable - > it > would be interesting to know why. > > regards > Wladimir > _______________________________________________ > Project_owners mailing list > [email protected] > http://mozdev.org/mailman/listinfo/project_owners > _______________________________________________ Project_owners mailing list [email protected] http://mozdev.org/mailman/listinfo/project_owners
