2

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.

Sam Cogan
  • 38,736
  • 6
  • 78
  • 114
Ronn0
  • 105
  • 1
  • 7

2 Answers2

2

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!

m.sr
  • 1,060
  • 1
  • 8
  • 19
0

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?

Mister IT Guru
  • 1,178
  • 3
  • 15
  • 35
  • 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