MySQL备份与恢复之MySQL 延时备份 - 数据库编程

master position mysql-bin.000001/492 2013-10-06T20:05:50 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:06:10 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:06:30 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:06:50 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:07:10 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:07:30 no new binlog events 2013-10-06T20:07:50 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:08:10 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:08:30 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:08:50 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:09:10 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:09:30 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:09:50 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:10:10 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:10:30 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:10:50 no new binlog events 2013-10-06T20:11:10 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:11:30 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:11:50 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:12:10 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:12:30 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:12:50 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:13:10 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:13:30 slave stopped at master position mysql-bin.000001/492 2013-10-06T20:13:30 Setting slave to run normally mysql>

select * from justdb.test; +------+ | id | +------+ | 1 | +------+ 1 row in set (0.00 sec)

四附延时备份脚本

#!/bin/bash
#
# chkconfig: - 88 12
# description: the mysql ab delay scripts

host=192.168.100.54
user=rep
password=larry

delay=2m
in=15s

prog=/usr/bin/pt-slave-delay

. /etc/init.d/functions

start() {
    echo -n "Starting `basename $prog`..."
    daemon $prog --host=$host --user=$user --password=$password --delay=$delay --interval=$in --daemonize --log=/var/log/mysql-delay.log
    echo
}

stop() {
    echo -n "Stopping `basename $prog`..."
    killproc  $prog
    echo
}

case "$1" in 
    start)
        start
        ;;
    stop)
        stop
        ;;
    restart)
        stop
        start
        ;;
    *)
        echo "Usage: $0 {start|stop|restart}"
        exit 1
esac

MySQL备份与恢复之MySQL 延时备份(三)

四 附延时备份脚本

四附延时备份脚本