使用MHA搭建mysql集群时,在节点执行change master to ***********;
时遇到报错 ERROR 1201 (HY000): Could not initialize master info structure;
(原因:第一次执行change master to***时没找到/var/lib/mysql路径,在vi /etc/my.cnf时写漏了)
经过下列2步操作,问题解决:
1
mysql> slave stop;
Query OK, 0 rows affected, 1 warning (0.00 sec)
2
mysql> reset slave;
Query OK, 0 rows affected,(0.00 sec)
3
mysql> change master to ********;
.......
Query OK, 0 rows affected (0.03 sec)