By default mariadb does not report a hostname when it starts replicating from another server. This means the output of `show slave status` only contains very opaque information:
```
root@pc2007.codfw.wmnet[(none)]> show slave hosts;
+-----------+------+------+-----------+
| Server_id | Host | Port | Master_id |
+-----------+------+------+-----------+
| 171966644 | | 3306 | 180355176 |
| 180367374 | | 3306 | 180355176 |
+-----------+------+------+-----------+
```
If we use puppet to set report_host to the fqdn, then it will show up in the `show slave hosts` table, as well as be available for orchestrator to query.
NOTE: This requires MySQL daemon to be restarted
https://mariadb.com/kb/en/replication-and-binary-log-system-variables/#report_host
Scripts used for rolling this out:
- `run`: https://phabricator.wikimedia.org/P13146
- `check`: https://phabricator.wikimedia.org/P13146#73251
Restarting hosts progress
[] s1
[] eqiad
[x] codfw
[] s2
[] eqiad
[x] codfw
[] s3
[] eqiad
[x] codfw
[] s4
[] eqiad T266483#6772425
[x] codfw
[] s5
[] eqiad
[x] codfw
[] s6
[] eqiad
[x] codfw
[] s7
[] eqiad
[x] codfw
[] s8
[] eqiad
[x] codfw
[] x1
[] eqiad
[x] codfw
[x] x2
[x] eqiad testing host
[x] eqiad backup testing (db1133)
[x] db2102 - codfw backup testing host
[x] dbstore1003, dbstore1004, dbstore1005 (multi-instance)
[x] eqiad backup sources db1095 db1102 db1116 db1139 db1140 db1145 db1150
[x] codfw backup sources db2097 db2098 db2099 db2100 db2101 db2139 db2141
- folded into main section above
[] labsdb1009, labsdb1010, labsdb1011 (no need, will be replaced with the new clouddb hosts)
[] labsdb1012
[x] Sanitarium hosts
[x] db2094/db2095
[x] db1124
[x] s1
[x] s3
[x] s5
[x] s8
[x] db1125
[x] s2
[x] s4
[x] s6
[x] s7
[x] es1
[x] eqiad: T266483#6605480
[x] codfw
[x] es2
[x] eqiad: T266483#6605481
[x] codfw
[x] es3
[x] eqiad: T266483#6605484
[x] codfw
[] es4
[] eqiad: T266483#6743037
[x] codfw
[x] es5
[x] eqiad: T266483#6648234
[x] codfw
[x] pc1
[x] eqiad T266483#6615370
[x] codfw
[x] pc2
[x] eqiad
[x] codfw
[x] pc3
[x] eqiad
[x] codfw
[x] m1
[x] eqiad T266483#6616110
[x] codfw
[] m2
[] eqiad T266483#6616110
[x] codfw
[x] m3
[x] eqiad T266483#6616110
[x] codfw
[] m5
[] eqiad T266483#6616110
[x] codfw
[x] tendril/zarcillo/orchestrator
[x] db1115
[x] db2093