mha检测mysql报错_Mysql MHA部署-07常见问题

Mysql MHA部署-07常见问题

一 Mysql MHA部署-01介绍

二 Mysql MHA部署-02主从复制

三 Mysql MHA部署-03MHA软件安装

四 Mysql MHA部署-04MHA配置

五 Mysql MHA部署-05故障转移

六 Mysql MHA部署-06手动切换

七 Mysql MHA部署-07常见问题

架构说明：

一：从库同步失败

从库执行同步操作：

mysql>

change master to master_host='192.168.2.187', master_user='repl',

master_password='rpl',master_log_file='mysql-bin.000001',

master_log_pos= 34751569;

查看同步状态show slave status \G;

错误如下：

Last_IO_Error: Got fatal error 1236 from master when reading data from binary log:

'Client requested master to start replication from position > file size'

查看主库187file和Position:

mysql> show master status;

+------------------+----------+--------------+------------------+--------------------------------------------+

| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set                          |

+------------------+----------+--------------+------------------+--------------------------------------------+

| mysql-bin.000004 | 34751569 |              |                  | c1227971-65b3-11ea-bf67-080027839e5c:1-297 |

+------------------+----------+--------------+------------------+--------------------------------------------+

1 row in set (0.00 sec)

查看主库end_log_pos也是34751569:

[mysql@rac1 binlog]$ pwd

/datalog/mysql/binlog

[mysql