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 maintain-views cookbook:
    you@cumin$ sudo cookbook sre.wikireplicas.update-views -t $PHABRICATOR_TASK --filter="--table $TABLE_NAME"
Old, manual way
The following content has been placed in a collapsed box for improved usability.
  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
The above content has been placed in a collapsed box for improved usability.

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?

Related information

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