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 (
So from my understanding it is not time driven, but event driven.
On Thu, Jul 26, 2012 at 11:25 AM, Zhigang Zhang <zzgang2008@stripped>wrote:
> 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
> pull data from master?
> Zhigang Zhang
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql