ITPub博客

首页 > 数据库 > MySQL > 5.6.25 MySql主从 Tmaster and slave have equal MySQL srver UUIDs;

5.6.25 MySql主从 Tmaster and slave have equal MySQL srver UUIDs;

MySQL 作者:urgel_babay 时间:2016-02-29 16:54:59 0 删除 编辑
2015.07.25<br /> <br /> 之前再做5.6.25主从测试搭建的时候,我是直接把主上面的mysql 目录打包,传到从机上面,然后现在从机show slave status\G; 查看是出现这个报错<br /> <strong><span style="color:#E53333;">Last_IO_Error : Fatal error : The slave I/O thread stops because master and slave have equal MySQL srver UUIDs; these UUIDs must be different for replication to work.</span></strong><br /> <br /> 解决办法:<br /> &nbsp; &nbsp; 修改从机的UUIDs<br /> <div> <div class="codeheads"> <p> 点击(<span style="cursor:pointer;color:red;" onclick="code_hide('code409')">此处</span>)折叠或打开 </p> </div> <div id="code409" class="codeText"> <ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css"> <li> <span style="color:#000000;"><span style="color:#0000CC;">[</span>root<span style="color:#0000FF;">@</span><span style="color:#008080;">slave</span> mysql<span style="color:#0000CC;">]</span><span style="color:#0000CC;">#</span> cat auto<span style="color:#0000CC;">.</span>cnf <br /> </span> </li> <li> <span style="color:#0000CC;">[</span>auto<span style="color:#0000CC;">]</span><br /> </li> <li> server-<span style="color:#FF0000;">uuid</span><span style="color:#0000CC;">=</span>1e0857ac-2b80-11e5-a92f-080027773<strong><span style="color:#E53333;">1</span></strong>db <span style="color:#006600;">#这是原来主的文件,</span><br /> </li> <li> <span style="color:#0000CC;">[</span>root<span style="color:#0000FF;">@</span><span style="color:#008080;">slave</span> mysql<span style="color:#0000CC;">]</span><span style="color:#0000CC;">#</span> vi auto<span style="color:#0000CC;">.</span>cnf <br /> </li> <li> <span style="color:#0000CC;">[</span>auto<span style="color:#0000CC;">]</span><br /> </li> <li> server-<span style="color:#FF0000;">uuid</span><span style="color:#0000CC;">=</span>1e0857ac-2b80-11e5-a92f-080027773<strong><span style="color:#E53333;">2</span></strong>db <span style="color:#006600;"># 随便修改一下</span> </li> </ol> </div> </div> &nbsp;随便修改从机上面的,只要跟主机的不一样就可以了

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30936525/viewspace-2016539/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2016-02-29

  • 博文量
    203
  • 访问量
    339118