mysql start until_mysql 利用新建从库 使用 start slave until 恢复方法

change master to master_host='db210',master_port=3506,master_user='wyz',master_password='xxxx',master_auto_position=1;

root@localhost [(none)]>start slave io_thread ;

Query OK,0 rows affected (0.01sec)

root@localhost [(none)]>show slave statusG;*************************** 1. row ***************************Slave_IO_State: Queueing mastereventto the relay log

Master_Host: db210

Master_User: wyz

Master_Port:3506Connect_Retry:60Master_Log_File: mysql-bin.000015Read_Master_Log_Pos:10476294Relay_Log_File: relay-bin.000001Relay_Log_Pos:4Relay_Master_Log_File:

Slave_IO_Running: Yes

Slave_SQL_Running: No

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno:0Last_Error:

Skip_Counter:0Exec_Master_Log_Pos:0Relay_Log_Space:27669048Until_Condition: None

Until_Log_File:

Until_Log_Pos:0Master_SSL_Allowed: No

Master_SSL_CA_File:

Master_SSL_CA_Path:

Master_SSL_Cert:

Master_SSL_Cipher:

Master_SSL_Key:

Seconds_Behind_Master: NULL

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno:0Last_IO_Error:

Last_SQL_Errno:0Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id:1853506Master_UUID: 9e912d2b-92f6-11e8-9747-0050568be82c

Master_Info_File:/data/57mysql/mysql3506/data/master.info

SQL_Delay:0SQL_Remaining_Delay: NULL

Slave_SQL_Running_State:

Master_Retry_Count:86400Master_Bind:

Last_IO_Error_Timestamp:

Last_SQL_Error_Timestamp:

Master_SSL_Crl:

Master_SSL_Crlpath:

Retrieved_Gtid_Set: 9e912d2b-92f6-11e8-9747-0050568be82c:6730274-6788383Executed_Gtid_Set: 9e912d2b-92f6-11e8-9747-0050568be82c:1-6730273Auto_Position:1Replicate_Rewrite_DB:

Channel_Name:

Master_TLS_Version:1 row in set (0.00sec)

ERROR:

No query specified

root@localhost [(none)]>root@localhost [(none)]>start slave sql_thread until sql_before_gtids='9e912d2b-92f6-11e8-9747-0050568be82c:9791090';

Query OK,0 rows affected (0.00 sec)