MYSQL 配置slave故障
之前為主從配置,後來分割成2個單例項。
現在環境需要,重新配置為主從,之前引數都已配置好,直接啟動,如下:
mysql> change master to master_host='192.168.12.193',master_port=3306,master_user='master',master_password='123456',master_log_file='master-bin.000569',master_log_pos=107;
ERROR 29 (HY000): File './slave-relay-bin.000494' not found (Errcode: 2)
mysql>reset slave; 也不行
檢視報錯日誌:
131210 10:56:44 [ERROR] Failed to open the relay log './slave-relay-bin.000494' (relay_log_pos 591818895)
131210 10:56:44 [ERROR] Could not find target log during relay log initialization
131210 10:56:44 [ERROR] Failed to initialize the master info structure
[root@b28-12195 data]# rm -rf master.info relay-log.info slave-relay-bin.*
mysql> change master to master_host='192.168.12.193',master_port=3306,master_user='master',master_password='123456',master_log_file='master-bin.000569',master_log_pos=107;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.12.193
Master_User: master
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-bin.000572
Read_Master_Log_Pos: 107
Relay_Log_File: slave-relay-bin.000002
Relay_Log_Pos: 254
Relay_Master_Log_File: master-bin.000572
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB: test
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 107
Relay_Log_Space: 410
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
1 row in set (0.00 sec)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28939273/viewspace-1063372/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 故障分析 | MySQL : slave_compressed_protocol 導致 crashMySqlProtocol
- 故障案例:主從同步報錯Fatal error: The slave I/O thread stops because master and slave have equal MySQL server主從同步ErrorthreadASTMySqlServer
- Mysql Master-slave複製簡單配置記錄MySqlAST
- MySQL主從複製配置引數 -- logs-slave-updatesMySql
- The slave I/O thread stops because master and slave have equal MySQL server UUIDthreadASTMySqlServerUI
- MySQL複製跳過錯誤--slave_skip_errors、sql_slave_skip_counter、slave_exec_modeMySqlError
- 使用etcd選舉sdk實踐master/slave故障轉移AST
- MYSQL Slave開機啟動指令碼MySql指令碼
- [MySQL進階之路][No.0002] SHOW SLAVE STATUSMySql
- Mysql 5.6 Master和Slave 主備切換MySqlAST
- MySQL複製命令slave被REPLICA命令取代MySql
- CentOS中MySQL5.6 資料庫主從(Master/Slave)同步安裝與配置詳解CentOSMySql資料庫AST
- 從Mysql slave system lock延遲說開去MySql
- MySQL:關於Wating for Slave workers to free pending events等待MySql
- zabbix應用-監控mysql slave 主從狀態MySql
- MySQL中slave監控的延遲情況分析MySql
- 如何配置並排除 GRUB故障
- MySQL報錯Slave: received end packet from server, apparent master shutdownMySqlServerAPPAST
- 【MySQL】六、常見slave 延遲原因以及解決方法MySql
- Mysqldump實現mysql的master-slave主從複製MySqlAST
- mysql slave 跟進 master 的關鍵狀態指標MySqlAST指標
- MySQL show processlist故障處理MySql
- MySQL:show slave status 關鍵值和MGRrelay log的清理策略MySql
- mysql同步問題之Slave延遲很大最佳化方法MySql
- Mysql 建立心跳錶來監控Replication的Slave是否延遲MySql
- Mysql MHA部署-05故障轉移MySql
- MySQL資料庫故障恢復MySql資料庫
- 故障分析 | MySQL死鎖案例分析MySql
- MySQL主從複製中的“show slave status”詳細含義MySql
- Innobackupex實現mysql線上搭建master-slave主從複製MySqlAST
- MHA高可用配置及故障切換
- mysql配置MySql
- MySQ 資料庫主從同步安裝與配置詳解(Master/Slave)資料庫主從同步AST
- jenkins 動態 slaveJenkins
- slave-skip-errorsError
- MySQL [ERROR] Slave I/O: Found a Gtid_log_event or Previous_gtids_log_eventMySqlError
- MySQL:slave_skip_errors引數對MGR可用性的影響MySqlError
- MySQL 關於slave端Retrieved_Gtid_Set的讀取改進初探MySql
- 故障分析 | MySQL 從機故障重啟後主從同步報錯案例分析MySql主從同步