slave lag should be easy to do with a simple bash script. i.e. -
desired_delay=3600 # one hour lag
while sleep 60
do
behind=`mysql -u root --password=foobar -e "show slave status\G" |
grep 'Seconds_Behind_Master:' | awk '{ printf "%s\n", $2 }'`
if [ $behind < $desired_delay ]; then
mys
Hi Shain,
If you are using InnoDB its possible to patch to allow this functionality.
Percona are in the early stages of developing a patch specifically to
allow flashback type access to previous table states.
https://bugs.launchpad.net/percona-patches/+bug/301925
If you wanted to go down the sl
