1. Centos7防火墙导致keepalived无法正常工作
现像:
两台机器都有VIP
解决方法:
Redhat7或CentOS7默认使用的是firewall作为防火墙,没有用过的同学,用起来可能有点吃力,这里教大家改为你所熟悉的iptables防火墙。
关闭firewall:
#systemctlstop firewalld.service //停止firewall
#systemctldisable firewalld.service //禁止firewall开机启动
安装iptables防火墙
#yuminstall iptables-services //安装
#serviceiptables save //保存防火墙配置
#systemctlenable iptables.service //设置防火墙开机启动
2. Haproxy和keepalived无法启用
现象:
system status haproxy
Jun 08 01:58:09 QD-254-28haproxy-systemd-wrapper[769]: [ALERT] 158/015809 (770) : Starting frontend www:cannot bind socket [10.32.254.49:80]
解决方法:
#vi /etc/sysctl.d/99-sysctl.conf
net.ipv4.ip_nonlocal_bind=1
3. Mysql无法启动
现象:
#cat /var/lib/$hostname.err
150606 1:38:48 [Note] /usr/sbin/mysqld (mysqld5.5.43-MariaDB-wsrep) starting as process 43686 ...
15060601:38:48 mysqld_safe WSREP: Failed to recover position:
'150606 1:38:48 InnoDB: The InnoDB memory heap isdisabled
150606 1:38:48 InnoDB: Mutexes and rw_locks use GCCatomic builtins
150606 1:38:48 InnoDB: Compressed tables use zlib1.2.7
150606 1:38:48 InnoDB: Using Linux native AIO
150606 1:38:48 InnoDB: Initializing buffer pool,size = 128.0M
150606 1:38:48 InnoDB: Completed initialization ofbuffer pool
InnoDB: Error: log file./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the.cnf file 0 5242880 bytes!
InnoDB:Possible causes for this error:
(a) Incorrect log file is used or log filesize is changed
(b) In case default size is used this log fileis from 10.0
(c) Log file is corrupted or there was notenough disk space
In case (b) you need to setinnodb_log_file_size = 48M
150606 1:38:48 [ERROR] Plugin 'InnoDB' init functionreturned error.
150606 1:38:48 [ERROR] Plugin 'InnoDB' registrationas a STORAGE ENGINE failed.
150606 1:38:48 [Note] Plugin 'FEEDBACK' is disabled.
150606 1:38:48 [ERROR] Unknown/unsupported storageengine: InnoDB
150606 1:38:48 [ERROR] Aborting
解决方法:
1) rm –rf /var/lib/mysql/ib_logfile*
2) systemctl start mysql.service
4. 主和备节点都启用了mysql,但无法同步复制
现象:
1) 按照官方正确配置了/etc/my.cnf.d/server.cnf
2) Netstat –antlp没有4567端口
解决方法:
确认/etc/my.cnf中的内容为:
[client-server]
#
# include allfiles from the config directory
#
!includedir /etc/my.cnf.d