Slave Server is delayed more than 12 hours even though I use pt-slave-delay with --delay=12h option.
The slave usually is delayed for about 12 hours but slave is delays for more thant 20 hours
after cold backup which stops MySQL. pt-slave-delay have been stopped for about ten hours.
I reproducted this problem on test environment and test scripts.
-
Building 1 Master and 1 Slave replicatioin environment
-
stop MySQL on slave
slave> /etc/init.d/mysql stop -
generate test data on master
sh create_data.sh
- execute update MySQL data script on master after generating test data
update_data.sh
- start MySQL and pt-slave-delay on slave
/etc/init.d/mysql start; /usr/bin/pt-slave-delay --delay=12h --interval=30s localhost
6 waiting for a while…
I attached pt-slave-delay log. pt-slave-delay wrote the follwing message
2013-08-01T17:27:35 STOP SLAVE until 2013-08-01T19:50:07 at master position mysql-bin.000005/4757615
However pt-slave-delay didn’t start at around 19:50. It started at 4:30:06 on the next day.
It is 18 hour behind!
2013-08-02T04:30:06 START SLAVE until master 2013-08-01T16:30:05 mysql-bin.000005/2045535
Why is pt-slave-delay more delayed than set values(12h)?