mysql中做主從複製時的錯誤

標籤：different   because   thread   伺服器   master   

1.mysql主從配置 Slave I/O: Fatal error: The slave I/O thread stops 2013-10-09 12:37:33

分類： LINUX

 Slave I/O: 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. Error_code: 1593

按照網上的教程來做主從同步
結果複製的時候 我把整個data檔案夾一起複製過去了
導致了 data/auto.cnf 檔案一樣
anco.cnf裡面記錄的server-id也一樣 把從伺服器的data/auto.cnf刪除 重啟服務 同步成功

2.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).
查看server-id
mysql> show variables like ‘server_id‘;
手動修改server-id
mysql> set global server_id=2; #此處的數值和my.cnf裡設定的一樣就行
mysql> slave start;

同時需要刪除安裝在/usr/local/mysql下的my.cnf刪除。

mysql中做主從複製時的錯誤