Closed Bug 692507 Opened 13 years ago Closed 12 years ago

WebService API calls where appropriate should be using the shadow_db for read only operations

Categories

(Bugzilla :: WebService, enhancement)

enhancement
Not set
normal

Tracking

()

RESOLVED FIXED
Bugzilla 4.4

People

(Reporter: dkl, Assigned: dkl)

References

Details

Attachments

(1 file)

When performing read-only WebService calls, the shadow db should be more utilized to move some of the load off the master server. The calls where this could be implemented are:

Bug.get
Bug.comments
Bug.history
Bug.fields
Bug.search
Bug.possible_duplicates
Bug.attachments
Product.get
Product.get_selectable_products
Product.get_enterable_products
Product.get_accessible_products
User.get

I will work on a patch for this.

dkl
Patch that uses shadow db for read only api methods.

dkl
Attachment #565364 - Flags: review?(glob)
Why isn't this being tracked as an upstream bug rather than bmo-specific?
(In reply to Reed Loden [:reed] (very busy) from comment #2)
> Why isn't this being tracked as an upstream bug rather than bmo-specific?

It can be. I just wanted to prove first that it gave any sort of improvement specific to BMO's current environment. This is only useful for Bugzilla's which have master/slave configurations with the slave set as a shadowdb.

dkl
Moving upstream as I decide this would be low risk change to core Bugzilla code and could prove to be a boost to Bugzilla instances in a multi-db environment.

dkl
Component: API → WebService
Product: bugzilla.mozilla.org → Bugzilla
QA Contact: api → default-qa
Version: Current → 4.3
Severity: normal → enhancement
Comment on attachment 565364 [details] [diff] [review]
Patch to allow webservice methods to use shadow db (v1)

r=glob
Attachment #565364 - Flags: review?(glob) → review+
Flags: approval?
Flags: approval? → approval+
Target Milestone: --- → Bugzilla 4.4
Before committing, I hope you made sure none of these methods tries to write into the DB.
trunk:
Committing to: bzr+ssh://dlawrence%40mozilla.com@bzr.mozilla.org/bugzilla/trunk
modified Bugzilla/WebService/Product.pm
modified Bugzilla/WebService/User.pm
modified Bugzilla/WebService/Bug.pm
Committed revision 8126
Status: ASSIGNED → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: