Alter tables for the log database on the analytics slaves

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Alter tables for the log database on the analytics slaves

Luca Toscano
Hi everybody,

the Analytics team is working on some alter tables to the Eventlogging
'log' database on analytics-store (dbstore1002) and analytics-slave
(db1047) as part of https://phabricator.wikimedia.org/T167162.

The list of alter tables are the following:
https://phabricator.wikimedia.org/P5570

This should be a transparent change but I thought it would have been better
to keep all of you informed in case of unintended regressions or
side-effects. The context of the alter tables is in T167162 but the TL;DR
is that we need nullable attributes across all the EL tables (except fields
like id, uuid and timestamp) to be able to sanitize data with our new
eventlogging_cleaner script (https://phabricator.wikimedia.org/T156933).

Please let me know if you encounter any issue with this change.

Thanks in advance!

Luca
_______________________________________________
Wiki-research-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/wiki-research-l
Loading...