| Marostegui added a comment. |
Hi!
The wt_terms table is a quite big table (as you already probably know) it is around 230G on disk. That means the ALTER table will take quite a while.
The good news is that adding a column can be done in-place so we can probably do it without causing delay on the slaves (although we'd depool them). However, we can do also the ALTER on the stand by master in the standby DC and once we have switched over the other DC in April, we can get it done in the primary master too. I do not think we have to set up wikidata in read-only, as long as the code is compatible with the column being added one by one on all the servers and you do not write to it until it is 100% completed.
Normally, it is useful for us, DBAs, if you can follow the template to request an ALTER table, so we can have all the information needed at once, speeding up the process for everyone.
This is it: https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change
Thanks!
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
