msyql replication time

Question

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 ?

Answer 1

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

CHANGE MASTER TO MASTER_DELAY = 5;