Page MenuHomePhabricator

Prepare and check storage layer for gcrwiki
Closed, ResolvedPublic

Description

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

  • Project: Wikipedia.
  • Type: Public wiki.

Event Timeline

jhsoby created this task.Tue, Nov 12, 4:58 PM
Marostegui added a subscriber: Marostegui.

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.Fri, Nov 15, 2:45 PM

The wiki has been created

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 removed Marostegui as the assignee of this task.Thu, Nov 21, 6:54 AM
Marostegui moved this task from Blocked external/Not db team to Done on the DBA board.
Marostegui added subscribers: Andrew, Bstorm.

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

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

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