Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids;
- 作者: 东方神起去哪了
- 来源: 51数据库
- 2020-08-28
|
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不一致 |
推荐阅读
