MySQL master and slave have equal MySQL server UUIDs
今天從一個slave備份出來資料，想再建立一個slave，啟動後報錯：
- Last_IO_Error: 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.
錯誤原因是直接備份的slave檔案，導致uuid相同了，uuid是MySQL5.6引入的機制，必須在主從之間不一致
解決辦法就是，刪除data下的auto.cnf檔案，重啟資料庫。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/20893244/viewspace-2138142/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- master and slave have equal MySQL server UUIDs問題解決ASTMySqlServerUI
- 5.6.25 MySql主從 Tmaster and slave have equal MySQL srver UUIDs;MySqlASTUI
- The slave I/O thread stops because master and slave have equal MySQL server UUIDthreadASTMySqlServerUI
- 故障案例：主從同步報錯Fatal error: The slave I/O thread stops because master and slave have equal MySQL server主從同步ErrorthreadASTMySqlServer
- MySQL Master/Slave Master/MasterMySqlAST
- MySQL master/slaveMySqlAST
- MySql的Master/SlaveMySqlAST
- mysql master和slave配置MySqlAST
- mysql slave 轉為 masterMySqlAST
- MySQL 5.5 Master/Slave 配置MySqlAST
- mysql master slave 主從同步MySqlAST主從同步
- mysql 同步 master-slave薦MySqlAST
- Mysql Slave群切換MasterMySqlAST
- Mysql Slave群切換Master （=）MySqlAST
- MySQL錯誤之mysql.slave_master_infoMySqlAST
- MySQL報錯Slave: received end packet from server, apparent master shutdownMySqlServerAPPAST
- mysql建立master/slave詳細步驟MySqlAST
- 利用mysql slave 修復master MyISAM tableMySqlAST
- Mysql 5.6 Master和Slave 主備切換MySqlAST
- MYSQL的master/slave資料同步配置(轉)MySqlAST
- Mysql Master-slave複製簡單配置記錄MySqlAST
- mysql master-slave複製錯誤［解決事例］MySqlAST
- MYSQL5的master slave資料同步配置(轉)MySqlAST
- mysql slave 跟進 master 的關鍵狀態指標MySqlAST指標
- Mysqldump實現mysql的master-slave主從複製MySqlAST
- MySQL 5.5.x 配置Master-Slave主從複製MySqlAST
- Innobackupex實現mysql線上搭建master-slave主從複製MySqlAST
- Linux環境下MySQL5.6Master-Slave配置實戰LinuxMySqlAST
- MySQL新建SlaveMySql
- Redis master and slaveRedisAST
- MYSQL5.7 MASTER-SLAVE 線上關閉和啟動GTIDMySqlAST
- MYSQL 配置slave故障MySql
- Slave: received 0 length packet from server, apparent master shutdownServerAPPAST
- 【Mysql】Slave_IO_Running: No---Got fatal error 1236 from masterMySqlGoErrorAST
- mysql5.6，master/slave架構，master，不寫bingo原因，無法開啟同步複製MySqlAST架構Go
- Mysql5.6 Master+MasterMySqlAST
- Mysql cluster slave server的自動檢測與修復MySqlServer
- MySQL 5.6.19主從server-id不生效，The server is not configured as slaveMySqlServer