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. John -----Original Message----- From: Henry Chang [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 11:32 AM To: [EMAIL PROTECTED] 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
