root@db1115.eqiad.wmnet[tendril]> select * from shards where name like 'pc%';
+------+-----------+-------+---------+
| name | master_id | place | display |
+------+-----------+-------+---------+
| pc1  |      1531 |    16 |       1 |
| pc2  |      1534 |    17 |       1 |
| pc3  |      1718 |    18 |       1 |
+------+-----------+-------+---------+
3 rows in set (0.001 sec)

root@db1115.eqiad.wmnet[tendril]> select host from servers where id=1534;
+--------------------+
| host               |
+--------------------+
| pc2009.codfw.wmnet |
+--------------------+
1 row in set (0.001 sec)