db1065 is currently m2 master.
It is very old, out of warranty and needs to be decommissioned T217396: Decommission db1061-db1073 it also has 3 disks on predictive failure.
I would like to fail it over to db1132 so we can finally get rid of it.
These are the databases on this host:
root@cumin1001:~# mysql.py -hdb1065 -e "show databases" +--------------------+ | Database | +--------------------+ | debmonitor | | heartbeat | | iegreview | | information_schema | | mysql | | otrs | | performance_schema | | recommendationapi | | reviewdb | | scholarships | +--------------------+
The active ones appear to be:
debmonitor otrs recommendationapi
The other databases appear to be unused (there have been no writes for more than a year).
The failover should be easy as it is a matter of reloading the haproxies with the new master.
The impact is that the master will be on read-only for around 1 minute. Reads should remain unaffected.
Any objection to do this failover 9th July at around 06:00UTC ?
Operations after the switch T226952#5295258:
For debmonitor it connects to m2-master.eqiad.wmnet and I'm not sure if Django's connection pooling would be smart enough to reconnect given that the old one will still work, just RO. It might need a: sudo cumin 'A:debmonitor' 'systemctl restart uwsgi-debmonitor.service'