Hi!
The speed bumps from the eventlogging migration are almost ironed out:
1. db1048 has had the eventlogging uuid fields made formally UNIQUE KEY. I gather Ori will now run some validation against logs to check for remaining gaps.
2. db1046 which died mid-migration has been restored and is catching up. This doesn't really affect Analytics except that it's to be part of db1047's replication chain for eventlogging.
3. db1047 is finishing up reloading log data and removing the CONNECT federated tables involved in bug 64445[1].
As something of a consolation prize, "analytics-store.eqiad.wmnet" is now open for SELECT queries from the 'research' user. This box:
- Is a CNAME for dbstore1002.eqaid.wmnet.
- Replicates all wikis in one place.
- Can be hammered. Please feel free.
- Can have scratch space for temporary writes (but doesn't yet).
- Can replicate eventlogging too (but doesn't yet).
I would appreciate if anyone has some suitable read-only reports to try out, please do so and report back.
BR Sean
[1] https://bugzilla.wikimedia.org/show_bug.cgi?id=64445