MariaDB/Primary switchover

Prerequisites shared for all MW sections

(The following points apply to planned MW switchovers only, skip directly to section links below when responding to an incident)

• Create a switchover task (see an example task or use the script to auto generate the MW switchover task
• Schedule the switchover for one of the two weekly MW maintenance windows (check other open tasks and the deployment calendar for possible conflicts):
  • Tuesday at 6:00 AM UTC
  • Thursday at 6:00 AM UTC
• Obtain explicit availability confirmation (over any channel) from at least one other person and add them to the task using the "Other assignee" field
• Send a calendar invite to sre-data-persistence@

Switchover helper

There is a switchover helper script at https://gitlab.wikimedia.org/repos/sre/wmfmariadbpy/-/blob/main/wmfdbtools/switchover_helper.py?ref_type=heads being implemented as part of https://phabricator.wikimedia.org/T409926

Which section are you switching over?

• s* (core Wiki section)
• es* (external store section)
• m* (misc section)
• x1 (special section)
• x2 (special section)

This page is a part of the SRE Data Persistence technical documentation
(go here for a list of all our pages)