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.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Urbanecm | T236389 Create a wiki for Wikimedia Community User Group Georgia | |||
| Resolved | • JHedden | T236404 Prepare and check storage layer for ge.wikimedia.org |
Event Timeline
Comment Actions
Thanks, being public we DBAs are not a blocker, and we just need a heads up when it is finally deployed to the database.
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 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'
Comment Actions
Mentioned in SAL (#wikimedia-cloud) [2019-11-21T15:36:49Z] <jeh> creating replica indexes and views for gewikimedia T236404
Comment Actions
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