MySQL 关闭slave主重

1、停止从服务 

stop slave;

2、检查slave_open_temp_tables变量的值 

show status like '%slave%';

mysql> show status like '%slave%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| Com_show_slave_hosts   | 0     |
| Com_show_slave_status  | 1     |
| Com_slave_start        | 1     |
| Com_slave_stop         | 2     |
| Slave_open_temp_tables | 0     |
+------------------------+-------+
5 rows in set (0.00 sec)

3、删除主从信息

# 删除配置信息
reset slave;
change master to master_host=' ', master_user=' ', master_password=' ';

# 或者直接
reset slave all