[Buildbot-commits] [Buildbot] #2259: Support a read-only backend db

[Buildbot]

#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