[Bug 27002] Completely de-couple the DB name
https://bugzilla.wikimedia.org/show_bug.cgi?id=27002 Board of Trustees changed: What|Removed |Added CC||br...@wikimedia.org, ||remote_bo...@hotmail.com --- Comment #3 from Board of Trustees 2011-11-25 06:47:24 UTC --- Board of Trustees changes. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27002] Completely de-couple the DB name
https://bugzilla.wikimedia.org/show_bug.cgi?id=27002 Krinkle changed: What|Removed |Added CC||krinklem...@gmail.com --- Comment #2 from Krinkle 2011-01-28 10:25:12 UTC --- This sounds a lot like Toolserver's wiki database. Which is one of the reasons cross-wiki tools are relatively easy to make there. A wikified dump of that MySQL table can be seen here: https://wiki.toolserver.org/view/Wiki_server_assignments -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27002] Completely de-couple the DB name
https://bugzilla.wikimedia.org/show_bug.cgi?id=27002
--- Comment #1 from Brion Vibber 2011-01-28 01:02:40 UTC ---
For comparison, here's how we do it in StatusNet:
* Each site has a 'nickname' used as an internal identifier, which never
changes. This is used in multi-site data structures such as job queues.
* Local configuration, or a 'status_network' table for multi-site farms, can
provide additional mapping between nickname, database hostname & database name,
and domain name or URL path
* domain names or URL paths are used as the primary user- and admin-visible
identifier for choosing which site to work with (via vhost on web or
-sidenti.ca parameter on command-line scripts)
So to handle the Wikimedia-style cases, a central site mapping table might list
for each row at *minimum*:
* database name ("enwiki")
* site family ("wiki"/"wikipedia")
* language/section subkey ("en")
* hostname ("en.wikipedia.org")
If we're actually using a mapping table instead of trying to manually break
apart or build up from prefix/suffixes all the time, that might actually be
plenty.
That would allow continuing to use the dbname as an internal key, while
allowing language codes or domains to be altered.
However, in places where we expose db names (such as cross-wiki user
management), we should consider displaying and selecting from canonical
hostnames ('en.wikipedia.org') or language+family ('en.wikipedia') as a
UI-friendly form, so that things that look like they don't match are no longer
an issue.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27002] Completely de-couple the DB name
https://bugzilla.wikimedia.org/show_bug.cgi?id=27002 Mark A. Hershberger changed: What|Removed |Added Blocks||26994 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
