start slave

 

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