[PG16][Phase 1] Split the Leader/Write switchover into a distinct playbook
Summary
Currently our Upgrade Switchover playbook consist of several steps, at each step, we ask the human to confirm the execution (y/N).
Sometimes we wanted to start the script from "Step 3: Switch write traffic to the new Patroni cluster leader", as previous steps were performed hours before. Also, Ansible's default idempotency might not be achievable for all commands.
Another issue is that we can accidentally hit "Y" when the actual answer should be "N", or vice versa.
PG14 improvement Reference: #24418 (comment 1557941752)
DRIs
- DBRE contact for this request: @rhenchen.gitlab
- SRE contact for this request: TBD
- QA contact for this request:
- Backend Engineer contact for this request:
- Manager contact for this request:
SRE Support Needed
- Help with the Ansible automation
Desired Outcome/Acceptance Criteria
- The Step 3 - Leader/Write switchover should be in a separated playbook
- Prompt for answer should expect more complex values than Y/N (less error prone)
Edited by Rafael Henchen