Page MenuHomePhabricator

Prepare and check storage layer for
Closed, ResolvedPublic


Please note that a new wiki has been requested. The wiki is going to be public but edition will be restricted (what we call a fishbowl). Thanks.

Event Timeline

Marostegui triaged this task as Medium priority.Feb 24 2020, 8:12 AM
Marostegui moved this task from Triage to Blocked external/Not db team on the DBA board.
Marostegui subscribed.

Let us know when the database is created so we can sanitize it.

@Urbanecm I saw you created the database, next time please ping us on this sort of ticket "Prepare and check storage layer" so we can go ahead and sanitize the database. We got some alerts about unsanitized data for this database. There is no data leak or anything as there are no views assigned to the tables, but still...

I am going to go ahead and sanitize them now.

No problem! Can you check my comment at: T245911#6051001
Thank you!

Marostegui added subscribers: Bstorm, JHedden, bd808.

cloud-services-team this is ready for the views creation on labsdb1009, 1010, 1011 and 1012.
I have run this: set session sql_log_bin=0; create database grwikimedia_p; GRANT SELECT, SHOW VIEW ON grwikimedia\_p`.* TO 'labsdbuser';` so the maintainviews script should run fine.

Thank you

Mentioned in SAL (#wikimedia-cloud) [2020-04-15T18:44:36Z] <jeh> create indexes and views for grwikimedia T245912

Updates on labsdb10{09,10,11,12}
$ sudo /usr/local/sbin/maintain-replica-indexes --database grwikimedia --debug
$ sudo /usr/local/sbin/maintain-views --databases grwikimedia --debug
$ sudo /usr/local/sbin/maintain-meta_p --databases grwikimedia 
Updates on cloudcontrol1003
$ /usr/local/sbin/wmcs-wikireplica-dns --aliases
WARNING:mwopenstackclients.DnsManager:Creating grwikimedia.web.db.svc.eqiad.wmflabs.
Testing from Toolforge
MariaDB [grwikimedia_p]> select * from page limit 1\G
*************************** 1. row ***************************
           page_id: 1
    page_namespace: 0
        page_title: Αρχική_σελίδα
  page_is_redirect: 0
       page_is_new: 1
       page_random: 0.502073964967
      page_touched: 20200406124029
page_links_updated: 20200406124029
       page_latest: 1
          page_len: 1356
page_content_model: wikitext
         page_lang: NULL
1 row in set (0.01 sec)