Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
mysql:scripts [2009/01/06 13:06] a Pretty InnoDB Buffer Pool Stats |
mysql:scripts [2009/05/25 00:35] (current) |
||
---|---|---|---|
Line 87: | Line 87: | ||
done | done | ||
</ | </ | ||
+ | |||
===== Sniff the MySQL traffic on the fly ===== | ===== Sniff the MySQL traffic on the fly ===== | ||
Line 101: | Line 102: | ||
</ | </ | ||
+ | ===== RESET SLAVE ===== | ||
+ | <code bash|f reset-mysql-slave.sh> | ||
+ | #!/bin/bash | ||
+ | |||
+ | HOST=$1 | ||
+ | RPASS=$(< | ||
+ | |||
+ | IFS=" | ||
+ | " | ||
+ | |||
+ | mysql -h $HOST -e "STOP SLAVE" | ||
+ | |||
+ | for line in $(mysql -e "SHOW SLAVE STATUS" | ||
+ | do | ||
+ | key=${line%: | ||
+ | key=${key// | ||
+ | data=${line# | ||
+ | data=${data// | ||
+ | |||
+ | case $key in | ||
+ | Exec_master_log_pos) LOGPOS=$data;; | ||
+ | Relay_Master_Log_File) LOGFILE=$data;; | ||
+ | Master_Host) RHOST=$data;; | ||
+ | Master_User) RUSER=$data;; | ||
+ | esac | ||
+ | |||
+ | done | ||
+ | |||
+ | if [ -z $LOGPOS -o -z $LOGFILE ]; then | ||
+ | echo "OMG FAIL NO POSITIONS KNOWN"; | ||
+ | fi | ||
+ | |||
+ | mysql -f -h $HOST -e " | ||
+ | RESET SLAVE; | ||
+ | CHANGE MASTER TO | ||
+ | MASTER_HOST=' | ||
+ | MASTER_USER=' | ||
+ | MASTER_PASSWORD=' | ||
+ | MASTER_LOG_FILE=' | ||
+ | MASTER_LOG_POS=$LOGPOS ; | ||
+ | START SLAVE | ||
+ | " | ||
+ | </ | ||