Page MenuHomePhabricator

Automatically run maintain-views and and maintain-meta_p when config changes on cloud replicas
Closed, DeclinedPublic

Description

It seems like we can automate all of

https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services

There might be some reason why this is hard or bad, but it doesn't /seem/ hard or bad.

Event Timeline

Andrew created this task.Oct 10 2017, 8:21 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 10 2017, 8:21 PM
bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.Oct 12 2017, 8:14 PM
bd808 removed Andrew as the assignee of this task.Nov 29 2017, 8:52 PM
bd808 triaged this task as Low priority.

I don't think this is such a good idea for now because of issues where view management collides with table locking from actual users, and the per wiki grants needed and race conditions therein. If we were to automate this I think it would have to sanely be integrated into an automatic pool/depool of labsdb backends at the haproxy layer and have some backoff check for grants first that was an expected condition.

Andrew closed this task as Declined.Nov 27 2019, 4:11 PM

Because this requires coordination with DBAs and pooling/depooling it's not straightforward to automate.