Ticket #2259 (new enhancement)
Support a read-only backend db
| Reported by: | dustin | Owned by: | |
|---|---|---|---|
| Priority: | major | Milestone: | 0.9.+ |
| Version: | 0.8.6p1 | Keywords: | database, sprint |
| Cc: |
Description
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.
Change History
Note: See
TracTickets for help on using
tickets.
![[Buildbot Logo]](/chrome/site/header-text-transparent.png)
This is not terribly difficult, but I don't know of anyone who needs it just yet.