[Labs-l] Metainformation table now on replica servers.
Marc A. Pelletier
marc at uberbox.org
Tue Aug 27 20:39:31 UTC 2013
Hey all,
In what is most likely the most requested feature for labs replication
yet, I've added a table with automatically maintained meta information
about the replicated databases: meta_p.wiki (which is available on every
shard).
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| dbname | varchar(32) | NO | PRI | NULL | |
| lang | varchar(12) | NO | | en | |
| name | text | YES | | NULL | |
| family | text | YES | | NULL | |
| url | text | YES | | NULL | |
| size | decimal(1,0) | NO | | 1 | |
| slice | text | NO | | NULL | |
| is_closed | decimal(1,0) | NO | | 0 | |
| has_echo | decimal(1,0) | NO | | 0 | |
| has_flaggedrevs | decimal(1,0) | NO | | 0 | |
| has_visualeditor | decimal(1,0) | NO | | 0 | |
| has_wikidata | decimal(1,0) | NO | | 0 | |
+------------------+--------------+------+-----+---------+-------+
There is a lingering issue with the 'name' column which seems to
improperly encode the Wiki name when non-ascii characters are involved;
that will get fix once I manage to beat some sense into mysql.
Most columns are self-explanatory, and I can add a few more depending on
demand. In the meantime, (dbname, slice) provides the much requested
mapping between databases and slices.
-- Marc
More information about the Labs-l
mailing list