up vote 0 down vote favorite
share [g+] share [fb]

Is it possible to leave the mysql slave 1 hour behind? I would like to create an script wich stops the slave when I markup some hacks such as big drop tables and stuff, to make this work I would like to stop the slave when this happens.

link|improve this question
feedback

2 Answers

up vote 1 down vote accepted

Look at the maatkit tools, specialy at the script mk-slave-delay ...

BTW: When working with mysql you really want to know/use the maatkit tools. Get them, now!

link|improve this answer
Thanks, I'll take a look at that! – Ronn0 Jan 20 '11 at 11:19
Working, thanks a lot! – Ronn0 Jan 20 '11 at 12:25
feedback
up vote 0 down vote

You slave does everything that your master does - so you'll just be moving the transactions back an hour - What exactly are you trying to achieve?

link|improve this answer
Get a replica, but when anything is going wrong (such as a drop database/table) stop my slave before it has run the queries. – Ronn0 Jan 20 '11 at 10:51
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.