Re: [Analytics] Maintenance on Eventlogging Database - Renaming of tables

Team: We need to do some maintenance work to the evenlogging database that requires renaming and archiving of all tables that are currently receiving events. Tables will be renamed from, for example: WikipediaZeroUsage_14574251 to WikipediaZeroUsage_14574251_15423246; 15423246 is the capsule schema version. As new events are come for 'WikipediaZeroUsage' schema with schema version 14574251 the table WikipediaZeroUsage_14574251 will get recreated again, the only difference is that this new table will have different column length for varchar fields. Details of this change are here: https://phabricator.wiki media.org/T160454 We will start our maintenance event on Thursday morning around 11 am PST time and it would last couple hours, no data loss on eventlogging will happen as part of this event. Reportupdater queries that use eventlogging would need to be updated to select from the newly renamed tables (and we will take care of doing that) but other than those we do not think there are any other automated scripts that would need updating. Please let us know otherwise. Also, please be so kind to let us know if this renaming is disruptive in any way. We can also do this changes at a later time next week. Thanks, Nuria _______________________________________________ Analytics mailing list Analytics(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics