On 28/11/11 08:29, Brion Vibber wrote:
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