Opened 6 years ago

Last modified 5 years ago

#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 (3)

comment:1 Changed 5 years ago by dustin

This is not terribly difficult, but I don't know of anyone who needs it just yet.

comment:2 Changed 5 years ago by dustin

  • Keywords sprint added

comment:3 Changed 5 years ago by dustin

  • Milestone changed from 0.8.+ to 0.9.+

db modifications should be done in nine at this point.

Note: See TracTickets for help on using tickets.