Page MenuHomePhabricator

Rename database 'labswiki' to 'wikitechwiki'
Open, Stalled, LowestPublic

Description

Not super high priority and certainly can wait, but something that should be eventually done as there's Labs no more.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 25 2017, 9:39 AM
MarcoAurelio triaged this task as Lowest priority.Jul 25 2017, 9:39 AM

I guess you are aware that rename a database isn't something supported on MySQL/MariaDB at the moment.
While you can rename a table, a database rename isn't supported yet.

MarcoAurelio changed the task status from Open to Stalled.Jul 25 2017, 9:57 AM

Forgot to set it to stalled. Yes, I was not given the exact reason, but I was told that it was not currently possible. Still this is a valid task that while it can take some time to be acomplished it should be done when it is technically possible. Thanks.

There are ways to rename a database, but not using a mysql native command, but exporting and importing into a new database with the correct name etc. It requires downtime, testing and all that.

Doesn't look urgent enough to me to duplicate labswiki and paste it to a new wikitech DB, etc. However I leave that decision to the cloud-services-team. It was also suggested to make Wikitech a SUL wiki (T161859) so maybe iff that goes forward, the DB rename could happen before. As I've said, this is for cloud-services to decide what's best :)

bd808 added a comment.Jul 25 2017, 3:10 PM

I suppose it could happen as part of moving the database tables from hosting on silver.wikimedia.org to hosting in the s3 cluster (T167973: Move wikitech and labstestwiki to s5), but honestly this is not something that I would find incredibly useful. The current dbname can be confusing when making configuration patches, but beyond that it really has no impact on Cloud Services.

neither on DBAs :-)

Surely it'd be wikitechwiki anyway :p

Harej awarded a token.Jun 20 2018, 4:01 AM
Krinkle renamed this task from Rename database labswiki to wikitech to Rename database 'labswiki' to 'wikitechwiki'.May 29 2019, 9:18 PM