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)
| 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) |