MySQL主从复制与lvskeepalived单点写入读负载均衡高可用实验.doc

一、环境Master（主机A）：192.168.1.1Slave（主机B） ：192.168.1.2 ?W-VIP（写入） ?：192.168.1.3?R-VIP（读取） ?：192.168.1.4?Client（测试） ：192.168.1.100操作系统版本：CentOS release 6.4MySQL数据库版本：5.6.14keepalived版本：1.2.7LVS版本：1.26所有环境均为虚拟机 二、设计思路 1. 服务器A和B，通过mysql的slave进程同步数据。2. 通过keepalived启用两个虚IP：W-VIP/R-VIP，一个负责写入，一个负责读取，实现读写分离。3. A和B都存在时，W-VIP下将请求转发至主机A，R-VIP将请求转发给A和B，实现负载均衡。4. 当主机A异常时，B接管服务，W-VIP/R-VIP此时漂到了主机B上，此时这两个虚IP下都是主机B，实现高可用5. 当主机B异常时，R-VIP会将B踢出，其他不变 三、架构图 四、软件安装主从两个主机都要装以下软件：1. MySQL的安装（略）2. keepalived安装yum install keepalived2. LVS安装yum install ipvsadm 五、配置1. 配置MySQL的主从复制（略）2. 配置keepalivedMaster上的配置vi /etc/keepalived/keepalived.conf [plain]?view plaincopy !?Configuration?File?for?keepalived?? ?? global_defs?{?? ?????router_id?MySQL-ha?? }?? ?? vrrp_instance?VI_1?{?? ?????state?BACKUP?? ?????interface?eth1?? ?????virtual_router_id?90?? ?????priority?100?? ?????advert_int?1?? ?????notify_master?/usr/local/mysql/bin/remove_slave.sh?? ?????nopreempt?? ?????authentication?{?? ?????auth_type?PASS?? ?????auth_pass?1111?? ?????}?? ?????virtual_ipaddress?{?? ?????192.168.1.3?label?eth1:1?? ?????192.168.1.4?label?eth1:2?? ?????}?? }?? ?? virtual_server?192.168.1.3?6603?{???? ?????delay_loop?2?? ?????lb_algo?wrr?? ?????lb_kind?DR?? ?????persistence_timeout?60?? ?????protocol?TCP?? ?????real_server?192.168.1.1?6603?{?? ?????weight?3?? ?????notify_down?/usr/local/mysql/bin/mysql.sh?? ?????TCP_CHECK?{?? ?????connect_timeout?10?? ?????nb_get_retry?3?? ?????delay_before_retry?3?? ?????connect_port?6603?? ?????}?? ?????}?? }?? ?? virtual_server?192.168.1.4?6603?{?? ?????delay_loop?2?? ?????lb_algo?wrr?? ?????lb_kind?DR?? ?????persistence_timeout?60?? ?????protocol?TCP?? ?????real_server?192.168.1.1?6603?{?? ?????weight?1?? ?????notify_down?/usr/local/mysql/bin/mysql.sh?? ?????TCP_CHECK?{?? ?????connect_timeout?10?? ?????nb_get_retry?3?? ?????delay_before_retry?3?? ?????connect_port?6603?? ?????}?? ?????}?? ?????real_server?192.168.1.2?6603?{?? ?????weight?3?? ?????TCP_CHECK?{??