As part of the new wiki creation process and as per our instructions, please be advised:
- Project: Wikipedia.
- Type: Public wiki.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | • Ladsgroup | T238104 Create Guianan Creole Wikipedia | |||
| Resolved | • JHedden | T238114 Prepare and check storage layer for gcrwiki |
Event Timeline
Comment Actions
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
Comment Actions
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'
Comment Actions
Mentioned in SAL (#wikimedia-cloud) [2019-11-21T15:48:06Z] <jeh> creating replica indexes and views for gcrwiki T238114
Comment Actions
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