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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 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報錯Slave: received end packet from server, apparent master shutdownMySqlServerAPPAST
- Mysql 5.6 Master和Slave 主備切換MySqlAST
- Mysql Master-slave複製簡單配置記錄MySqlAST
- Mysqldump實現mysql的master-slave主從複製MySqlAST
- mysql slave 跟進 master 的關鍵狀態指標MySqlAST指標
- Innobackupex實現mysql線上搭建master-slave主從複製MySqlAST
- CentOS中MySQL5.6 資料庫主從(Master/Slave)同步安裝與配置詳解CentOSMySql資料庫AST
- 錯誤內容:You have an error in your SQL syntax; check the manual that corresponds to your MySQL serverErrorMySqlServer
- Setup MariaDB Master/Slave Replication for Docker MariaDBASTDocker
- MySQL:Lost connection to MySQL server at 'readingMySqlServer
- MYSQL Slave開機啟動指令碼MySql指令碼
- mysql MASTER_POS_WAIT函式MySqlASTAI函式
- MySQL複製命令slave被REPLICA命令取代MySql
- [MySQL進階之路][No.0002] SHOW SLAVE STATUSMySql
- MySQL5.7 Master-Master主主搭建for Centos7MySqlASTCentOS
- MySQL 2003 - Can’t connect to MySQL server on (10060)MySqlServer
- MySQL-1130-host ... is not allowed to connect to this MySql serverMySqlServer
- MySQL複製跳過錯誤--slave_skip_errors、sql_slave_skip_counter、slave_exec_modeMySqlError
- MySQL Server Startup ScriptMySqlServer
- Mysql修改server uuidMySqlServerUI
- 故障分析 | MySQL : slave_compressed_protocol 導致 crashMySqlProtocol
- MySQL:關於Wating for Slave workers to free pending events等待MySql
- 從Mysql slave system lock延遲說開去MySql
- mysql關於mysql.server的總結MySqlServer
- MySQL Server架構概述MySqlServer架構
- MySQL client server 協議MySqlclientServer協議
- MySQL server has gone awayMySqlServerGo
- 資料庫讀寫分離Master-Slave資料庫AST
- MySQL5.7 Unable to find a match: MySQL-community-serverMySqlUnityServer
- zabbix應用-監控mysql slave 主從狀態MySql
- MySQL中slave監控的延遲情況分析MySql
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- 上手MySQL之解決問題:not allowed to connect to this MySQL serverMySqlServer
- MYSQL The Server Shutdown Process(筆記)MySqlServer筆記
- “Host ‘xxxx‘ is not allowed to connect to this MySQL server“MySqlServer
- SQL Server建立dblink至MySQLServerMySql
- Host 'localhost' is not allowed to connect to this MySQL serverlocalhostMySqlServer