On 28/11/11 08:29, Brion Vibber wrote:
So... this seems to have snuck back in a month ago: https://www.mediawiki.org/wiki/Special:Code/MediaWiki/101021
I don't think it really "snuck", Rob has been talking about it for a while, see e.g. comment 27.
Have we resolved the deployment questions on how to actually do the change? Just want to make sure ops has plenty of warning before 1.19 comes down the pipe. (Especially if we have to revert anything back to 1.18 during/after!)
It can be deployed like any column addition to a large table: on the slaves first, then switch masters, then on the old masters. For 1.17 we changed categorylinks (60M rows on enwiki), and that caused no problems. In 1.18 the schema changes were done by ops (Asher), and included flaggedrevs which is 30M rows on dewiki.
The revision table is 320M rows on enwiki, but it doesn't pose any special challenges, as long as there's enough disk space. The snapshot host db26 is the only host which may possibly be in danger of running out of space, but if its snapshots are deleted and the space reallocated to /a then it won't have any trouble.
Like the previous schema changes, this schema change will be done in advance of the software version change. The old version will work with the new schema, and the default value is harmless, so reverting back to 1.18 or restarting the populate script won't be a problem.
-- Tim Starling