Home  >  Article  >  Database  >  mysql 剔除从库

mysql 剔除从库

WBOY
WBOYOriginal
2016-06-07 16:27:061245browse

mysql 删除从库 mysql stop slave; Query OK, 0 rows affected (0.19 sec) mysql reset slave; 以上如果未清除,用下面 从库删除: mysql reset slave all; Query OK, 0 rows affected (0.04 sec) mysql show slave status\G; 用于mysql5.5或更高版本

mysql 删除从库
mysql> stop slave;  

 

Query OK, 0 rows affected (0.19 sec) 


mysql> reset slave;

以上如果未清除,用下面
从库删除:
mysql> reset slave all;  
Query OK, 0 rows affected (0.04 sec) 
mysql> show slave status\G; 

用于mysql5.5或更高版本
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn