After a chat with @jcrespo we decided to point the x1-analytics-slave domain to dbstore1002 (analytics-slave) - https://gerrit.wikimedia.org/r/#/c/378211

db1029 is a production host and it would be better not to expose it to research queries, so we have also removed the research user from there. From what we know dbstore1002 should be enough but please let us know if any replication that you need is missing.

Thanks for the report!

@elukey Thanks! I can access
I need an access to echo_ tables and I do not see them replicated there (or the acccess is not allowed?).

@Etonkovidova Can you provide more information about how you plan to use that data? It was not initially included on analytics data because it was both more difficult technologically and not needed at the time. If you need a one-time access, I can provide you access to a host temporarilly quickly. If it is an ongoing project (long term), I will import those tables into dbstore1002, which may take a few days.

@jcrespo Echo notifications is a project that Global Collaboration team is responsible for (I am a QA for that team). From time to time, following users' complaints or requests, or our own testing we need to verify that notifications were, in fact, delivered and their type, a sender, and other parameters have been recorded correctly to verify it against what was displayed in UI.

Right now, I was trying to investigate T174873: Ping system failed to notify mention on hi.wikiversity and hiwikivoyage and needed to track down in db whether my testing mentions in hiwikiversity, in fact, were recorded in db or not (and how many).

Also Sir When I use http://tools.wmflabs.org/pageviews and type hi.wikiversity.org in project. It is showing an error. See Below.

hi.wikiversity.org is not a valid project or is currently unsupported.

@Jayprakash12345 Unless I am wrong, that is a different issue, nor related to the analytics db servers- please file a separate ticket so @Analytics ops can have a look at it (it is probably not related to mysql).

@Etonkovidova I will try to setup something quickly and then import the echo tables and other missing pieces ASAP. Please give me some days to figure it out.

@jcrespo Thank you very much!

In T175970#3696906, @jcrespo wrote:

CC @Marostegui Maybe we can setup an unpuppetized copy of x1 from dbstore2002 on dbstore1002?

Yeah, dbstore1002 now has plenty of space (1.9T available) and x1 is around 250G...

Should we do it on the same instance, is a mysqloader fast enough for x1, do you think?

In T175970#3698713, @jcrespo wrote:

Should we do it on the same instance, is a mysqloader fast enough for x1, do you think?

I would do it on the same instance, otherwise we will need to run very ugly non-puppetized stuff I think.
Keep in mind that myloader/mydumper will need to be run remotely as dbstore1002 is jessie and we have seen what happened to me two days ago with the jessie version. But maybe for such a small amount of data mysqldump will be fast enough?

Change 385334 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Add all x1 tables, including ones on %wik% schemas on dbstores

https://gerrit.wikimedia.org/r/385334

I am reimporting x1 on dbstore1002 (including the echo tables), hopefully, that will work and will not break anything else :-/

Change 385334 merged by Jcrespo:
[operations/puppet@production] mariadb: Add all x1 tables, including ones on %wik% schemas on dbstores

https://gerrit.wikimedia.org/r/385334