#2259: Support a read-only backend db
------------------------+----------------------
Reporter: dustin | Owner:
Type: enhancement | Status: new
Priority: major | Milestone: 0.8.7
Version: 0.8.6p1 | Keywords: database
------------------------+----------------------
The DB API currently only supports one `db_url`. We should support two,
so that most of the getXxx methods can use the read-only DB. Operations
that require read-after-write consistency would still use the read-write
DB.
MySQL supports master/slave replication, where the slave(s) can support
read-only operations, so this would allow us to scale database access
appropriately for read-heavy applications (e.g., frontend web servers).
MySQL replication has a small delay, so we'd still want to do things like
claiming buildrequests exclusively on the read-write DB.
--
Ticket URL: <http://trac.buildbot.net/ticket/2259>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Buildbot-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/buildbot-commits
