Marostegui added a comment.

This is not an easy change as it needs to be done directly on the master, or otherwise ids will not match.
The table is pretty small (23M on disk - 16224 rows) so it can probably be done directly on the master. I would still prefer to go for the approach we took for other similar changes like: change_tag, tag_summary and watchlist tables which is:

  • Do the alter on codfw
  • Wait for the DC failover
  • Reimport the tables on eqiad.

I prefer that approach because:

-It is not an urgent request and failover might be happening on Q4, so not far away from now.

  • I prefer avoid doing such changes (adding auto_inc columns) directly on the master and getting it replicated thru all the replication chain if there is an alternative way.



To: Marostegui
Cc: Marostegui, Ladsgroup, Aklapper, Jonas, thiemowmde, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Agabi10, Luke081515, Wikidata-bugs, Mbch331, Krenair
Wikidata-bugs mailing list

Reply via email to