Mysql +MHA+LVS+KEEPALIVED高可用，读写分离，负载均衡搭建(学习笔记十八)

2021-07-01 03:08:27

IP 主机名角色 MHA 角色

172.16.54.226 MySQL-15.11 MySQL Master 主 Masterha-node

172.16.54.227 MySQL-15.12 MySQL Slave1从1 Masterha-node

172.16.54.228 MySQL-15.13 MySQL Slave2从2 Masterha-node

172.16.54.230 MySQL-15.14 MySQL Slave3从3 Masterha-node

172.16.54.231 Lvs-15.23 Lvs主 Masterha-manager

172.16.54.232 Lvs-15.24 Lvs 从 Masterha-manager

MySQL写的VIP：172.16.54.251

MySQL读的VIP：172.16.54.252

172.16.54.226-230: yum install -y cmake

wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz

tar zxvf mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz

mv mysql-5.6.36-linux-glibc2.5-x86_64 /usr/local/mysql

groupadd mysql

useradd -g mysql mysql

chown -R mysql.mysql /usr/local/mysql

cd /usr/local/mysql/scripts

./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/data &

mkdir -p /data/log /data/tmp /data/data /var/run/mysql /usr/local/mysql

yum install -y gcc gcc++ git gcc-c++ ncurses-devel cmake libaio bison

echo "/usr/local/mysql/lib" >> /etc/ld.so.conf.d/mysql.conf

ldconfig

226，mysql主：vi /etc/my.cnf

[client]

socket=/var/run/mysql/mysql.sock

[mysqld]

user=mysql

pid-file=/var/run/mysql/mysqld.pid

socket=/var/run/mysql/mysql.sock

basedir=/usr/local/mysql

datadir=/data/data

tmpdir=/data/tmp

server-id=1 #每个MySQL server的此选项都必须唯一

###begin innodb settiong###

innodb_file_per_table=1

innodb_lock_wait_timeout=500

innodb_buffer_pool_size=512M

###end innodb setting###

###key buffer size set###

key-buffer-size=10M

sort_buffer_size=10M

###key buffer size set###

###begin bin log###

log-bin=/data/log/log

expire-logs-days=90

###end bin log###

###begin general log###

#general_log=1

#general_log_file=/data/log/record.log

###end general log###

###begin error log###

log_error=/data/log/error.log

###end error log###

###begin skip name resolve###

skip_name_resolve=1

###end skip name resolve###

###being slow query log###

slow_query_log=1

long_query_time=0.1

slow_query_log_file=/data/log/slow.log

###end slow query log###

###begin replication config###

read_only=0 #MySQL主，此选项设为0，MySQL从，此选项设为1

relay_log_purge=0

replicate_wild_ignore_table=information_schema.%

replicate_wild_ignore_table=performance_schema.%

#rpl_semi_sync_slave_enabled=1

#rpl_semi_sync_master_enabled=1

#rpl_semi_sync_master_timeout=1000 # 1 second

###end replication config###

227-230，从：#/etc/my.cnf

[client]

socket=/var/run/mysql/mysql.sock

[mysqld]

user=mysql

pid-file=/var/run/mysql/mysqld.pid

socket=/var/run/mysql/mysql.sock

basedir=/usr/local/mysql

datadir=/data/data

tmpdir=/data/tmp

server-id=2 #每个MySQL server的此选项都必须唯一

###begin innodb settiong###

innodb_file_per_table=1

innodb_lock_wait_timeout=500

innodb_buffer_pool_size=512M

###end innodb setting###

###key buffer size set###

key-buffer-size=10M

sort_buffer_size=10M

###key buffer size set###

###begin bin log###

log-bin=/data/log/log

expire-logs-days=90

###end bin log###

###begin general log###

#general_log=1

#general_log_file=/data/log/record.log

###end general log###

###begin error log###

log_error=/data/log/error.log

###end error log###

###begin skip name resolve###

skip_name_resolve=1

###end skip name resolve###

###being slow query log###

slow_query_log=1

long_query_time=0.1

slow_query_log_file=/data/log/slow.log

###end slow query log###

###begin replication config###

read_only=1 #MySQL主，此选项设为0，MySQL从，此选项设为1

relay_log_purge=0

replicate_wild_ignore_table=information_schema.%

replicate_wild_ignore_table=performance_schema.%

#rpl_semi_sync_slave_enabled=1

#rpl_semi_sync_master_enabled=1

#rpl_semi_sync_master_timeout=1000 # 1 second

###end replication config###

226-230:

yum install -y perl-Module-Install.noarch

touch /data/log/error.log

chown -R mysql.mysql /data/log/error.log

chown -R mysql.mysql /data/log/

cd /usr/local/mysql/scripts

./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/data --no-defaults &

echo 'export PATH=/usr/local/mysql/bin:$PATH'>>/etc/profile

source /etc/profile

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

chkconfig mysqld on

/etc/init.d/mysqld start

#删除无用账号，设置root密码

mysql -e "delete from mysql.user where user=' ';delete from mysql.user where user='';flush privileges;

mysqladmin -u root password "123456"

#创建复制账号

create user repl@'172.16.54.%' identified by '123456';

grant replication slave on *.* to repl@'172.16.54%' ;

flush privileges;

#创建MHA管理账号

create user mha_manager@'172.16.54.%' identified by '123456';

grant all on *.* to mha_manager@'172.16.54.%';

flush privileges;

#半同步复制

#2.8.1安装相关插件

mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';

mysql>INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';

#2.8.2配置相关参数#将前文提及的相关选项取消注释

/bin/sed -i 's/#rpl_semi/rpl_semi/p' /etc/my.cnf

#重启mysqld，使配置生效

/etc/init.d/mysqld restart

#设置主从复制

#主226：mysql -uroot -p123456 -e "show master status;"

#从226-230：mysql -uroot -p123456 -e "change master to master_host='172.16.54.226', master_user='repl', master_password='123456', master_port=36677, master_log_file='log.000003', master_log_pos=394;"

mysql -uroot -p123456 -e "start slave;"

mysql -uroot -p123456 -e "show slave status\G"

#MHA下载地址：https://github.com/yoshinorim/mha4mysql-node

#226-230，安装MHA:

yum install -y perl-DBD-MySQL cpan perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker perl-ExtUtils-Embed

cpan ExtUtils::Install

cpan Module::Install

yum install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

unzip mha4mysql-node-master.zip

mv mha4mysql-node-master /usr/local/

cd /usr/local/mha4mysql-node-master/

perl Makefile.PL

make&&make install

231-232：安装LVS：

yum install -y ipvsadm

yum install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

yum install -y perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager perl-Time-HiRes cpanperl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker perl-ExtUtils-Embed

cpan ExtUtils::Install

cpan Module::Install

unzip mha4mysql-node-master.zip

unzip mha4mysql-manager-master.zip

mv mha4mysql-node-master /usr/local/

mv mha4mysql-manager-master /usr/local/

cd /usr/local/mha4mysql-node-master/

perl Makefile.PL

make&&make install

cd /usr/local/mha4mysql-manager-master/

perl Makefile.PL

make&&make install

#配置MHA主231、232：

cat << EOF >> /etc/app1.cnf

[server default]

#mysql user and password

user=mha_manager

password=123456

port=3306

#replication user and password

repl_user=repl

repl_password=123456

#ssh user and port

ssh_user=root

ssh_port=22

#binlog directory

master_binlog_dir=/opt/data/log

#working directory on the manager

manager_workdir=/var/log/masterha/app1

#manager log file

manager_log=/var/log/masterha/app1/app1.log

#working directory on MySQL servers

remote_workdir=/var/log/masterha/app1

#If MySQL command line utilities are installed under a non-standard directory, use this option to set the directory.

client_bindir=/usr/local/mysql/bin

#If MySQL libraries are installed under a non-standard directory, use this option to set the directory.

client_libdir=/usr/local/mysql/lib

#To check by connecting/disconnecting every time, because it's more strict and it can detect TCP connection level failure more quickly.

ping_type=CONNECT

#To fully control the order of priority (i.e. host2->host3->host4..)

latest_priority=0

# IP address failover solution

master_ip_failover_script=/usr/local/scripts/master_ip_failover

#Send a report (i.e. e-mail) when failover has completed or ended with errors

report_script=/usr/local/scripts/send_report

[server-Master1]

hostname=172.16.54.226

candidate_master=

[server-Master2]

hostname=172.16.54.227

candidate_master=1

[server-Slave1]

hostname=172.16.54.228

[server-Slave2]

hostname=172.16.54.230

EOF

#MHA管理,231、232:

mkdir -p /usr/local/scripts/

vi /usr/local/scripts/master_ip_failover

#!/bin/bash

#--------------第一部分:变量及函数定义-----------------#

###Begin Variables define###

ssh_port=22

cmd=/sbin/ifconfig

vip=1

device=eno16777984:0

netmk=255.255.255.0

start_vip="${cmd} ${device} ${vip} netmask ${netmk} up"

stop_vip="${cmd} ${device} ${vip} netmask ${netmk} down"

###End Variables define###

###Begin Status Funciont###

status()

{

exit 0

}

###End Status Funciont###

###Begin Stop Or Stopssh Funciont###

stop()

{

exit 0

}

###End Stop Or Stopssh Funciont###

###Begin Start Funciont###

start()

{

/usr/bin/ssh -p ${ssh_port} ${ssh_user}@${orig_master_host} ""${stop_vip}""

/usr/bin/ssh -p ${ssh_port} ${ssh_user}@${new_master_host} ""${start_vip}""

/usr/bin/ssh -p ${ssh_port} ${ssh_user}@${new_master_host} "/etc/init.d/lvsrs stop"

exit 0

}

###End Start Funciont###

#--------------第一部分:变量及函数定义-----------------#

#--------------第二部分:命令行参数-----------------#

###Begin Get The Command-Line Parameters###

###eval set -- "`getopt -a -q -o n -l command::,ssh_user:,orig_master_host:,orig_master_ip:,orig_master_port:,new_master_host:,new_master_ip:,new_master_port:,new_master_user:,new_master_password: -- "$@"`"

eval set -- "`getopt -a -q -o n -l command::,ssh_user:,orig_master_host:,orig_master_ip:,new_master_host:,new_master_ip: -- "$@"`"

if [ $? != 0 ] ; then echo "Terminating..." >&2 ;exit 1;fi

while true

case "$1" in

--command)

command="${2}";

shift;;

--ssh_user)

ssh_user="${2}";

shift;;

--orig_master_host)

orig_master_host="${2}";

shift;;

--orig_master_ip)

orig_master_ip="${2}";

shift;;

--new_master_host)

new_master_host="${2}";

shift;;

--new_master_ip)

new_master_ip="${2}";

shift;;

--)

shift;

break;;

esac

shift

done

###End Get The Command-Line Parameters###

#--------------第二部分:命令行参数-----------------#

#--------------第三部分:函数调用-----------------#

if [ "${command}" == "status" ];

then

status;

if [ "${command}" == "stop" ] || [ "${command}" == "stopssh" ] ;

then

stop;

if [ "${command}" == "start" ];

then

start;

#--------------第三部分:函数调用-----------------#

vi /usr/local/scripts/send_report

#!/bin/bash

#--------------第一部分:变量及函数定义-----------------#

send_report()

{

echo -e "Orig_master is ${dead_master_host}.\n New_master is ${new_master_host}.\n New_slave_hosts is ${new_slave_hosts}. \n ${body}" | mail -s ${subject} 413379253@qq.com

}

#--------------第一部分:变量及函数定义-----------------#

#--------------第二部分:命令行参数-----------------#

###Begin Get The Command-Line Parameters###

eval set -- "`getopt -a -q -o n -l dead_master_host:,body:,new_slave_hosts:,subject:,new_master_host: -- "$@"`"

if [ $? != 0 ] ; then echo "Terminating..." >&2 ;exit 1;fi

while true

case "$1" in

--dead_master_host)

dead_master_host="${2}";

shift;;

--body)

body="${2}";

shift;;

--new_slave_hosts)

new_slave_hosts="${2}";

shift;;

--subject)

subject="${2}";

shift;;

--new_master_host)

new_master_host="${2}";

shift;;

--)

shift;

break;;

esac

shift

done

###End Get The Command-Line Parameters###

#--------------第二部分:命令行参数-----------------#

send_report;

226-232:ssh分发：

ssh-keygen -t rsa

ssh-copy-id root@172.16.54.226

ssh-copy-id root@172.16.54.227

ssh-copy-id root@172.16.54.228

ssh-copy-id root@172.16.54.230

ssh-copy-id root@172.16.54.231

ssh-copy-id root@172.16.54.232

#MHA管理231、232 SSH、repl检查：

masterha_check_ssh --conf=/etc/app1.cnf

masterha_check_repl --conf=/etc/app1.cnf

masterha_manager --conf=/etc/app1.cnf #启动

masterha_check_status --conf=/etc/app1.cnf #检查状态

#mysql 226-230:

vi /etc/cron.d/purge_relay_logs

# purge relay logs at 5am

0 5 * * * root /usr/bin/purge_relay_logs --user=mha_manager --host=172.16.54.226 --password='123456' --port=3306 --workdir=/opt/data/tmp --disable_relay_log_purge >> /var/log/masterha/purge_relay_logs.log 2>&1

2.1创建内核目录的链接文件

[root@Lvs-15.23 ~ 13:08:34]#ls /usr/src/kernels

2.6.18-308.el5-x86_64

[root@Lvs-15.23 ~ 13:08:42]#

ln -s /usr/src/kernels/2.6.18-308.el5-x86_64 /usr/src/linux

[root@Lvs-15.23 ~ 13:09:48]#ll /usr/src/linux

lrwxrwxrwx 1 root root 38 01-04 17:54 /usr/src/linux ->

/usr/src/kernels/2.6.18-308.el5-x86_64

2.2安装

[root@Lvs-15.23 xxm 13:13:00]#tar xf ipvsadm-1.24.tar.gz

[root@Lvs-15.23 xxm 13:13:11]#cd ipvsadm-1.24

[root@Lvs-15.23 ipvsadm-1.24 13:45:10]#make && make install

2.3开启路由转发功能

[root@Lvs-15.23 ~ 13:46:25]#/bin/sed -i 's/ip_forward = 0/ip_forward = 1/p' /etc/sysctl.conf

[root@Lvs-15.23 ~ 13:46:45]#sysctl -p

二、安装Keepalived

1下载

http://www.keepalived.org/

2安装

2.1软件安装

[root@Lvs-15.23 xxm 13:49:52]#tar xf keepalived-1.2.12.tar.gz

[root@Lvs-15.23 xxm 13:50:02]#cd keepalived-1.2.12

[root@Lvs-15.23 keepalived-1.2.12 13:50:03]#

./configure --prefix=/usr/local/keepalived

[root@Lvs-15.23 keepalived-1.2.12 13:51:38]#make && make install

2.2相关文件cp

此操作的原因->keepalived服务启动脚本默认指定了参数路径，所以为了能够正常启动keepalived服务，需要执行上述操作，当然也可以不cp目标文件，直接vi修改目标文件，将相应的参数指向为真实文件即可。

/bin/cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d

/bin/cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig

/bin/cp /usr/local/keepalived/sbin/keepalived /usr/sbin

/bin/mkdir /etc/keepalived

2.3分离Keepalived日志文件

2.3.1

[root@Lvs-15.23 keepalived 13:56:52]#vi /etc/sysconfig/keepalived

[root@Lvs-15.23 keepalived 13:57:54]#tail -2 /etc/sysconfig/keepalived

KEEPALIVED_OPTIONS="-D -d -S 0"

2.3.2修改syslog.conf定义keepalived的日志

[root@Lvs-15.23 ~ 13:59:52]#tail -2 /etc/syslog.conf

# Save keepalived messages to keepalived.log

local0.* /var/log/keepalived.log

2.3.2重启syslog服务

[root@Lvs-15.23 ~ 14:00:03]#/etc/init.d/syslog restart

三、配置Keepalived.conf

3.1 keepalived.conf文件

[root@Lvs-15.23 app1 14:03:38]#cd /etc/keepalived/

[root@Lvs-15.23 keepalived 14:04:35]#vi keepalived.conf

[root@Lvs-15.23 keepalived 14:04:57]#cat keepalived.conf

! Configuration File for keepalived

! Globals configurations

!!!!!!!!!!!!===全局配置===!!!!!!!!!!!

global_defs { !全局配置

notification_email { !通知邮件的收件人列表

test@qq.com

}

notification_email_from lvs-15.23@qq.com !发件人地址

smtp_server 127.0.0.1 !使用的邮箱服务器

smtp_connect_timeout 30 !连接smtp server的timeout

router_id masterha_manager_1

}

!!!!!!!!!!!!===全局配置===!!!!!!!!!!!

! VRRP configurations

!!!!!!!!!!!!===VRRP配置===!!!!!!!!!!!

vrrp_script check_masterha_manager { !声明一个自定义调用系统服务监控脚本，'check_masterha_manager'为自定义

script "/usr/local/scripts/check_masterha_manager.sh" !服务健康检查脚本，如果目标服务down，那么停掉本地 ! keepalived，实现failover

interval 3 !脚本被调用的频率,当前是每3秒调用一次

}

vrrp_sync_group mha { !声明一个vrrp group，'mha'为自定义,group里定义了一系列有相同特性的instance

group {

mha_app1 !自定义instan_1 'mha_app1'

}

vrrp_instance mha_app1 { !定义一个vrrp实例，'mha_app1'为自定义，具体实现group里定义的instance

state BACKUP !起初状态为bakcup

interface eth0 !虚拟ip绑定的目标网卡

virtual_router_id 61 !虚拟路由ID标记，主要是个标记作用整数型，range 0~100

priority 100 !优先级定义，值越大，优先级越高。整数型，range 0~255

advert_int 1 !检查间隔时间

authentication { !主从间实例的秘钥配对验证

auth_type PASS !简单的password验证

auth_pass 1111 !密码值

}

virtual_ipaddress { !进行failover的虚拟ip

! 192.168.15.96/24 label eth0:1 !也可以这样简单的写

192.168.15.96/24 !也可以这样简单的写

}

track_script { !跟踪监控脚本，调用之前定义的vrrp script 'check_masterha_manager'

check_masterha_manager

}

nopreempt !不抢占

smtp_alter ! failover后通过global里的邮件设置发通知邮件

notify_master "/usr/local/scripts/notify_master.sh"

notify_backup "/usr/local/scripts/notify_stop.sh"

notify_stop "/usr/local/scripts/notify_stop.sh"

}

!!!!!!!!!!!!===VRRP配置===!!!!!!!!!!!

!!!!!!!!!!!!===LVS配置===!!!!!!!!!!!

virtual_server_group MRead {

192.168.15.96 36677

}

virtual_server 192.168.15.96 36677 {

lvs_sched rr ! LVS的调度算法

lvs_method DR ! LVS的模式

protocol TCP

nat_mask 255.255.255.0

sorry_server 192.168.15.11 36677 !备机，可做故障迁移用

real_server 192.168.15.12 36677 {

weight 1

inhibit_on_failure

TCP_CHECK {

connect_port 36677

connect_timeout 10

nb_get_retry 3

delay_before_retry 1

}

real_server 192.168.15.13 36677 {

weight 1

inhibit_on_failure

TCP_CHECK {

connect_port 36677

connect_timeout 10

nb_get_retry 3

delay_before_retry 1

}

real_server 192.168.15.14 35577 {

weight 1

inhibit_on_failure

TCP_CHECK {

connect_port 36677

connect_timeout 10

nb_get_retry 3

delay_before_retry 1

}

!!!!!!!!!!!!===LVS配置===!!!!!!!!!!!

Lvs-15.24的keepalived配置文件有以下3处与Lvs-15.23不同，其他均一样：

[root@Lvs-15.24 keepalived 15:14:08]#cat keepalived.conf_real

......

notification_email_from lvs-15.24@qq.com !发件人地址

.......

router_id masterha_manager_2

......

virtual_router_id 61 ! 虚拟路由ID标记，主要是个标记作用整数型，range 0~100

priority 50 ! 优先级定义，值越大，优先级越高。整数型，range 0~255

......

3.2 check_masterha_manager脚本

#!/bin/bash

###变量及函数定义###

MHA_OK=0 ##mha正常运行，MHA_OK为0，反之为1

CHECK_TIME=3 ##此次脚本检查共检查3次

VIP=192.168.4.96

function mha_check() {

/sbin/ip addr|grep ${VIP} > /dev/null 2>&1

if [ $? -eq 0 ]

then

/usr/bin/masterha_check_status --conf=/etc/app1.cnf > /dev/null 2>&1 #检查masterha_manager的运行状态

if [ $? -eq 2 ]

then

MHA_OK=1

else

MHA_OK=0

else

exit 0

}

###变量及函数定义###

###实现三次检查###

while [ ${CHECK_TIME} -ne 0 ]

CHECK_TIME=$((${CHECK_TIME}-1))

mha_check

if [ ${MHA_OK} -eq 0 ]

then

CHECK_TIME=0

exit 0

if [ ${MHA_OK} -eq 1 ] && [ ${CHECK_TIME} -eq 0 ]

then

/etc/init.d/keepalived stop

exit 1

sleep 1

done

###实现三次检查###

3.3 notify_master.sh脚本

[root@Lvs-15.23 ~ 14:14:27]#vi /usr/local/scripts/notify_master.sh

[root@Lvs-15.23 ~ 14:15:44]#cat /usr/local/scripts/notify_master.sh

#!/bin/bash

scp root@Lvs-15.24:/etc/app1.cnf /etc/ #Lvs-15.24上要scp15.23的到本地

/usr/bin/nohup /usr/bin/masterha_manager --conf=/etc/app1.cnf --wait_on_monitor_error=10 --wait_on_failover_error=10 --remove_dead_master_conf < /dev/null > /var/log/masterha/app1/app1.log 2>&1 &

#/usr/bin/nohup /usr/bin/masterha_manager --conf=/etc/app1.cnf --wait_on_failover_error=10 --remove_dead_master_conf < /dev/null > /var/log/masterha/app1/app1.log 2>&1 &

3.4 notify_stop.sh脚本

[root@Lvs-15.23 ~ 14:15:47]#vi /usr/local/scripts/notify_stop.sh

[root@Lvs-15.23 ~ 14:16:41]#cat /usr/local/scripts/notify_stop.sh

#!/bin/bash

masterha_check_status --conf=/etc/app1.cnf|tr ' ' '\n'|grep pid > /dev/null 2>&1

if [ $? -eq 0 ]

then

kill -9 `masterha_check_status --conf=/etc/app1.cnf |cut -d' ' -f2|cut -d':' -f2|tr ')' ' '`

echo "kill command"

else

echo "no pid"

exit 0

四、MySQL-slave上配置vip

在MySQL-15.11、MySQL-15.12、MySQL-15.13、MySQL-15.14上编写如下文件，启动并加入开机自启动

[root@MySQL-15.11 ~ 15:29:37]#vi /etc/init.d/lvsrs

[root@MySQL-15.11 ~ 15:29:41]#ll /etc/init.d/lvsrs

-rw-r--r-- 1 root root 1004 01-18 15:29 /etc/init.d/lvsrs

[root@MySQL-15.11 ~ 15:29:43]#chmod +x /etc/init.d/lvsrs

[root@MySQL-15.11 ~ 15:29:52]#cat /etc/init.d/lvsrs

#!/bin/bash

#chkconfig: 2345 80 90

#description:config VIP on LVS of Real Server

VIP=192.168.15.96

#./etc/rc.d/init.d/functions

case "$1" in

start)

echo " Start LVS of Real Server"

/sbin/ifconfig lo:0 $VIP broadcast $VIP netmask 255.255.255.255 up

/sbin/route add -host ${VIP} dev lo:0

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

/sbin/sysctl -p > /dev/null 2>&1

;;

stop)

/sbin/ifconfig lo:0 down

echo "close LVS Director server"

echo "0" >/proc/sys/net/ipv4/conf/lo/arp_ignore

echo "0" >/proc/sys/net/ipv4/conf/lo/arp_announce

echo "0" >/proc/sys/net/ipv4/conf/all/arp_ignore

echo "0" >/proc/sys/net/ipv4/conf/all/arp_announce

/sbin/sysctl -p > /dev/null 2>&1

;;

echo "Usage: $0 {start|stop}"

exit 1

esac

[root@MySQL-15.11 ~ 15:32:06]#chkconfig lvsrs on

[root@MySQL-15.11 ~ 15:32:30]#chkconfig --list lvsrs

lvsrs 0:关闭 1:关闭 2:启用 3:启用 4:启用 5:启用 6:关闭

五、测试

1启动lvsrs

4台MySQL服务器启动lvsrs

注：MySQL-15.11也启动lvsrs，是因为将其定位了sorry_server，若没有此需求，当然可以不在MySQL-15.11上启动lvsrs。

以MySQL-15.12为例：

[root@MySQL-15.12 ~ 20:31:08]#/etc/init.d/lvsrs start

Start LVS of Real Server

[root@MySQL-15.12 ~ 20:38:07]#ip addr|grep 15.96

inet 192.168.15.96/32 brd 192.168.15.96 scope global lo:0

2 启动keepalived服务

两台Lvs服务器Lvs-15.23（主）、Lvs-15.24（从）启动keepalived服务

Lvs-15.23：

[root@Lvs-15.23 ~ 20:28:30]#/etc/init.d/keepalived start

启动keepalived： [确定]

You have new mail in /var/spool/mail/root

[root@Lvs-15.23 ~ 20:40:07]#ip addr|grep 15.96

inet 192.168.15.96/24 scope global secondary eth0

[root@Lvs-15.23 ~ 20:40:15]#masterha_check_status --conf=/etc/app1.cnf

app1 (pid:17521) is running(0:PING_OK), master:192.168.15.11

Lvs-15.24：

[root@Lvs-15.24 ~ 20:40:52]#/etc/init.d/keepalived start

启动keepalived： [确定]

[root@Lvs-15.24 ~ 20:40:57]#ip addr|grep 15.96

[root@Lvs-15.24 ~ 20:41:09]#masterha_check_status --conf=/etc/app1.cnf

app1 is stopped(2:NOT_RUNNING).

3测试masterha_manager及Lvs的failover

Lvs-15.23上的keepalived服务停止

[root@Lvs-15.23 ~ 20:40:27]#/etc/init.d/keepalived stop

停止keepalived： [确定]

[root@Lvs-15.23 ~ 20:42:43]#ip addr|grep 15.96

[root@Lvs-15.23 ~ 20:42:59]#masterha_check_status --conf=/etc/app1.cnf

app1 is stopped(2:NOT_RUNNING).

查看Lvs-15.24的状态：

[root@Lvs-15.24 ~ 20:42:47]#ip addr|grep 15.96

inet 192.168.15.96/24 scope global secondary eth0

[root@Lvs-15.24 ~ 20:43:29]#masterha_check_status --conf=/etc/app1.cnf

app1 (pid:22419) is running(0:PING_OK), master:192.168.15.11

[root@Lvs-15.24 ~ 20:43:31]#ipvsadm -L

IP Virtual Server version 1.2.1 (size=4096)

Prot LocalAddress:Port Scheduler Flags

-> RemoteAddress:Port Forward Weight ActiveConn InActConn

TCP 192.168.15.96:35577 rr

-> MySQL-15.14:36677 Route 1 0 0

-> MySQL-15.13:36677 Route 1 0 0

-> MySQL-15.12:36677 Route 1 0 0

用VIP访问试一下：

mysql -u'xxm_test' -p'123456' -h'192.168.15.96' -P'36677'

mysql -u'xxm_test' -p'123456' -h'192.168.15.95' -P'36677'

|||

均可正常访问

码农公寓

相关文章