List:General Discussion« Previous MessageNext Message »
From:John McCaskey Date:March 22 2004 8:19pm
Subject:RE: What is Frequency of Master Binlog Dump to Slave
View as plain text  
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:hchang@stripped] 
Sent: Monday, March 22, 2004 11:32 AM
To: mysql@stripped
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/mysql?unsub=1

Thread
Avg and Std function - null valuesPina Kelwin22 Mar
  • Re: Avg and Std function - null valuesHarald Fuchs22 Mar
    • What is Frequency of Master Binlog Dump to SlaveHenry Chang22 Mar
RE: What is Frequency of Master Binlog Dump to SlaveJohn McCaskey22 Mar
  • Re: What is Frequency of Master Binlog Dump to SlaveSasha Pachev25 Mar