Page MenuHomePhabricator

Prepare and check storage layer for shywiktionary
Closed, ResolvedPublic

Description

As part of the new wiki creation process and as per our instructions, please be advised:

  • Project: Wiktionary.
  • Type: Public wiki.

Event Timeline

Marostegui subscribed.

Please let us know when the database is created so we can sanitize it on labs, before sending it to the cloud team for the views creation

Dzahn triaged this task as Medium priority.Nov 15 2019, 2:45 PM

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

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 moved this task from Blocked external/Not db team to Done on the DBA board.
Marostegui added subscribers: Bstorm, Andrew.

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 shywiktionary_p -e "show grants for labsdbuser" | grep shywiktionary ; done
labsdb1009
GRANT SELECT, SHOW VIEW ON `shywiktionary\\_p`.* TO 'labsdbuser'
labsdb1010
GRANT SELECT, SHOW VIEW ON `shywiktionary\\_p`.* TO 'labsdbuser'
labsdb1011
GRANT SELECT, SHOW VIEW ON `shywiktionary\\_p`.* TO 'labsdbuser'
labsdb1012
GRANT SELECT, SHOW VIEW ON `shywiktionary\\_p`.* TO 'labsdbuser'

Mentioned in SAL (#wikimedia-cloud) [2019-11-21T15:48:51Z] <jeh> creating replica indexes and views for shywiktionary T238115

JHedden claimed this task.
Updates on labsdb10{09,10,11,12}
$ sudo /usr/local/sbin/maintain-replica-indexes --database shywiktionary --debug
$ sudo /usr/local/sbin/maintain-views --databases shywiktionary --debug
$ sudo /usr/local/sbin/maintain-meta_p --databases shywiktionary