主从切换失败问题

Question

老师，您好。
我搭建了一个 一主二从的MHA集群，master,slave1,slave2,主从切换的时候失败了。此时slave2的master_host以切换为slave1的ip。但是查看slave1的 show slave status 时发现它的master_host还是原来的master的ip.
以下是slave2的 错误信息

		Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 13114
                Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Cannot replicate because the master purged required binary logs. Replicate the missing transactions from elsewhere, or provision a new slave from backup. Consider increasing the master's binary log expiration period. To find the missing transactions, see the master's error log or the manual for GTID_SUBTRACT.'
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 1008
                  Master_UUID: 500a5f39-237a-11ee-bedf-000c29dd657a
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind: 
      Last_IO_Error_Timestamp: 230719 00:25:12
     Last_SQL_Error_Timestamp: 
               Master_SSL_Crl: 
           Master_SSL_Crlpath: 
           Retrieved_Gtid_Set: 
            Executed_Gtid_Set: 36081d77-219f-11ee-8604-08002706c077:1,
aa758a8a-2335-11ee-a0b9-080027f097ad:1-25
                Auto_Position: 1
         Replicate_Rewrite_DB: 
                 Channel_Name: 
           Master_TLS_Version: 
       Master_public_key_path: 
        Get_master_public_key: 0

以下是mha的报错日志

Mon Jul 24 20:04:29 2023 - [info] -- Slave recovery on host 192.168.2.109(192.168.2.109:3306) started, pid: 30238. Check tmp log /home/mha/192.168.2.109_3306_20230724200423.log if it takes time..
Mon Jul 24 20:14:34 2023 - [error][/usr/share/perl5/vendor_perl/MHA/Server.pm, ln789] Slave could not be started on 192.168.2.109(192.168.2.109:3306)! Check slave status.
Mon Jul 24 20:14:35 2023 - [info]
Mon Jul 24 20:14:35 2023 - [info] Log messages from 192.168.2.109 ...
Mon Jul 24 20:14:35 2023 - [info]
Mon Jul 24 20:04:29 2023 - [info]  Resetting slave 192.168.2.109(192.168.2.109:3306) and starting replication from the new master 192.168.2.108(192.168.2.108:3306)..
Mon Jul 24 20:04:29 2023 - [info]  Executed CHANGE MASTER. 
Mon Jul 24 20:14:34 2023 - [error][/usr/share/perl5/vendor_perl/MHA/Server.pm, ln867] Starting slave IO/SQL thread on 192.168.2.109(192.168.2.109:3306) failed!
Mon Jul 24 20:14:35 2023 - [info] End of log messages from 192.168.2.109.
Mon Jul 24 20:14:35 2023 - [error][/usr/share/perl5/vendor_perl/MHA/MasterFailover.pm, ln2022] Master failover to 192.168.2.108(192.168.2.108:3306) done, but recovery on slave partially failed.
Mon Jul 24 20:14:35 2023 - [info]

----- Failover Report -----

mysql-mha: MySQL Master failover 192.168.2.103(192.168.2.103:3306) to 192.168.2.108(192.168.2.108:3306)

Master 192.168.2.103(192.168.2.103:3306) is down!

Check MHA Manager logs at 192.168.2.81:/home/mha/manager.log for details.

Started automated(non-interactive) failover.
Invalidated master IP address on 192.168.2.103(192.168.2.103:3306)
Selected 192.168.2.108(192.168.2.108:3306) as a new master.
192.168.2.108(192.168.2.108:3306): OK: Applying all logs succeeded.
192.168.2.108(192.168.2.108:3306): OK: Activated master IP address.
192.168.2.109(192.168.2.109:3306): ERROR: Starting slave failed.
Master failover to 192.168.2.108(192.168.2.108:3306) done, but recovery on slave partially failed.Master failover to 192.168.2.108(192.168.2.108:3306) done, but recovery on slave partially failed.

Answer 1

Moody 2023-07-25 10:10:09

我看slave2是192.168.2.109？

具体master是从哪个ip转移到哪个IP了呀？

• 提问者 慕后端4419857 #1

  master是 2.103，转移到了slave1 ip是2.108。slave2是2.109

• Moody 回复 提问者 慕后端4419857 #2

  是怎么做的切换呢？直接杀掉了master？

• Moody 回复 提问者 慕后端4419857 #3

  看log的话有可能是数据没有来得及在slave2上重放，slave2没有追到数据，master上的binlog被干掉了

点开查看后面2条评论