Page MenuHomePhabricator
Paste P13667

(An Untitled Masterwork)
ActivePublic

Authored by Marostegui on Fri, Jan 8, 6:44 AM.
# cat clouddb | grep cloud | while read host; do echo $host; mysql.py -h$host mysql -e "select user,host from user where user like '%haproxy%';";done
clouddb1013:3311
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1013:3313
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1014:3312
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1014:3317
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1015:3314
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1015:3316
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1016:3315
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1016:3318
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1017:3311
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1017:3313
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1018:3312
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1018:3317
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1019:3314
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1019:3316
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1020:3315
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28
clouddb1020:3318
User Host
haproxy 10.64.37.27
haproxy 10.64.37.28

Event Timeline

Marostegui created this paste.Fri, Jan 8, 6:44 AM
mariadb-s1,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,3,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,
mariadb-s1,clouddb1017.eqiad.wmnet,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,32003,0,,1,3,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,5.5.5-10.4.15-MariaDB,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,
mariadb-s1,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,0,,0,32003,0,,1,3,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,
mariadb-s2,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,4,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,
mariadb-s2,clouddb1018.eqiad.wmnet,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,32003,0,,1,4,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,5.5.5-10.4.15-MariaDB,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,
mariadb-s2,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,0,,0,32003,0,,1,4,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,
mariadb-s3,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,5,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,
mariadb-s3,clouddb1017.eqiad.wmnet,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,32003,0,,1,5,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,5.5.5-10.4.15-MariaDB,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,
mariadb-s3,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,0,,0,32003,0,,1,5,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,
mariadb-s4,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,6,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,
mariadb-s4,clouddb1019.eqiad.wmnet,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,32003,0,,1,6,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,5.5.5-10.4.15-MariaDB,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,
mariadb-s4,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,0,,0,32003,0,,1,6,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,
mariadb-s5,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,7,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,
mariadb-s5,clouddb1020.eqiad.wmnet,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,32003,0,,1,7,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,5.5.5-10.4.15-MariaDB,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,
mariadb-s5,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,0,,0,32003,0,,1,7,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,
mariadb-s6,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,8,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,
mariadb-s6,clouddb1019.eqiad.wmnet,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,32003,0,,1,8,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,5.5.5-10.4.15-MariaDB,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,
mariadb-s6,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,0,,0,32003,0,,1,8,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,
mariadb-s7,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,9,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,
mariadb-s7,clouddb1018.eqiad.wmnet,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,32003,0,,1,9,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,5.5.5-10.4.15-MariaDB,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,
mariadb-s7,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,0,,0,32003,0,,1,9,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,
mariadb-s8,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,10,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,
mariadb-s8,clouddb1020.eqiad.wmnet,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,32003,0,,1,10,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,5.5.5-10.4.15-MariaDB,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,
mariadb-s8,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,0,,0,32003,0,,1,10,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,