[Analytics] Enwiki replication lag on s1-analytics-slave.eqiad.wmnet >12 hours

2014-05-02 Thread Christian Aistleitner
Hi, just a quick heads up that the replication lag for the enwiki database on the analytics s1 slave (s1-analytics-slave.eqiad.wmnet, db1047.eqiad.wmnet) is again >12 hours [1]. If you run jobs that rely on current enwiki data, you can temporary switch to using analytics-store.eqiad.wmnet, which

Re: [Analytics] db1047 & one box to rule them all

2014-05-02 Thread Dario Taraborelli
Hi Gilles, you shouldn’t use “research_prod” if you simply need to perform read-only queries against the slaves (the “research” user is the one you should use instead, at least until we revisit the policy of SQL credentials with ops). I’ll drop you a line off-list with instructions on the crede

Re: [Analytics] db1047 & one box to rule them all

2014-05-02 Thread Gilles Dubuc
Where might I find the credentials of the research user? I only have research_prod's password, which I was using to connect to db1047. That one doesn't seem to work on analytics-store.eqiad.wmnet On Wed, Apr 30, 2014 at 11:48 PM, Ori Livneh wrote: > On Wed, Apr 30, 2014 at 12:58 PM, Ori Livneh