./sql.py -h db1011.eqiad.wmnet zarcillo -e "SELECT fqdn, port, GROUP_CONCAT(shard) as shards FROM instances LEFT JOIN instance_shards ON instances.name = instance_shards.instance_name GROUP BY name" --no-dry-run Results for db1011.eqiad.wmnet:3306/zarcillo: +-----------------------------------+--------+-------------------------------+ | fqdn | port | shards | |-----------------------------------+--------+-------------------------------| | db1001.eqiad.wmnet | 3306 | m1 | | db1009.eqiad.wmnet | 3306 | m5 | | db1011.eqiad.wmnet | 3306 | | | db1015.eqiad.wmnet | 3306 | s3 | | db1016.eqiad.wmnet | 3306 | m1 | | db1018.eqiad.wmnet | 3306 | s2 | | db1020.eqiad.wmnet | 3306 | m2 | | db1021.eqiad.wmnet | 3306 | s2 | | db1022.eqiad.wmnet | 3306 | s6 | | db1023.eqiad.wmnet | 3306 | s6 | | db1024.eqiad.wmnet | 3306 | s2 | | db1026.eqiad.wmnet | 3306 | s5 | | db1028.eqiad.wmnet | 3306 | s7 | | db1029.eqiad.wmnet | 3306 | x1 | | db1030.eqiad.wmnet | 3306 | s6 | | db1031.eqiad.wmnet | 3306 | x1 | | db1033.eqiad.wmnet | 3306 | s7 | | db1034.eqiad.wmnet | 3306 | s7 | | db1035.eqiad.wmnet | 3306 | s3 | | db1036.eqiad.wmnet | 3306 | s2 | | db1037.eqiad.wmnet | 3306 | s6 | | db1038.eqiad.wmnet | 3306 | s3 | | db1039.eqiad.wmnet | 3306 | s7 | | db1040.eqiad.wmnet | 3306 | s4 | | db1041.eqiad.wmnet | 3306 | s7 | | db1043.eqiad.wmnet | 3306 | m3 | | db1044.eqiad.wmnet | 3306 | s3 | | db1045.eqiad.wmnet | 3306 | s5 | | db1046.eqiad.wmnet | 3306 | m4 | | db1047.eqiad.wmnet | 3306 | m4,s1,s2 | | db1048.eqiad.wmnet | 3306 | m3 | | db1049.eqiad.wmnet | 3306 | s5 | | db1050.eqiad.wmnet | 3306 | s6 | | db1051.eqiad.wmnet | 3306 | s1 | | db1052.eqiad.wmnet | 3306 | s1 | | db1053.eqiad.wmnet | 3306 | s4 | | db1054.eqiad.wmnet | 3306 | s2 | | db1055.eqiad.wmnet | 3306 | s1 | | db1056.eqiad.wmnet | 3306 | s4 | | db1057.eqiad.wmnet | 3306 | s1 | | db1059.eqiad.wmnet | 3306 | s4 | | db1060.eqiad.wmnet | 3306 | s2 | | db1061.eqiad.wmnet | 3306 | s6 | | db1062.eqiad.wmnet | 3306 | s7 | | db1063.eqiad.wmnet | 3306 | s2 | | db1064.eqiad.wmnet | 3306 | s4 | | db1065.eqiad.wmnet | 3306 | s1 | | db1066.eqiad.wmnet | 3306 | s1 | | db1067.eqiad.wmnet | 3306 | s2 | | db1068.eqiad.wmnet | 3306 | s4 | | db1069.eqiad.wmnet | 3311 | s1 | | db1069.eqiad.wmnet | 3312 | s2 | | db1069.eqiad.wmnet | 3313 | s3 | | db1069.eqiad.wmnet | 3314 | s4 | | db1069.eqiad.wmnet | 3315 | s5 | | db1069.eqiad.wmnet | 3316 | s6 | | db1069.eqiad.wmnet | 3317 | s7 | | db1070.eqiad.wmnet | 3306 | s5 | | db1071.eqiad.wmnet | 3306 | s5 | | db1072.eqiad.wmnet | 3306 | s1 | | db1073.eqiad.wmnet | 3306 | s1 | | db1074.eqiad.wmnet | 3306 | s2 | | db1075.eqiad.wmnet | 3306 | s3 | | db1076.eqiad.wmnet | 3306 | s2 | | db1077.eqiad.wmnet | 3306 | s3 | | db1078.eqiad.wmnet | 3306 | s3 | | db1079.eqiad.wmnet | 3306 | s7 | | db1080.eqiad.wmnet | 3306 | s1 | | db1081.eqiad.wmnet | 3306 | s4 | | db1082.eqiad.wmnet | 3306 | s5 | | db1083.eqiad.wmnet | 3306 | s1 | | db1084.eqiad.wmnet | 3306 | s4 | | db1085.eqiad.wmnet | 3306 | s6 | | db1086.eqiad.wmnet | 3306 | s7 | | db1087.eqiad.wmnet | 3306 | s5 | | db1088.eqiad.wmnet | 3306 | s6 | | db1089.eqiad.wmnet | 3306 | s1 | | db1090.eqiad.wmnet | 3306 | s2 | | db1091.eqiad.wmnet | 3306 | s4 | | db1092.eqiad.wmnet | 3306 | s5 | | db1093.eqiad.wmnet | 3306 | s6 | | db1094.eqiad.wmnet | 3306 | s7 | | db1095.eqiad.wmnet | 3306 | s1,s3,s4 | | db2010.codfw.wmnet | 3306 | m1 | | db2011.codfw.wmnet | 3306 | m2 | | db2012.codfw.wmnet | 3306 | m3 | | db2016.codfw.wmnet | 3306 | s1 | | db2017.codfw.wmnet | 3306 | s2 | | db2018.codfw.wmnet | 3306 | s3 | | db2019.codfw.wmnet | 3306 | s4 | | db2023.codfw.wmnet | 3306 | s5 | | db2028.codfw.wmnet | 3306 | s6 | | db2029.codfw.wmnet | 3306 | s7 | | db2030.codfw.wmnet | 3306 | m5 | | db2033.codfw.wmnet | 3306 | x1 | | db2034.codfw.wmnet | 3306 | s1 | | db2035.codfw.wmnet | 3306 | s2 | | db2036.codfw.wmnet | 3306 | s3 | | db2037.codfw.wmnet | 3306 | s4 | | db2038.codfw.wmnet | 3306 | s5 | | db2039.codfw.wmnet | 3306 | s6 | | db2040.codfw.wmnet | 3306 | s7 | | db2041.codfw.wmnet | 3306 | s2 | | db2042.codfw.wmnet | 3306 | s1 | | db2043.codfw.wmnet | 3306 | s3 | | db2044.codfw.wmnet | 3306 | s4 | | db2045.codfw.wmnet | 3306 | s5 | | db2046.codfw.wmnet | 3306 | s6 | | db2047.codfw.wmnet | 3306 | s7 | | db2048.codfw.wmnet | 3306 | s1 | | db2049.codfw.wmnet | 3306 | s2 | | db2050.codfw.wmnet | 3306 | s3 | | db2051.codfw.wmnet | 3306 | s4 | | db2052.codfw.wmnet | 3306 | s5 | | db2053.codfw.wmnet | 3306 | s6 | | db2054.codfw.wmnet | 3306 | s7 | | db2055.codfw.wmnet | 3306 | s1 | | db2056.codfw.wmnet | 3306 | s2 | | db2057.codfw.wmnet | 3306 | s3 | | db2058.codfw.wmnet | 3306 | s4 | | db2059.codfw.wmnet | 3306 | s5 | | db2060.codfw.wmnet | 3306 | s6 | | db2061.codfw.wmnet | 3306 | s7 | | db2062.codfw.wmnet | 3306 | s1 | | db2063.codfw.wmnet | 3306 | s2 | | db2064.codfw.wmnet | 3306 | s2 | | db2065.codfw.wmnet | 3306 | s4 | | db2066.codfw.wmnet | 3306 | s5 | | db2067.codfw.wmnet | 3306 | s6 | | db2068.codfw.wmnet | 3306 | s7 | | db2069.codfw.wmnet | 3306 | s1 | | db2070.codfw.wmnet | 3306 | s1 | | dbstore1001.eqiad.wmnet | 3306 | m3,s1,s2,s3,s4,s5,s6,s7,x1 | | dbstore1002.eqiad.wmnet | 3306 | m3,m4,s1,s2,s3,s4,s5,s6,s7,x1 | | dbstore2001.codfw.wmnet | 3306 | m3,s1,s2,s3,s4,s5,s6,s7,x1 | | dbstore2002.codfw.wmnet | 3306 | s1,s3,s4,s5,x1 | | es1011.eqiad.wmnet | 3306 | es2 | | es1012.eqiad.wmnet | 3306 | es1 | | es1013.eqiad.wmnet | 3306 | es2 | | es1014.eqiad.wmnet | 3306 | es3 | | es1015.eqiad.wmnet | 3306 | es2 | | es1016.eqiad.wmnet | 3306 | es1 | | es1017.eqiad.wmnet | 3306 | es3 | | es1018.eqiad.wmnet | 3306 | es1 | | es1019.eqiad.wmnet | 3306 | es3 | | es2011.codfw.wmnet | 3306 | es1 | | es2012.codfw.wmnet | 3306 | es1 | | es2013.codfw.wmnet | 3306 | es1 | | es2014.codfw.wmnet | 3306 | es2 | | es2015.codfw.wmnet | 3306 | es2 | | es2016.codfw.wmnet | 3306 | es2 | | es2017.codfw.wmnet | 3306 | es3 | | es2018.codfw.wmnet | 3306 | es3 | | es2019.codfw.wmnet | 3306 | es3 | | labsdb1001.eqiad.wmnet | 3306 | s1,s2,s3,s4,s5,s6,s7 | | labsdb1003.eqiad.wmnet | 3306 | s1,s2,s3,s4,s5,s6,s7 | | labsdb1004.eqiad.wmnet | 3306 | tools | | labsdb1005.eqiad.wmnet | 3306 | tools | | labsdb1009.eqiad.wmnet | 3306 | s1,s3,s4 | | labsdb1010.eqiad.wmnet | 3306 | s1,s3,s4 | | labsdb1011.eqiad.wmnet | 3306 | s1,s3,s4 | | labservices1001.wikimedia.org | 3306 | | | labservices1002.wikimedia.org | 3306 | | | labtestservices2001.wikimedia.org | 3306 | | | pc1004.eqiad.wmnet | 3306 | pc1 | | pc1005.eqiad.wmnet | 3306 | pc2 | | pc1006.eqiad.wmnet | 3306 | pc3 | | pc2004.codfw.wmnet | 3306 | pc1 | | pc2005.codfw.wmnet | 3306 | pc2 | | pc2006.codfw.wmnet | 3306 | pc3 | +-----------------------------------+--------+-------------------------------+ 170 rows in set (0.00 sec)