1,针对传统复制:start slave 可以指定sql线程的 end log file and position的:
START SLAVE UNTIL sql_thread master_log_file='binlog.000002',master_log_pos=829090187;
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
2,针对gtid复制:start slave 可以指定sql线程的sql_before_gtids的:
start slave sql_thread until sql_before_gtids='9e912d2b-92f6-11e8-9747-0050568be82c:9791090';
不过UNTIL语法不可以用在IO_THREAD上。
# 当获取到一个全新的备份后,进行如下操作:
stop slave;
reset slave all;
reset master;
change master to master_host='10.10.10.10',master_port=3306,master_user='mysqlsync',master_password='123456', master_log_file='mysql-bin.009044',master_log_pos=517587984;
start slave io_thread;
start slave sql_thread until master_log_file='mysql-bin.009161',master_log_pos=224619836;
https://www.cnblogs.com/fengjian2016/p/12456170.html