Change Details

The high-level checklist: [X] 0. Set the configuration flag to "old" (see T166732) (not needed, default is now "old") [X] 1. Merge the first patch for {T166732} (adding new schemas and code) [X] 2. Perform schema change (T174569) [X] 3. Turn the feature flag to "read+write both". See if stuff breaks. [X] 3.1. Announce the pending change to wikitech-l@ and cloud@, and give time for people to update. [X] 3.2. Make sure all deployed extensions are updated. [X] 4. Turn the feature flag to "write new only, read both". See if stuff breaks. [X] 5. Run the maintenance script(s) to migrate all the old stuff to new stuff, blanking the old stuff in the process. [X] 6. Turn the feature flag to "new only". [X] Default and CI [X] Beta Cluster [X] Group 0 [X] Group 1 [X] Group 2 [ ] 7. Merge the second patch for T166732 (removing old schemas and code) [ ] 7.1. Submit schema change (task TBD) We can easily do steps 2–6 for individual wikis rather than rolling it out all at once. I'm filing this task now mainly so that possibility can be discussed: do we want to do that, and if so decide which wikis to do preliminary deploys to.

The high-level checklist: [X] 0. Set the configuration flag to "old" (see T166732) (not needed, default is now "old") [X] 1. Merge the first patch for {T166732} (adding new schemas and code) [X] 2. Perform schema change (T174569) [X] 3. Turn the feature flag to "read+write both". See if stuff breaks. [X] 3.1. Announce the pending change to wikitech-l@ and cloud@, and give time for people to update. [X] 3.2. Make sure all deployed extensions are updated. [X] 4. Turn the feature flag to "write new only, read both". See if stuff breaks. [X] 5. Run the maintenance script(s) to migrate all the old stuff to new stuff, blanking the old stuff in the process. [X] 6. Turn the feature flag to "new only". [X] Default and CI [X] Beta Cluster [X] Group 0 [X] Group 1 [X] Group 2 [ ] 7. Remove old schemas and code [ ] 7.1. Update WMCS replicas to no longer reference old schemas. [ ] 7.2. Write and merge patches to remove `$wgCommentTableSchemaMigrationStage`, supporting code, and old schemas. [ ] 7.3. Submit #schema-change task for WMF production.

The high-level checklist: [X] 0. Set the configuration flag to "old" (see T166732) (not needed, default is now "old") [X] 1. Merge the first patch for {T166732} (adding new schemas and code) [X] 2. Perform schema change (T174569) [X] 3. Turn the feature flag to "read+write both". See if stuff breaks. [X] 3.1. Announce the pending change to wikitech-l@ and cloud@, and give time for people to update. [X] 3.2. Make sure all deployed extensions are updated. [X] 4. Turn the feature flag to "write new only, read both". See if stuff breaks. [X] 5. Run the maintenance script(s) to migrate all the old stuff to new stuff, blanking the old stuff in the process. [X] 6. Turn the feature flag to "new only". [X] Default and CI [X] Beta Cluster [X] Group 0 [X] Group 1 [X] Group 2 [ ] 7. Merge the second patch for T166732 (rRemovinge old schemas and code) [ ] 7.1. Submit schema change (task TBD) We can easily do steps 2–6 for individual wikis rather than rolling it out all at once.Update WMCS replicas to no longer reference old schemas. [ ] 7.2. Write and merge patches to remove `$wgCommentTableSchemaMigrationStage`, supporting code, and old schemas. I'm filing this task now mainly so that possibility can be discussed: do we want to do that,[ ] 7.3. and if so decide which wikis to do preliminary deploys toSubmit #schema-change task for WMF production.