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)
Tracking
()
RESOLVED
FIXED
Bugzilla 4.4
People
(Reporter: dkl, Assigned: dkl)
References
Details
Attachments
(1 file)
3.75 KB,
patch
|
glob
:
review+
|
Details | Diff | Splinter Review |
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
Assignee | ||
Comment 1•13 years ago
|
||
Patch that uses shadow db for read only api methods. dkl
Attachment #565364 -
Flags: review?(glob)
Comment 2•13 years ago
|
||
Why isn't this being tracked as an upstream bug rather than bmo-specific?
Assignee | ||
Comment 3•13 years ago
|
||
(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
Assignee | ||
Comment 4•13 years ago
|
||
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
Updated•13 years ago
|
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+
Updated•12 years ago
|
Flags: approval? → approval+
Target Milestone: --- → Bugzilla 4.4
Comment 6•12 years ago
|
||
Before committing, I hope you made sure none of these methods tries to write into the DB.
Assignee | ||
Comment 7•12 years ago
|
||
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.
Description
•