… recompute positions as they should be on promoted slave and slave should have –log-slave-updates enabled so it somethat has copy of… are using Backup or Slave with delayed replication (which you already could have set up with mk-slave-delay from Maatkit. Delayed slave is especially helpful if… network, meaning it is best to have local backup (and delayed slave if you use one) in each data center you have…
Comment: Why you can't rely on a replica for disaster recovery
August 1, 2010 By 25 Comments
What is anyone’s experience of using Maatkit mk-slave-delay to have a time delayed replica? http://www.maatkit.org/doc/mk-slave-delay.html
Comment: Why you can't rely on a replica for disaster recovery
August 1, 2010 By 25 Comments
Delayed replication is a good way to augment a disaster recovery plan, and help reduce the downtime when something goes bad. But it shouldn’t be relied on all by itself, of course. I wrote mk-slave-delay and often suggest its use.
Comment: How to lag a slave behind to avoid a disaster
September 12, 2012 By 5 Comments
This is one of my favorite pt/mk tools, probably not unreasonable to say data poisoning, (particularly admin … backups and the binlog, a delayed slave makes life a lot easier. I’ve found a delay of 4 hours usually covers the…, as noted above, a slave (even delayed) is not a silver bullet, if it’s past the delay time, you’re out of…
