Page MenuHomePhabricator

Prepare and check storage layer for szywiki
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 5, 11:21 AM
jcrespo added subscribers: Marostegui, jcrespo.

Thanks for the heads up, as a public wiki it has no blockers on us, we will just require as ping as soon as the database is deployed into production for labs sanitization. CC @Marostegui

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

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 szywiki_p -e "show grants for labsdbuser" | grep szywiki ; done
labsdb1009
GRANT SELECT, SHOW VIEW ON `szywiki\\_p`.* TO 'labsdbuser'
labsdb1010
GRANT SELECT, SHOW VIEW ON `szywiki\\_p`.* TO 'labsdbuser'
labsdb1011
GRANT SELECT, SHOW VIEW ON `szywiki\\_p`.* TO 'labsdbuser'
labsdb1012
GRANT SELECT, SHOW VIEW ON `szywiki\\_p`.* TO 'labsdbuser'
JHedden closed this task as Resolved.Thu, Nov 21, 4:00 PM
JHedden claimed this task.
Updates on labsdb10{09,10,11,12}
$ sudo /usr/local/sbin/maintain-replica-indexes --database szywiki --debug
$ sudo /usr/local/sbin/maintain-views --databases szywiki --debug
$ sudo /usr/local/sbin/maintain-meta_p --databases szywiki 

Mentioned in SAL (#wikimedia-cloud) [2019-11-21T16:07:53Z] <jeh> created replica indexes and views for szywiki T237373