Jump to content

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

From Wikitech

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"