- 论坛徽章:
- 8
|
目前本人正在学习lvs + keepalived +MySQL高可用架构,还尚未开始安装keepalived,只是配置好了lvs和mysql,详细步骤如下所示(实验环境均为虚拟机):
实验环境:
操作系统均为CentOS6.7
虚拟IP:192.168.1.100
调度机:192.168.1.11
MySQL-Real Server 1:192.168.1.111
MySQL-Real Server 2:192.168.1.112
在调度机上绑定IP:
ifconfig eth1:0 192.168.1.100
调度机上安装:
[root@host11 ~]#yum install -y ipvsadm
[root@host11 ~]#ipvsadm -A -t 192.168.1.100:3306 -s rr
[root@host11 ~]#ipvsadm -a -t 192.168.1.100:3306 -r 192.168.1.111:3306 -g
[root@host11 ~]#ipvsadm -a -t 192.168.1.100:3306 -r 192.168.1.112:3306 –g
[root@host11 ~]#service ipvsadm save
ipvsadm: Saving IPVS table to /etc/sysconfig/ipvsadm: [确定]
[root@host11 ~]# ipvsadm -Ln
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddressort Scheduler Flags
-> RemoteAddressort Forward Weight ActiveConn InActConn
TCP 192.168.1.100:3306 rr
-> 192.168.1.111:3306 Route 1 0 0
-> 192.168.1.112:3306 Route 1 0 0
[root@host11 ~]# ifconfig eth1:0 192.168.1.100
在两个real server上分别执行:
ifconfig lo:100 192.168.1.100 netmask 255.255.255.255
echo "1" >/proc/sys/net/ipv4/conf/lo/arp_ignore
echo "2" >/proc/sys/net/ipv4/conf/lo/arp_announce
echo "1" >/proc/sys/net/ipv4/conf/all/arp_ignore
echo "2" >/proc/sys/net/ipv4/conf/all/arp_announce
在两个real server上分别授予权限:
mysql> grant all privileges on *.* to 'root'@'192.168.1.100' identified by '';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
出现的问题:
在另外一台机器上(不是调度机和真实服务器)执行:
[root@host188 ~]# mysql -uroot -p -P 3306 -h192.168.1.100 -e "show variables like 'server_id'";
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'192.168.1.100' (using password: NO)
提示说没有权限。可上面红字部分明明是授予权限了啊。
本人初学,无法找到原因,哪位高人麻烦指点一下,谢谢!
|
|