On 08.06.2012 17:32, Jeroen De Dauw wrote:
I like your proposal in principle, but I'm a bit worried about just dropping a
well established table on the production cluster.
When migrating from the interwiki table to the sites table, there should be a
way to keep the interwiki table for B/C, and also keep it updated and in sync
with the new sites table.
The simplest way would be, I think, to have a maintenance script that can be run
to replace the interwiki table with a view on the sites table. This way, we
would maintain the old interface and just point it to the new data. This way,
obscure maintenance scripts, shell hack, toolserver tools etc will continue
working as before.
This will only work on databases that supports views, but mysql > 5.0 does, and
this level of B/C is probably only relevant to the wikimedia cluster (and maybe
wikia). So we don't care too much if it (the b/c view) doesn't work with SQLite,
etc.
-- daniel