Page MenuHomePhabricator

Prepare and check storage layer for ge.wikimedia.org
Closed, ResolvedPublic

Description

Please take note that a new fishbowl wiki has been requested:

  • domain: ge.wikimedia.org
  • dbname: gewikimedia
  • type: fishbowl (public wiki, but write access restricted).

Thank you.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptThu, Oct 24, 4:17 PM
colewhite triaged this task as Normal priority.Thu, Oct 24, 11:12 PM
MarcoAurelio renamed this task from Prepare and check storage layer for ka.wikimedia.org to Prepare and check storage layer for ge.wikimedia.org.Fri, Oct 25, 8:49 AM
MarcoAurelio updated the task description. (Show Details)

Note: domain name changed from kawikimedia to gewikimedia.

Thanks, being public we DBAs are not a blocker, and we just need a heads up when it is finally deployed to the database.

jcrespo moved this task from Triage to Backlog on the DBA board.Fri, Oct 25, 12:17 PM
jcrespo moved this task from Backlog to Blocked external/Not db team on the DBA board.

Hi there. Wiki database just created. Regards.

Mentioned in SAL (#wikimedia-operations) [2019-11-21T06:32:37Z] <marostegui> Sanitize shywiktionary gcrwiki szywiki minwiktionary gewikimedia on db1124:3313 T238115 T238114 T237373 T238522 T236404

Marostegui removed Marostegui as the assignee of this task.Thu, Nov 21, 6:49 AM
Marostegui moved this task from Blocked external/Not db team to Done on the DBA board.
Marostegui added subscribers: Andrew, Bstorm, JHedden, Marostegui.

Database sanitized, _p database created and grants done - cloud-services-team please proceed with the views on the 4 hosts.

root@cumin1001:/home/marostegui# for i in labsdb1009 labsdb1010 labsdb1011 labsdb1012; do echo $i ; mysql.py -h$i gewikimedia_p -e "show grants for labsdbuser" | grep gewikimedia ; done
labsdb1009
GRANT SELECT, SHOW VIEW ON `gewikimedia\\_p`.* TO 'labsdbuser'
labsdb1010
GRANT SELECT, SHOW VIEW ON `gewikimedia\\_p`.* TO 'labsdbuser'
labsdb1011
GRANT SELECT, SHOW VIEW ON `gewikimedia\\_p`.* TO 'labsdbuser'
labsdb1012
GRANT SELECT, SHOW VIEW ON `gewikimedia\\_p`.* TO 'labsdbuser'

Mentioned in SAL (#wikimedia-cloud) [2019-11-21T15:36:49Z] <jeh> creating replica indexes and views for gewikimedia T236404

JHedden closed this task as Resolved.Thu, Nov 21, 3:54 PM
JHedden claimed this task.
Updates on labsdb10{09,10,11,12}
$ sudo /usr/local/sbin/maintain-replica-indexes --database gewikimedia --debug
$ sudo /usr/local/sbin/maintain-views --databases gewikimedia --debug
$ sudo /usr/local/sbin/maintain-meta_p --databases gewikimedia