On Mon, 14 Feb 2005, Eric Bergen wrote: > My understanding is that relay-info.log stores Exec_Master_Log_Pos so > in order to only use master.info in a snapshot you need to make sure > that the slave is caught up when the snapshot is taken. It's common > for the I/O thread (controls master.info and downloads logs files) to > be a few queries ahead of the SQL thread (controls relay-log.info and > executes queries). > > If I'm wrong here please correct me. If you have Exec_Master_Log_Pos > you can use it for Read_Master_Log_Pos on change master command on the > new slave so it starts downloading relay logs at the proper position.
Eric, interesting point, I will have to get to the bottom of that so that I can ensure that my slaves have identical data! ;) Luckily I alway seed from an idle slave so it should only be minor inconsistencies if that ever occurred. Thanks! Atle -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]