Marostegui added a comment. |
In T159718#3076201, @jcrespo wrote:Evaluate if it is feasible to add such an "empty" column without making Wikidata readonly.
we can probably do it
How certain are you? In my experience, the biggest blocker on production is not the size, but how busy the table is. That would create metadata locking issues if it is very SELECT-heavy. The difference between suffering one or the other are hours vs. weeks of deployment (as it happened with the last page table schema). This need deeper examination.
If we depool the slaves we should be fine, shouldn't we? And if we use the DC switchover to alter the masters we'd also get rid of that issue?
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui
Cc: jcrespo, Marostegui, Lydia_Pintscher, Aklapper, daniel, WMDE-leszek, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
Cc: jcrespo, Marostegui, Lydia_Pintscher, Aklapper, daniel, WMDE-leszek, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs