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

MySQL复制错误解决
最新推荐文章于 2022-05-22 14:06:20 发布
最新推荐文章于 2022-05-22 14:06:20 发布
阅读量4.3k 收藏 1
点赞数
CC 4.0 BY-SA版权
分类专栏： centos mysql 文章标签： mysql linux io 数据库 服务器
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/slovyz/article/details/38924899
本文介绍了一种常见的MySQL复制错误——当主从服务器ID相同时出现的致命错误，并提供了通过修改my.cnf文件中的server-id来解决该问题的方法。

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不一致

mysql 主从配置以及 slave I/O 启动失败解决 Fatal error: The slave I/O thread stops because master and slave have
专注于编程、AI、人工智能等多个领域内容研究和分析
06-07 2882
安装参考： http://www.centoscn.com/mysql/2014/0610/3115.html http://www.cnblogs.com/amuge/p/5863115.html 安装完成启动报错： Fatal error: The slave I/O thread stops because master and slave have equal MySQL
搭建Mysql双主双从报错The slave I/O thread stops because master and slave have equal MySQL server UUIDs(已解决)
weixin_52457745的博客
04-12 2833
搭建Mysql双主双从报错The slave I/O thread stops because master and slave have equal MySQL server UUIDs 具体问题 Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replicati
给Mysql 配置主从时出现如下错误:The slave I/O thread stops because master and slave have equal MySQL server ids;
daobageg的博客
07-08 3962
给Mysql 配置主从时出现如下错误:The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work整体错误如下：排查错误 整体错误如下： Fatal error: The slave I/O th...
mysql server ids_mysql5.5.44 主从复制master and slave have equal MySQL server ids
weixin_35308770的博客
01-27 177
mysql5.5.44 主从复制配置注：mysql从5.1.7以后开始就不支持my.cnf中“master-host”类似的参数;必须在slave 的mysql中执行以下命令(最后的pos没有引号)：mysql> change master to master_host='192.168.137.100', master_user='tongbu',master_password='123...
mysql主从同步报错Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ...
weixin_33857679的博客
01-14 1097
问题：在mysql主从同步的过程中检查主从同步状态时IO线程报错Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.解决：...
Mysql主从架构报错-Fatal error: The slave I/O thread stops because master and slave have equal MySQL server
co1590的博客
09-08 7613
在搭建Mysql主从架构过程中，由于从服务器是克隆的主服务器系统，导致主从mysql uuid相同， Slave_IO无法启动，报错如下： The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work. 解决办法，修改其中一台服务器的server-uuid，并保证server-uuid的格式正确
故障案例：主从同步报错Fatal error: The slave I/O thread stops because master and slave have equal MySQL server
热门推荐
cug_jiang126com的专栏
07-11 3万+
场景一：因为数据量非常，大概有1.4T，需要在原先master1-slave1的情况下再创建一个库slave2，并且挂在slave1下，即master1-slave1-slave2的结构。为了方便，当时停掉从库salve1，show master status记录状态，开启log_slave_updates，并且关闭salve1，然后将这个从库的data文件夹直接copy到新的从库，结果在创建sl
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs；
dsl
07-15 5496
看了这位大神的博客：https://blog.youkuaiyun.com/sunbocong/article/details/81634296解决的。 在centos7上做5.7版本的Mysql主从复制时，从机用的是直接Linux一台服务器的克隆，然后进行主从复制，报了如下的错 解决 过程 1。退出mysql，分别在两台centos服务器上查看是否mysql的server_uuid是否相同【因为是克隆，肯定相同】 [admin@localhost ~]$ su -...
master and slave have equal MySQL server UUIDs 解决方法
12-15
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work. 首先检查：mysql> show variables like ‘server_id...
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these
阳光大男孩！！！的博客
02-28 2363
mysql主从配置出现上述错误，意思是server_id 不同。 检查 使用show variables like 'server_id'; 命令查看主从数据库的server_id 是否都一样 解决办法 使用set global server_id 命令设置从数据库的server_id为别的值 ...
master and slave have equal MySQL server ids
09-10
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs;
zhouzhiwengang的专栏
02-18 1230
启动MyCat ,查看MycCat 的状态信息： 第一步：进入mycat 安装目录（/usr/local/mycat）,启动mycat,查看mycat 状态： [root@localhost ~]# cd /usr/local/mycat [root@localhost mycat]# cd bin [root@localhost bin]# ./mycat start Starting My...
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs
找不到路径
05-22 1068
show slave status\G 发现有下面报错，导致复制起不来 … Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_Do_DB: … Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 1593 Last_IO_Error: Fatal error: The slave I/O thread stops because master and s.
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL ser
mengnf的专栏
01-19 3680
配置mysql主从模式完毕后 show slave status\G; 查看slave配置中出错：Slave_IO_Running: No
mysql equal_master and slave have equal MySQL server ids
weixin_35797090的博客
01-20 635
蚊子今天下午搭了一主三从的mysql复制，结果所有服务器都配置好后，发现从上报如下的错误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 ...
mysql server ids_master and slave have equal MySQL server ids
weixin_35926197的博客
01-27 564
看到一网友在群里发的mysql从库无法进行同步，查看状态，报如下错误：Slave_IO_Running: NoSlave_SQL_Running: YesLast_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must...
故障案例：主从同步报错Fatal error: The slave I/O thread stops because master and slave have equal MySQL server...
weixin_30641999的博客
02-04 462
https://blog.youkuaiyun.com/cug_jiang126com/article/details/46846031 转载于:https://www.cnblogs.com/a1304908180/p/10351932.html
这个提示是什么意思？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).
最新发布
06-30
当MySQL主从复制出现错误`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`时，根本原因是*...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值