| WMDE-leszek added a comment. |
Thanks @Marostegui for infromation so far.
And yes, @jcrespo is right. We first want to get an OK from you if this is a right way for us to go. I've changed task title slightly. Sorry for not being clear.
So yes, we wouldn't have a code writing/reading to a new column until adding a column is completed.
What we would like to know is if it is possible to add an empty to column to a big table wb_terms without it being noticed by users of wikidata.org.
Adding an empty column seems to be the most simple first step we can do.
Depending on the answer to this, we will plan further steps.
E.g. if we need to first add it on stand-by master, and then update primary master during DC switch over, we can than possibly not only add the column but also populate it? But if we can just add empty column with no "bad" effect on wikidata performance, it would be easier to just add it first.
Thanks for pointing me to https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change. We're going to follow it when we request a schema change "for real".
Cc: jcrespo, Marostegui, Lydia_Pintscher, Aklapper, daniel, WMDE-leszek, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
