Re: [Cloud] Emulate cross-wiki joins

2018-01-17 Thread YiFei
SELECT ... FROM ``.``, like in https://quarry.wmflabs.org/query/24212. This should work in the foreseeable future, during which all the replica databases are accessible on the same server. Zhuyifei1999 2018-01-17 14:11 GMT-06:00 Federico Leva (Nemo) : > I usually use bash or python scrips to que

Re: [Cloud] Brief Wikitech and Horizon outage upcoming -- DONE

2018-01-17 Thread Andrew Bogott
On 1/17/18 2:19 PM, Andrew Bogott wrote: As part of a security upgrade, I'll be rebooting the systems that host Wikitech and Horizon in about two hours, at 14:00 PST (16:00 CST). These reboots are done and everything is back up.  Sorry for any inconvenience caused! -Andrew Those websites w

[Cloud] Brief Wikitech and Horizon outage upcoming

2018-01-17 Thread Andrew Bogott
As part of a security upgrade, I'll be rebooting the systems that host Wikitech and Horizon in about two hours, at 14:00 PST (16:00 CST). Those websites will be briefly unavailable, as will be the Nova api.  This last will cause a brief interruption to the WMF Continuous Integration system.  T

[Cloud] Emulate cross-wiki joins

2018-01-17 Thread Federico Leva (Nemo)
I usually use bash or python scrips to query data from multiple wikis at once, but I wanted something "simple" in Quarry such as a list of users who are active in two wikis, and I felt very stupid. I ended up using two separate queries, a subquery and a mix of GROUP_CONCAT, TO_BASE64 and SET S

[Cloud] [Cloud-announce] Meltdown reboots and maintenance continued

2018-01-17 Thread Chase Pettet
We have completed all of the updates and reboots for the hypervisors and instances in https://phabricator.wikimedia.org/T184910, but there are more maintenance events that are less invasive to come. This is being tracked in https://phabricator.wikimedia.org/T184910 Most of this will be handled gr