aaronbbrown

                                            My traceroute  [v0.80]gaeta-wifi.borg.lan (0.0.0.0)                                                         Fri Feb  3 19:08:50 2012
Resolver: Received error response 2. (server failure)er of fields   quit
                                                                      Packets               Pings
 Host                                                               Loss%   Snt   Last   Avg  Best  Wrst StDev
 1. router.borg.lan                                                  0.0%    95    1.3   1.6   1.0  10.1   1.2
 2. 10.117.128.1                                                    44.2%    95    7.5  12.9   6.6  49.0   7.2
 3. vlan109.que7600-pv-1.twalb.com                                  38.9%    95    9.9  17.1   7.0  94.2  15.0

aaronbbrown

                                 My traceroute  [v0.80]anders.borg.lan (0.0.0.0)                                                                                                             Fri Feb  3 10:51:27 2012
Keys:  Help   Display mode   Restart statistics   Order of fields   quit
                                                                                                                      Packets               Pings
 Host                                                                                                               Loss%   Snt   Last   Avg  Best  Wrst StDev
 1. router.borg.lan                                                                                                  0.0%     7    1.1   1.1   0.7   1.4   0.2
 2. 10.117.128.1                                                                                                    83.3%     7    9.1   9.1   9.1   9.1   0.0
 3. vlan109.que7600-pv-1.twalb.com                                                                                

aaronbbrown

#!/bin/bash
U=user
P=pass
MYSQLCMD="mysql -u $U -p$P -e"
SECS=60

OLDLOGPOS=1
while : ; do
  LOGPOS=$($MYSQLCMD "SHOW SLAVE STATUS\G" | grep Exec_Master_Log_Pos | awk '{print $2}')
  echo "$(date) pos: $LOGPOS old pos: $OLDLOGPOS"

aaronbbrown

#!/bin/bash

U=user
P=pass
MYSQLCMD="mysql -u $U -p$P -BN -e"

while : ; do
  LAG=$($MYSQLCMD "select now()-ts as behind_by from maatkit.heartbeat limit 1;" | awk -F. '{print $1}')
  echo "$(date) $LAG"
  if [[ $LAG -gt 120 ]]; then