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 />
修改从机的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>
随便修改从机上面的,只要跟主机的不一样就可以了
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30936525/viewspace-2016539/
,如需转载,请注明出处,否则将追究法律责任。