Some related commands for MySQL master-slave replication replication

Related commands on the primary server:
Show master status;

Mysql>Show Master Status\g*************************** 1. Row***************************             File: Host2-Bin.000002Position:420binlog_do_db:binlog_ignore_db:executed_gtid_set:5abd564e-2b4f-11e5-A7f1-000C2954CCDE:1, 780aa541-2b93-11e5-A9ad-000C29EF36A8:11Rowinch Set(0.00Sec

Show slave hosts;

Mysql>show slave hosts;+-----------+-----------------+------+-----------+--------------------------------------+|server_id|Host|Port|master_id|Slave_uuid|+-----------+-----------------+------+-----------+--------------------------------------+|         1 | 192.168.203.133 | 3306 |         2 |780aa541-2b93-11e5-A9ad-000c29ef36a8||         3 | 192.168.203.134 | 3306 |         2 |5abd564e-2b4f-11e5-A7f1-000c2954ccde|+-----------+-----------------+------+-----------+--------------------------------------+2Rowsinch Set(0.00Sec

Show binary logs;

Mysql>Showbinarylogs;+------------------+-----------+|Log_name|File_size|+------------------+-----------+|Host2-Bin.000001 |       413 ||Host2-Bin.000002 |       420 |+------------------+-----------+2Rowsinch Set(0.00Sec

Show Binlog events;

Mysql>show Binlog events;+------------------+-----+----------------+-----------+-------------+----------------------------------------- --------------------------+|Log_name|Pos|Event_type|server_id|End_log_pos|Info|+------------------+-----+----------------+-----------+-------------+----------------------------------------- --------------------------+|Host2-Bin.000001 |   4 |Format_desc|         2 |          - |Server ver:5.6. --Log, Binlog ver:4                             ||Host2-Bin.000001 |  - |Previous_gtids|         2 |         151 |                                                                   ||Host2-Bin.000001 | 151 |Gtid|         1 |         199 | SET @ @SESSION. Gtid_next= '780aa541-2b93-11e5-a9ad-000c29ef36a8:1' ||Host2-Bin.000001 | 199 |Query|         1 |         262 | BEGIN                                                             ||Host2-Bin.000001 | 262 |Table_map|         1 |         309 |TABLE_ID: -(TESTDB.T1)||Host2-Bin.000001 | 309 |Delete_rows|         1 |         359 |TABLE_ID: -Flags:stmt_end_f||Host2-Bin.000001 | 359 |Xid|         1 |         390 | COMMIT /*xid=423*/                                              ||Host2-Bin.000001 | 390 |Stop|         2 |         413 |                                                                   |+------------------+-----+----------------+-----------+-------------+----------------------------------------- --------------------------+8Rowsinch Set(0.00Sec

The following are some of the deletions are binary related, do not make a demonstration, the specific can be searched for usage:

Purge logs to ' log_name ';
Purge logs before ' date ';
Reset master; (old version flush Master)
Set sql_log_bin=

From the relevant command on the server:
Slave start
Slave stop
SLAVE STOP io_thread//This thread writes the log of the master segment to a local
SLAVE Start Io_thread
SLAVE STOP sql_thread//This thread applies the logs written locally to the database
SLAVE Start Sql_thread
Reset Slave
SET GLOBAL Sql_slave_skip_counter
Load data from Master
Show slave status (Super,replication CLIENT)
Change Master to master_host=, master_port=,master_user=, master_password=//changing Master information dynamically
PURGE Master [before ' date '] Delete logs that have been synchronized on the master side

Some related commands for MySQL master-slave replication replication