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.
Description
Description
Status | Subtype | Assigned | Task | |
---|---|---|---|---|
· · · | ||||
Open | None | T176273 Move the wbc_entity_usage table onto a dedicated DB shard | ||
Declined | None | T176277 Provision a separate DB shard for wbc_entity_usage | ||
· · · |
Event Timeline
Comment Actions
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.
Comment Actions
This need hardware provisioning, and that means budget, and that means a detailed plan with our overall ok.