当前位置: > 数据库 > MySQL >

Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids;

时间:2015-08-09 09:13来源:linux.it.net.cn 作者:IT
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).

报错的起因是我通过rsync将主数据库同步到从数据库,而没有修改MySQL服务器id

解决办法:找到mysql->my.cnf  修改server-id,保证和主数据库的MySQL服务器id不一致

(责任编辑:IT)
------分隔线----------------------------
栏目列表
推荐内容