Page MenuHomePhabricator

Prepare Quarry for multiinstance wiki replicas
Open, MediumPublic

Description

In the future, we have planned to move to a multi instance model for wiki replicas. This requires some changes on the client side to work, especially in Quarry, which currently connects to one database hostname and then lets you switch databases from there.

The requirements here are:

  • Set up a widget that lets you enter or select the database you wish to query.
  • Any backend changes that allow you to connect to the right domain name for the database you have selected (eg. frwiki.db.svc.analytics.eqiad.wmflabs)

Event Timeline

Bstorm created this task.Sep 30 2020, 11:40 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 30 2020, 11:40 PM
Bstorm triaged this task as Medium priority.Sep 30 2020, 11:40 PM
Bstorm moved this task from Backlog to Feature/implementation request on the Quarry board.
Bstorm moved this task from Inbox to Doing on the cloud-services-team (Kanban) board.

So far, I've discovered that the local vagrant dev environment has different DB encoding than the live DB, which is interesting. I believe I need to add a column to the query_revision table in order to record the query DB. On my local, I've got a nice little field for you to type in the DB, but I need to fix the model and column then make that do things to the DB connection. If it goes well enough, I'll put up a patch.

Change 632804 had a related patch set uploaded (by Bstorm; owner: Bstorm):
[analytics/quarry/web@master] multiinstance: Attempt to make quarry work with multiinstance replicas

https://gerrit.wikimedia.org/r/632804

Minimum working patch up. Hopefully review will improve it 😝