Page MenuHomePhabricator

Trove for some ToolsDB users(?)
Open, MediumPublic

Description

We've talked about this in the past, but never actually made a task. The upcoming Stretch deprecation seems like a good opportunity to do it.

ToolsDB is a heavily loaded shared database. Combining many small users to a shared database makes some sense, but we should move some of its larger/heavier users to separate instances. Doing it via OpenStack Trove seems like the best solution.

Still to sort out: backups, replication?, how to enable self-provisioning of a new db by a Toolforge maintainer

Event Timeline

Ideally we would migrate all users off of toolsdb onto Trove or something else. Anyone who isn't using any esoteric "features" of ToolsDB and who can migrate should do so.

I would like to Trove to have replication and/or backup solutions available before we move much user data there. The existing toolsdb has both backups AND replication so it's a step-backwards in terms of resiliency until we have Trove spruced up.

aborrero triaged this task as Medium priority.Oct 13 2021, 3:17 PM
aborrero moved this task from Needs discussion to Blocked on the cloud-services-team (Kanban) board.