Replication puts 2 threads on the slave -- 1 to get the information from the master and put it into the relay log, and another to read from the relay log. You pose a good question about master.info -- I honestly don't know, but the read position is either the same as or before the exec position, so I'd put it as the read position.
You say it's for recovery, so it probably doesn't matter unless you somehow have another number for the log position. You only get to put one number in CHANGE MASTER TO .... MASTER_LOG_POS so it's not like you have a choice anyway. stop slave stops both threads. The exec thread doesn't catch up to the read thread. Aren't these things you could have tested yourself? -Sheeri On 5/18/06, Dominik Klein <[EMAIL PROTECTED]> wrote:
Hi, for recovery purposes I need to know what exactly is in the master.info file. Especially the log position. Is it Read_Master_Log_Pos or Exec_Master_Log_Pos? Another question: Does "stop slave;" only stop reading the log from master or does it also stop executing the log that has been read already, but not yet executed? Regards Dominik -- 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]