From: Yanis Guenane Date: July 26 2012 9:57am Subject: Re: how often the slave to pull data from master? List-Archive: http://lists.mysql.com/mysql/227894 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=047d7b6041ba01756904c5b8a090 --047d7b6041ba01756904c5b8a090 Content-Type: text/plain; charset=ISO-8859-1 Please can someone correct me if I am wrong. It doesn't work with timer. On your *master*, you need to activate the binaries log. Everytime and UPDATE/INSERT/DELETE is done on the master mysql server, the event is recorded within those binaries log. On your *slave* - if it is activated to act as a slave- you should have 2 Thread running all the time. One that reads the Master binaries log file, aka I/O Thread ( http://dev.mysql.com/doc/refman/5.0/en/slave-io-thread-states.html) . And one to apply those changes locally, aka SQL Thread ( http://dev.mysql.com/doc/refman/5.0/en/slave-sql-thread-states.html) So from my understanding it is not time driven, but event driven. On Thu, Jul 26, 2012 at 11:25 AM, Zhigang Zhang wrote: > Hello: > > I haven't read the source code of mysql ,but as I know ,the slave get data > from master server, rather than the master push data to slave. > > I think there is a timer to do this. > > Who can tell me the interval about the replication----how often the slave > to > pull data from master? > > Thanks! > > Zhigang Zhang > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- *Yanis Guenane* --047d7b6041ba01756904c5b8a090--