mysql> select * from worker; +------+------+----------+--------+-------+ | nid | name | address | salary | level | +------+------+----------+--------+-------+ | 100 | tom | beijing | 2000 | 0 | | 101 | jim | shanghai | 2000 | 1 | | 102 | mali | shanghai | 3000 | 2 | +------+------+----------+--------+-------+ 3 rows in set (0.00 sec)
mysql> delete from woker where nid = 100; ERROR 1146 (42S02): Table 'company.woker' doesn't exist mysql> delete from worker where nid = 100; Query OK, 1 row affected (0.07 sec)
mysql> select * from worker; +------+------+----------+--------+-------+ | nid | name | address | salary | level | +------+------+----------+--------+-------+ | 101 | jim | shanghai | 2000 | 1 | | 102 | mali | shanghai | 3000 | 2 | +------+------+----------+--------+-------+ 2 rows in set (0.00 sec)
本文描述了mysql-cluster集群sql节点高可用keepalived的故障处理过程,包括故障发生时间、故障描述、故障分析等内容。根据keepalived的日志分析,发现bogus VRRP packet received on eth0 !!!等错误信息,进而导致vip地址失效,使得mysql-cluster的api无法访问。针对这个问题,本文提供了相应的解决方案。 ...
[详细]