Jump to content

Portal:Data Services/Admin/Runbooks/Deploy wiki replicas view change

From Wikitech
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

This runbook details how to change the Wiki Replicas views.

Review process

TODO document this

Deploying

This section details how to actually deploy a change.

  1. Confirm with DBAs that they don't have work in progress that might interfere
  2. Merge associated Gerrit change
  3. Run the update-views cookbook:
    you@cumin$ sudo cookbook sre.wikireplicas.update-views -t PHABRICATOR_TASK [--database DB_NAME] [--table TABLE_NAME]
Always use --table or --database when possible, because without a filter the cookbook takes considerably longer to complete, as it has go to through thousands of view definitions.
Old, manual way
  1. On each replica server:
    1. Starting from clouddb1021 is usually a good idea
    2. Run Puppet
    3. Check that it works fine on a single database:sudo maintain-views --table <affected table> --databases <a single database present on that host> --auto-depool
    4. If that's fine, do it on all the databases: sudo maintain-views --table <affected table> --all-databases --replace-all --auto-depool

Support contacts

If you are following this, you are probably already a part of the WMCS or Data Platform SRE team. Perhaps you can ask the team you are not on if you need more help?

Retrieved from "https://wikitech.wikimedia.org/w/index.php?title=Portal:Data_Services/Admin/Runbooks/Deploy_wiki_replicas_view_change&oldid=2230505"