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

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.

Hopefully this will be more automated soon: phab:T297026

1. Confirm with DBAs that they don't have work in progress that might interfere
2. Merge associated Gerrit change, and force Puppet runs on all replica servers
3. On each replica server:
   1. Starting from clouddb1021 is usually a good idea
   2. First 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
   3. 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 Engineering SRE team. Perhaps you can ask the team you are not on if you need more help?

Related information

• Portal:Data Services/Admin/Wiki Replicas