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)
- Run failover script (this takes around 3 seconds and will set mysql on read-only before switching the master)
- 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