[Cloud] Let's discuss Growing the MediaWiki Technical Community (Dev Summit)

2018-01-18 Thread Matthew Flaschen
At the Dev Summit, Birgit Müller and I will run a session on Growing the MediaWiki Technical Community. If you're attending, we hope you will consider joining us. Everyone (attending the Dev Summit or not) is welcome and encouraged to participate at https://phabricator.wikimedia.org/T183318 (

Re: [Cloud] Emulate cross-wiki joins

2018-01-18 Thread Brad Jorsch (Anomie)
On Thu, Jan 18, 2018 at 12:28 PM, YiFei wrote: > when it works at least //in the foreseeable future//. (Yes, changing is a > possibility but it’s not currently foreseeable whether or when it will > happen.) > Not being able to create user tables on the replicas wasn't foreseeable. It was possibl

Re: [Cloud] Emulate cross-wiki joins

2018-01-18 Thread YiFei
Yeah, when it's "the only way you can get the results", you may have no option but to use it. "This should not be done" is just a //should//, and applies only if you have another better option. Here, you don't. When someone asks how, don't answer how not; it will not solve the problem. A solution

Re: [Cloud] Emulate cross-wiki joins

2018-01-18 Thread Daniel Schwen
A lot of things were not really foreseeable, like not being able to create user tables on replica servers. This killed projects. You better heed the comment of "this should not be done". Otherwise you'll end up in the same spot as me. It was unforeseeable that that ability would be taken away, many

Re: [Cloud] Emulate cross-wiki joins

2018-01-18 Thread YiFei
Well, you are free to suggest a better advice. In the case of shards splitting into different servers, Quarry will have to implement a server / database selector [1], and processing data from two databases in a single query may not be possible at all, like currently in the case of tools-db and repl

Re: [Cloud] Emulate cross-wiki joins

2018-01-18 Thread Brad Jorsch (Anomie)
On Wed, Jan 17, 2018 at 5:50 PM, YiFei wrote: > 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. > This is bad advice. Just last week[1] one of our DB