On 08.06.2012 17:32, Jeroen De Dauw wrote:
They are described here: https://www.mediawiki.org/wiki/User:Jeroen_De_Dauw/Wikibase_sites_and_site_l...
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