0

I am planning to setup mysql master-master or master-slave configuration. Yet to be decided.

But my question is, is there any way to specify in the slave or master saying that it needs to check for master's binary file every say, 5 seconds or so ? Is this parameter configurable ?

1
  • 1
    I don't understand your question. Do you want to enforce a delay in replication between the master and the slave? Are you looking to configure the reconnect time? I think you might be misunderstanding MySQL replication - the slave I/O thread maintains a persistent connection to the master. It doesn't poll it periodically. Oct 23 '11 at 1:34
1

From version 5.6, you can do it with MASTER_DELAY option.

CHANGE MASTER TO MASTER_DELAY = 5;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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