NO1:在slave库上:
SQL>slave stop;
SQL>reset master;
NO2:在master库上执行:
SQL>show master status;
记录2个参数值:master_log_file and master_log_pos ->vlues,需要去master库上查询;
No3:在slave库上:
SQL>change master to master_host='172.16.*.*',master_user='slave',master_password='slave',master_port=3306,master_log_file=' mysql-bin.000001',master_log_pos= 430;
SQL>slave start;
SQL>show slave status\G;
主要关心2个参数状态是否为:Yes
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
总结:查看日志,分析错误;找到解决方法!
SQL>slave stop;
SQL>reset master;
NO2:在master库上执行:
SQL>show master status;
记录2个参数值:master_log_file and master_log_pos ->vlues,需要去master库上查询;
No3:在slave库上:
SQL>change master to master_host='172.16.*.*',master_user='slave',master_password='slave',master_port=3306,master_log_file=' mysql-bin.000001',master_log_pos= 430;
SQL>slave start;
SQL>show slave status\G;
主要关心2个参数状态是否为:Yes
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
总结:查看日志,分析错误;找到解决方法!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14661773/viewspace-752649/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14661773/viewspace-752649/