FreeABC
记忆重叠

ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository完美解决

mysql> start slave
-> ;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository

 

mysql 启动从 失败

 

解决方法:

mysql>reset slave;

 

然后重新 指定主服务信息,重启启动从即可

 

 

从同步失败 之后,处理办法

到主上查看

mysql> show master status \G
*************************** 1. row ***************************
File: mysql-bin-master.000009
Position: 154
Binlog_Do_DB:
Binlog_Ignore_DB: mysql,information_schema,performance_schema
Executed_Gtid_Set:
1 row in set (0.00 sec)

 

然后从上执行

change master to master_host=’192.168.1.222′,master_user=’slave’,master_password=’123456′;
change master to master_host=’192.168.1.222′,master_port= 3306, master_bind=”, master_user=’slave’,master_password=’123456′;

change master to master_log_file=’mysql-bin-master.000009‘, master_log_pos=154;

start    slave;

 

mysql> show slave status \G

-********关注下面两行情况是否都是yes*********-

Slave_IO_Running: Yes
Slave_SQL_Running: Yes

-*****************-

未经允许不得转载:Free-Abc智能 » ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository完美解决
分享到: 更多 (0)