Ticket #2259 (new enhancement)
Support a read-only backend db
|Reported by:||dustin||Owned by:|
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.