List:General Discussion« Previous MessageNext Message »
From:Yanis Guenane Date:July 26 2012 9:57am
Subject:Re: how often the slave to pull data from master?
View as plain text  
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 <zzgang2008@stripped>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*

Thread
how often the slave to pull data from master?Zhigang Zhang26 Jul
  • Re: how often the slave to pull data from master?Yanis Guenane26 Jul