delete_later - read_only database

[Andy Lo A Foe]

On Jan 29, 2008 4:00 PM, sanados <sanados at failure.at> wrote:
> 2)
> is there a possibility to add a db connection to the tracker which it
> will use for selects?
> in our mysql master-slave enviroment it would be good if the tracker
> only asks the slaves for files.
> So that only update and inserts run over the master-db connection.

You can cache the lookups using something like memcached on the
application level, should reduce lookup traffic considerably and be
much faster anyway. There also seems to be a Perlbal based caching
mechanism but have no experience with that.

Gr,
Andy