We need to replace the current primary database master for Commonswiki.
This host is old and out of warranty, so needs to be decommissioned.
We would need a 15 minutes read-only window for Commonswiki.
Date: Tue 26th January
Time: 07:00AM UTC - 07:15 AM UTC (if everything goes as planned we would not use the 15 minutes window)
Impact: Commonswiki will go read-only. No edits/uploads will be allowed. Reads will not be impacted.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Restricted Task | |||||
| Resolved | Legoktm | T281515 June 2021 Datacenter switchover | |||
| Resolved | Marostegui | T285139 DB maintenance work to do while eqiad is passive (June 2021) | |||
| Resolved | Marostegui | T266483 Enable report_host for mariadb | |||
| Resolved | • Kormat | T271106 Enable report_host on candidate masters | |||
| Unknown Object (Task) | |||||
| Resolved | Marostegui | T258361 Productionize db1155-db1175 and refresh and decommission db1074-db1095 (22 servers) | |||
| Declined | None | T258386 db1080-95 batch possibly suffering BBU issues | |||
| Resolved | Marostegui | T271427 Switchover s4 (commonswiki) from db1081 to db1138 | |||
| Resolved | Trizek-WMF | T271791 Database primary master failover on s4 (commonswiki) |
I included it in the two next issues of Tech News.
I'm going to inform the community soon, on VIllage Pumps and using the Watchlist notice.
A banner will be setup as usual, visible 30 minutes before the start time on Commons.
Message sent to the VP and posted on the Watchlist notice. I will setup the banner next week.
This was done successfully
read only on: 07:00:37
read only off: 07:01:52
total read only time: 1:15 minutes
Thanks everyone for your help!
total read only time: 1:15 minutes
Well that went a lot quicker than I expected based on the orginal task
The reserved maintenance window is intentionally longer in case there are any problems.