原来start slave 可以指定end log file and position的:
START SLAVE UNTIL master_log_file='binlog.000002',master_log_pos=829090187
START SLAVE [thread_type [, thread_type] ... ] START SLAVE [SQL_THREAD] UNTIL MASTER_LOG_FILE = 'log_name', MASTER_LOG_POS = log_pos START SLAVE [SQL_THREAD] UNTIL RELAY_LOG_FILE = 'log_name', RELAY_LOG_POS = log_pos thread_type: IO_THREAD | SQL_THREAD 不过UNTIL语法不可以用在IO_THREAD上。