The Future of Performance: Scaling

[Frédéric Buclin]

Le 02. 01. 09 08:35, David Miller a écrit :
> Yeah, the master DB for Bugzilla gets more traffic than the slave DB
> does on bmo right now, which makes it kind of meaningless to add slaves,

IMO, that's because query.cgi uses the master DB to populate the search 
form, and buglist.cgi prepares everything using the master DB, and only 
shifts to the shadow DB at the very end when it's time to run the huge 
query. I think both should shift to the shadow DB, the only exceptions 
being when they write to the DB (when updating the default query or 
deleting/updating a saved search).

I also suspect more and more third-party tools call config.cgi to know 
the config of Bugzilla, but this script uses the master DB too, despite 
it's pure read-only. So we could shift to the shadow DB without problem.

describecomponents.cgi and describekeywords.cgi are also good candidates 
to use the shadow DB. It doesn't matter if the number of bugs reported 
by keyword is off by a few minutes, really.

Maybe more controversial is show_activity.cgi, which *could* eventually 
use the shadow DB too. Note that BugMail.pm doesn't call 
show_activity.cgi to generate bugmail, so this wouldn't break anything.

Other scripts look fine to me. I will file a bug to do these suggested 
shifts so that we have a more centralized way to track what should be 
changed or not.

LpSolit