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
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:
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