遇到的問題：Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs;?

解決故障：

###查看auto.cnf文件

[root@dbsrv1 ~] cat /data/mysqldata/auto.cnf? ### 主上的uuid

[auto]

server-uuid=62ee10aa-b1f7-11e4-90ae-080027615026

[root@dbsrv2 ~]# more /data/mysqldata/auto.cnf ###從上的uuid，果然出現(xiàn)了重復(fù)，原因是克隆了虛擬機，只改server_id不行

[auto]

server-uuid=62ee10aa-b1f7-11e4-90ae-080027615026

[root@dbsrv2 ~]# mv /data/mysqldata/auto.cnf? /data/mysqldata/auto.cnf.bk? ###重命名該文件

[root@dbsrv2 ~]# service mysql restart? ? ? ? ? ###重啟mysql

[root@dbsrv2 ~]# more /data/mysqldata/auto.cnf? ###重啟后自動生成新的auto.cnf文件，即新的UUID

[auto]

server-uuid=6ac0fdae-b5d7-11e4-a9f3-0800278ce5c9

###再次查看slave的狀態(tài)已經(jīng)正常

[root@dbsrv1 ~]# mysql -uroot -pxxx -e "show slave status\G"|grep Running

Warning: Using a password on the command line interface can be insecure.

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it