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故障一例MySql
- Mysql slave 延遲故障一列MySql
- mysql master和slave配置MySqlAST
- MySQL 5.5 Master/Slave 配置MySqlAST
- 故障分析 | MySQL : slave_compressed_protocol 導致 crashMySqlProtocol
- MYSQL的master/slave資料同步配置(轉)MySqlAST
- 處理MySQL複製環境Slave故障的一個案例MySql
- MySQL master/slaveMySqlAST
- MySQL新建SlaveMySql
- Mysql Master-slave複製簡單配置記錄MySqlAST
- MYSQL5的master slave資料同步配置(轉)MySqlAST
- 故障案例:主從同步報錯Fatal error: The slave I/O thread stops because master and slave have equal MySQL server主從同步ErrorthreadASTMySqlServer
- MySql的Master/SlaveMySqlAST
- 【MySQL】Server-id導致Slave_IO_Running: No主從複製故障MySqlServer
- MySQL 5.5.x 配置Master-Slave主從複製MySqlAST
- MySQL主從複製配置引數 -- logs-slave-updatesMySql
- Linux環境下MySQL5.6Master-Slave配置實戰LinuxMySqlAST
- mysql slave錯誤skipMySql
- MySQL Master/Slave Master/MasterMySqlAST
- mysql slave 轉為 masterMySqlAST
- mysql slave-skip-errorsMySqlError
- keepalive配置mysql自動故障轉移MySql
- mysql master slave 主從同步MySqlAST主從同步
- mysql 同步 master-slave薦MySqlAST
- Mysql Slave群切換MasterMySqlAST
- Mysql Slave群切換Master (=)MySqlAST
- Slave_SQL_Running:Nomysql同步故障解決方法MySql
- MySQL master and slave have equal MySQL server UUIDsMySqlASTServerUI
- MySQL錯誤之mysql.slave_master_infoMySqlAST
- MySQL Slave異常關機的處理 (pt-slave-restart)MySqlREST
- 【MySQL】Slave can not handle replication events with the checksum ...MySql
- mysql slave 損害一例MySql
- kkjcre1p: unable to spawn jobq slave process故障處理
- MySQL複製跳過錯誤--slave_skip_errors、sql_slave_skip_counter、slave_exec_modeMySqlError
- 使用etcd選舉sdk實踐master/slave故障轉移AST
- MYSQL Slave開機啟動指令碼MySql指令碼
- MySQL Slave延遲很大優化方法MySql優化
- mysql多執行緒slave的演化MySql執行緒