Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

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

share|improve this question

2 Answers

up vote 1 down vote accepted

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.

share|improve this answer
up vote 0 down vote

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.

share|improve this answer
Did you read the question? MySQL's binary execution is very slow and could take hours depending on volume. I would recommend a file level copy if the goal is to catch up once per day and not continuously. – randy melder Oct 12 '09 at 4:05
I read the question, did you read the answer? I suggested an alternative. Also, it is a failure to suggest a file level copy being superior to binary replication without knowledge of replication volume nor dataset size. – Jan Jungnickel Oct 12 '09 at 8:45

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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