mysql+keepalived
mysql+keepalived1.安装
# yum install -y openssl-devel popt-devel
# tar zxf keepalived-1.2.8.tar.gz
# cd keepalived-1.2.8
# ./configure --prefix=/usr/local/keepalived
# make && make install
2.将keepalived命令、启动脚本及配置文件复制到相应目录下并启动服务
# which keepalived
/usr/local/sbin/keepalived
# ln -s /usr/local/keepalived/sbin/keepalived /usr/bin/keepalived
# cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d/
# cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig
# /etc/init.d/keepalived start
3.创建配置文件及检测脚本
# vim /etc/keepalived/keepalived.conf
! Configuration File for keepalived
global_defs {
notification_email {
root@localhost
}
notification_email_from keepalived@localhost
smtp_server 127.0.0.1
smtp_connect_timeout 30
router_id LVS_DEVEL
}
vrrp_script check_mysql {
script "/root/check_mysql.sh"
interval 2
weight 2
}
vrrp_instance VI_1 {
state MASTER #mysql2此处改为BACKUP
interface eth1
virtual_router_id 51
priority 100 #mysql此处改为90，或小于100
advert_int 1
authentication {
auth_type PASS
auth_pass 1111
}
track_script {
check_mysql
}
virtual_ipaddress {
192.168.36.200/24 dev eth1
}
}
# check_mysql.sh
MYSQL=/usr/bin/mysql
MYSQL_HOST=localhost
MYSQL_USER=root
MYSQL_PASSWORD=redhat
$MYSQL -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD -e "show status;" >/dev/null 2>&1
#$mysqlclient --host=$host --port=$port --user=$user --password=$password -e "show databases;" > /dev/null 2>&1
if [ $? == 0 ]
then
echo " $host mysql login successfully"
exit 0
else
#echo " $host mysql login faild" #若mysql关闭，则keepalived关闭
/etc/init.d/keepalived stop
exit 2
fi
4.数据库授权远程登录
# mysql -p
mysql> grant all privileges on *.* to 'root'@'%' identified by 'redhat';
mysql> flush privileges;
# mysql -uroot -predhat -h192.168.36.200 #vip登录
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cheungssh |
| discuz |
| mysql |
+--------------------+
4 rows in set (0.03 sec)
mysql> quit
Bye
5.检测
此时vip在mysql1的eth1上，且两端的mysql、keepalived均开启
# ip a
eth1:
inet 192.168.36.160/24 brd 192.168.36.255 scope global eth1
inet 192.168.36.200/24 scope global secondary eth1
# /etc/init.d/mysqld status
mysqld (pid 7219) is running...
# /etc/init.d/keepalived status
keepalived (pid 7248) is running...
MYSQL1端：关闭mysql1的mysql服务，keepalived会自动关闭且vip飘在mysql2上
# /etc/init.d/mysqld stop
Stopping mysqld: [ OK ]
# /etc/init.d/mysqld status
mysqld is stopped
# /etc/init.d/keepalived status
keepalived is stopped
MYSQL2端：查看vip
# ip a
eth1:
inet 192.168.36.161/24 brd 192.168.36.255 scope global eth1
inet 192.168.36.200/24 scope global secondary eth1
MYSQL1端：开启mysql、keepalived服务，vip飘回来
# /etc/init.d/mysqld start
Starting mysqld: [ OK ]
# /etc/init.d/keepalived start
Starting keepalived: [ OK ]
# ip a
2: eth1:
inet 192.168.36.160/24 brd 192.168.36.255 scope global eth1
inet 192.168.36.200/24 scope global secondary eth1
页:
[1]