Page MenuHomePhabricator

Provision a separate DB shard for wbc_entity_usage
Closed, DeclinedPublic

Description

As discussed in T173189: Investigate separating wbc_entity_usage out to a separate mariadb shard and during Wikimania: We want to move (some of) the wbc_entity_usage tables away to a separate Maria instance, to ease the load of the main shards.

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusAssignedTask
OpenNone
DeclinedNone

Event Timeline

hoo created this task.Sep 19 2017, 10:09 PM
hoo added a comment.Sep 19 2017, 10:20 PM

Additional question: (How) Would this work for labs?

Marostegui moved this task from Triage to Backlog on the DBA board.Sep 25 2017, 4:35 AM

Additional question: (How) Would this work for labs?

There should not be too many issues for this to apply to the new labs servers, as we'd only need to add a new instance to the hosts (and sanitarium hosts) while doing all the split. If done at the same time with the production split, there should be no data consistency issues.
Otherwise, we'd need to reimport just that table.

jcrespo removed jcrespo as the assignee of this task.Nov 22 2017, 11:26 AM

This need hardware provisioning, and that means budget, and that means a detailed plan with our overall ok.

@hoo is this still something to be done?

hoo closed this task as Declined.Jul 27 2018, 9:57 AM

@hoo is this still something to be done?

No, I think we fine for now *crosses fingers*