Home / server / Questions / 72895
Accepted
Pedro
Asked: 2009-10-10 03:31:45 +0800 CST

MySql Replication Force Delays

  • 772

I'm maintaing one test Env in my company.

And I'm uptating the test Databases as slaves of the Production ones.

What I need to know is if there is anyaways of updating this specific slave just 1 or 2 times a day, not almost in realtime it is at the moment?

Regards, Pedro

mysql

2 Answers

  1. Best Answer

    I'm not aware of a configurable option to do this.

    However slaves will happily pick up from wherever they left off if they are disconnected from the master. With this in mind, you could script STOP SLAVE/START SLAVE commands at the intervals you require.

    You will probably want to ensure that the slaves are finished replicating to-date using the Seconds_Behind_Master value or mk-table-checksum before stopping them again.

    • 1

  2. There is no builtin method to do so. If you only want to resync once or twice a day, I suggest you follow the route pointed out by Dan Carley.

    If you want the database to lag behind a specified amount of time, say - a few hours, you could use mk-slave-delay from maatkit. This will automaically balance the START SLAVE/STOP SLAVE cycle to maintain the defined delay.

    • 0