今天搭建mysql5.0主从复制报个错
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).
使用show variables like 'server_id'; 查看,主从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).
使用show variables like 'server_id'; 查看,主从server_id设置明显是不一样的,各位帮忙看下是啥原因
解决方案 »
- 关于事件特定时间自动记录 问题,延续~~~~
- oracle中的decode函数,如何在mysql中用自定义函数实现
- 链接MySQL读取数据,中文都变成乱码了?
- 问题求助!
- MySql的存储过程怎么来写
- Fatal error: Maximum execution time of 30 seconds exceeded in E:\export\home\wwwroot\enspc\spc\searchresults.php on line 125
- 向高手们请教一个SQL语句!
- mysql占用CPU百分百
- 求Mysql大神 帮我看看 这个语句 怎么优化
- 安装MySql时弹出 无法定位程序输入点fasetround于动态链接库 MSVCR120.dll上 提示框
- mysql 结果集问题
- 如何同时执行多个sql查询语句
现在是怎么配置的,my.cnf或my.ini里手动指定一个server-id呢?
[mysqld]
server-id=1
log-bin=mysql-binSlave的配置与master类似:
[mysqld]
server-id = 2master,Slave配置后需要重启mysql服务service mysql restart