db1065 is currently m2 master.
It is very old, out of warranty and needs to be decommissioned {T217396} 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'
```