Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P4957
zarcillo
Active
Public
Actions
Authored by
jcrespo
on Feb 21 2017, 3:03 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F5739914: zarcillo
Feb 21 2017, 3:03 PM
2017-02-21 15:03:04 (UTC+0)
Subscribers
None
./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)
Event Timeline
jcrespo
created this paste.
Feb 21 2017, 3:03 PM
2017-02-21 15:03:04 (UTC+0)
Log In to Comment