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

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;隨便修改從機上面的，只要跟主機的不一樣就可以了