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 in place and changing the DNS' TTL, which is 5M:
```
m2-master 5M IN CNAME dbproxy1007.eqiad.wmnet.
```
Maybe we can decrease the TTL to 1M a few hours before the failover and then put it back to 5M a few hours after.
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** ?