MySQL Forums
Forum List  »  Replication

Re: Delaying execution of replicated data on a slave
Posted by: Harrison Fisk
Date: March 18, 2005 07:42PM

Hi,

There is no automatic way to do this. However it is possible to set it up using SLAVE START; and SLAVE STOP; thru external scripting.

Basically start the server with the --skip-slave-start option, which will tell replication only to run when you tell it to. Then you can set it up to run SLAVE START; periodically until it has reached the position you want, which can be easily using the master_wait_pos() function, and then shut it off with a SLAVE STOP; and repeat every 15 minutes using cron.

You can also control which replication thread you start and stop, so you could stop just the SQL_THREAD which applies the logs and still leave the IO_THREAD downloading as fast as possible like normal.

Hope that helps give you some ideas.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Delaying execution of replicated data on a slave
2129
March 18, 2005 07:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.