START SLAVE ["connection_name"] [thread_type [, thread_type] ... ] START SLAVE ["connection_name"] [SQL_THREAD] UNTIL MASTER_LOG_FILE = 'log_name', MASTER_LOG_POS = log_pos START SLAVE ["connection_name"] [SQL_THREAD] UNTIL RELAY_LOG_FILE = 'log_name', RELAY_LOG_POS = log_pos START SLAVE ["connection_name"] [SQL_THREAD] UNTIL MASTER_GTID_POS = <GTID position> START ALL SLAVES [thread_type [, thread_type]] thread_type: IO_THREAD | SQL_THREAD
START SLAVE with no thread_type options starts both of the slave threads (see replication). The I/O thread reads events from the master server and stores them in the relay log. The SQL thread reads events from the relay log and executes them.
START SLAVE requires the
START SLAVE succeeds in starting the slave threads, it returns without any error. However, even in that case, it might be that the slave threads start and then later stop (for example, because they do not manage to connect to the master or read its binary log, or some other problem).
START SLAVE does not warn you about this. You must check the slave's error log for error messages generated by the slave threads, or check that they are running satisfactorily with
START SLAVE UNTIL refers to the
SQL_THREAD slave position at which the
SQL_THREAD replication will halt. If
SQL_THREAD isn't specified both threads are started.
Since version 10.0.2,
START SLAVE UNTIL master_gtid_pos=xxx has also been supported. See Global Transaction ID/START SLAVE UNTIL master_gtid_pos=xxx for more details.
If there is only one nameless master, or the default master (as specified by the
default_master_connection system variable) is intended,
connection_name can be omitted. If provided, the
START SLAVE statement will apply to the specified master.
connection_name is case-insensitive.
START ALL SLAVES starts all configured slaves (slaves with master_host not empty) that were not started before. It will give a
note for all started connections. You can check the notes with
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.