您的位置:宽带测速网 > mysql教程 > mysql主从复制丛库IO进程问题的实例分析

mysql主从复制丛库IO进程问题的实例分析

2025-06-24 08:11来源:互联网 [ ]

配置mysql主从复制,启动slave进程后查看slave状态是IO进程报错:
Last_IO_Error: 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).

原因:丛库server-id参数和主库相同,需要修改为其它值,并重启丛库(此案例中修改后没有重启)