Topic on User talk:BDavis (WMF)

Following up on replication drift

8
Le Deluge (talkcontribs)

Hi Bryan Following on from our discussion a few months ago I was just wondering where we were on the new servers. I see there's been progress on Phabricator but was wondering what the timelines were looking like?

I've just had an instance where one of the zombie categories has been successfully cleared, apparently by someone creating it on enwiki and it then getting deleted. I've got my own test running on another cat but I was wondering where we go from now. Is there going to be a complete ground-zero wipe of the Labs database, or is the idea that we keep the one we have but delete operations will work? I'm in no hurry if it's a question of waiting for ground zero, but if it's the latter then I might as well get on and delete-cycle the remaining zombies on the reports I work on. Cheers. Le Deluge (talk) 12:10, 25 August 2017 (UTC)

BDavis (WMF) (talkcontribs)

The new wiki replica cluster is fully populated and ready for use by tools. Just before Wikimania we created phab:T172704 to track efforts to attract beta testers of the new servers. I'm hoping to post something to labs-announce and our phame blog soon about that, but the current phab task has all the details that should be needed for people to start using the new servers.

Le Deluge (talkcontribs)

Thanks, although I was hoping for a bit more of a phabricator-English translation, from the perspective of an occasional Quarry user. But no matter, I've been able to remove most of the zombies from my two main reports by editing or delete-cycling them, with one exception - but at least my OCD has been largely sated! [[en:Category:Law about religion in the United Kingdom]] is still stuck - it's possible that it's in a bit of the Labs db that's particularly out of sync, as it was one of a number of cats created at the same time that all had problems, but I was able to fix most of them. Any ideas about that one?

BDavis (WMF) (talkcontribs)

There is a blocker for converting Quarry to use the new database servers. The datasets_p database is not currently available on the new servers. There is yet another phab task (actually a whole pile of them) where we are trying to figure out what to do about this.

Le Deluge (talkcontribs)

No worries. As I say, the worst of my itch has now been scratched. I take it that we'll see some speed improvements once Quarry is on the new servers? The query that started working again a few months ago has been timing out for the last six weeks or so, I assumed that was a combination of the current work and kids being on holiday.

BDavis (WMF) (talkcontribs)

We do hope that the new servers will be faster. We also hope to be able to allow longer running queries to the wikireplica-analytics.eqiad.wmnet service name. That's the one that Quarry will be pointed at. The other service name is intended for tools which need quick responses.

Le Deluge (talkcontribs)

Any idea yet when Quarry moves to the new server?

BDavis (WMF) (talkcontribs)

phab:T173511 is the main blocker for converting Quarry to the new servers. The datasets_p data is currently only available on the old database servers.