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.
From: Henry Chang [mailto:hchang@stripped]
Sent: Monday, March 22, 2004 11:32 AM
Subject: What is Frequency of Master Binlog Dump to Slave
I got MySQL replication working in master-slave configuration. It's
really cool, but how often does the master send binlog dump to the
slave. The implication is if the master crashes, what would be the
potential data gap in the slave??
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql