The work on this is completed across the replicas. We’ve created a wikitech page to describe the change further and help share solutions to problems caused by the changes https://wikitech.wikimedia.org/wiki/News/Actor_storage_changes_on_the_Wiki_Replicas <https://wikitech.wikimedia.org/wiki/News/Actor_storage_changes_on_the_Wiki_Replicas>
I’m hoping to collect more useful information and tips there as we go. Brooke Storm Operations Engineer Wikimedia Cloud Services bst...@wikimedia.org <mailto:bst...@wikimedia.org> IRC: bstorm_ > On Jun 3, 2019, at 8:27 AM, Brooke Storm <bst...@wikimedia.org> wrote: > > Work on this is beginning. > > Brooke Storm > Operations Engineer > Wikimedia Cloud Services > bst...@wikimedia.org <mailto:bst...@wikimedia.org> > IRC: bstorm_ > >> On May 20, 2019, at 12:38 PM, Brooke Storm <bst...@wikimedia.org >> <mailto:bst...@wikimedia.org>> wrote: >> >> I’d like to announce that after taking considerable user feedback about it, >> and fixing a performance issue regarding the revision_userindex table at >> https://phabricator.wikimedia.org/T221339 >> <https://phabricator.wikimedia.org/T221339> that affects migration of tools >> to the new schema, that we are extending the date to Monday, June 3rd >> instead to begin dropping the fields in the views. This should give >> additional time to fix things up as well as find issues in existing views if >> any more arise. >> >> Brooke Storm >> Operations Engineer >> Wikimedia Cloud Services >> bst...@wikimedia.org <mailto:bst...@wikimedia.org> >> IRC: bstorm_ >> >>> On May 17, 2019, at 4:27 PM, Brooke Storm <bst...@wikimedia.org >>> <mailto:bst...@wikimedia.org>> wrote: >>> >>> Similar to the earlier removal of text fields from the wiki replicas for >>> comment storage refactors in Mediawiki, we are going to remove “user text” >>> columns from the views that are deprecated in the Mediawiki schema to >>> prepare for when they will actually be removed upstream. The column drops >>> are tracked and explained here https://phabricator.wikimedia.org/T223406 >>> <https://phabricator.wikimedia.org/T223406>. The tables with names such as >>> <tablename>_compat will not see a difference in structure. The change is >>> scheduled for Monday, May 27th. >>> >>> The fields that are dropping from the views are: >>> revision: rev_user and rev_user_text. >>> archive: ar_user and ar_user_text. >>> ipblocks: ipb_by and ipb_by_text. >>> image: img_user and img_user_text. >>> oldimage: oi_user and oi_user_text. >>> filearchive: fa_user and fa_user_text. >>> recentchanges: rc_user and rc_user_text. >>> logging: log_user and log_user_text. >>> Ideally, tools that connect to the replicas should gather the information >>> from the appropriate entries in the actor table instead, again, this is >>> similar to the change for the comment table. The data is already there for >>> you to start using. The alternative is to try using the related >>> <tablename>_compat table, which won’t be changing in a user-visible way at >>> this time. >>> >>> >>> Brooke Storm >>> Operations Engineer >>> Wikimedia Cloud Services >>> bst...@wikimedia.org <mailto:bst...@wikimedia.org> >>> IRC: bstorm_ >>> >> >
_______________________________________________ Wikimedia Cloud Services announce mailing list cloud-annou...@lists.wikimedia.org (formerly labs-annou...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud-announce
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
