The Future of Performance: Scaling

[Max Kanat-Alexander]

On Tue, 30 Dec 2008 22:16:20 -0600 "Bradley Baetz" <bbaetz at acm.org>
wrote:
> In general, we scale read-only pretty well. 

	Yeah, although there are a few operations that don't take as
much advantage of that as they could. There are probably a lot more
places where we could be using the shadow DB.

> The shadowdb stuff pushes db reads off, but Bugzilla doesn't have a
> clear goal as to how out of date data can be - if we relaxed the rules
> a bit then some more queries could possibly move to the replication
> db. However, I don't think that thats much of an issue given the
> typical read:write ratio.

	Yeah, on most installations I don't think it's an issue, but at
places like bmo it could always be handy to see what else we can push
off. Apparently the ratio of master reads to slave reads increased a
lot in 3.2 for some reason, and we should probably look into it.

	-Max
-- 
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.