db1069 is currently x1 master and needs to be failoved over to db1120 (a newer and more powerful host).
db1069 has been suffering intermittent memory issues (T201133) as well as disks being on predictive failure.
This is a very old host that needs decommissioning (T217396) as it has been out of warranty for a long time
x1 cannot be put on read-only on a mediawiki level, so it will need to be done on MySQL itself.
I am tagging #growth-team #language-team #release-engineering-team and #cognate like we did last time.
The expected downtime is around 1 minute.
Apart from `flowdb` database, the tables on the x1 wikis are:
| Tables_in_enwiki |
| aft_feedback |
| echo_email_batch |
| echo_event |
| echo_notification |
| echo_target_page |
The procedure will be:
- Move all the slaves under db1120 (new master)
- Set db1069 in read only on a mysql level
- Run failover script (this takes around 3 seconds)
- Deploy mediawiki config with the new master in place (change will be already merged and will be deployed with --force, so I expect it to take around 30 seconds)
**When: 3rd July at 06:00 AM UTC**
**Impact: Writes will be blocked for around 1 minute, reads WILL NOT be affected**