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
|

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