John McCaskey wrote:
The master pushes data to the slave as soon as it has executed the query
itself.  It is not a periodic push, but an asyncrounous push as soon as
data is ready to be sent.  So the gap would only be as great as the
latency between your two servers.

If the servers are disconnected or unable to communicate for any reason
you need to be careful about your timeout values and connection retry
values or they may not attempt to reconnect for a while and then there
will be a datagap until they attempt to reconnect.

To clear up the terminology confusion - there is no push. The slave connects and asks the master to give it a dump of its update log.



-- Sasha Pachev Create online surveys at http://www.surveyz.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to