wordpress 站外链接,织梦门户网站模板,全国免费发布信息平台,网站建设哪家强在实际项目中#xff0c;Mycat 服务也需要考虑高可用性#xff0c;如果 Mycat 所在服务器出现宕机#xff0c;或 Mycat 服务故障#xff0c;需要有备机提供服务#xff0c;需要考虑 Mycat 集群。1、 高可用方案使用 HAProxy Keepalived 配合两台 Mycat 搭起 Mycat 集群Mycat 服务也需要考虑高可用性如果 Mycat 所在服务器出现宕机或 Mycat 服务故障需要有备机提供服务需要考虑 Mycat 集群。1、 高可用方案使用 HAProxy Keepalived 配合两台 Mycat 搭起 Mycat 集群实现高可用性。HAProxy实现了 MyCat 多节点的集群高可用和负载均衡HAProxy 自身的高可用则可以通过 Keepalived 来实现。角色ipmycat01192.168.199.217mycat02192.168.199.120HA(主)192.168.199.174keepalive(主机)192.168.199.174HA(主)192.168.199.199keepalive(主机192.168.199.199先配置好mycat并且启动mycat2 安装配置 HAProxy1、 安装 HAProxy2解压到/usr/local/src3进入解压后的目录查看内核版本进行编译[rootmycat05 software]# cd /usr/local/src/haproxy-1.5.18/[rootmycat05 haproxy-1.5.18]# uname -r3.10.0-957.el7.x86_64[rootmycat05 haproxy-1.5.18]# make TARGETlinux310 PREFIX/usr/local/haproxy ARCHx86_64# ARGETlinux310内核版本使用uname -r查看内核如3.10.0-957.el7此时该参数就为linux310#ARCHx86_64系统位数#PREFIX/usr/local/haprpxy #/usr/local/haprpxy为haprpxy安装路径。4编译完成后进行安装make install PREFIX/usr/local/haproxy5安装完成后创建目录、创建HAProxy配置文件mkdir -p /usr/data/haproxy/vim /usr/local/haproxy/haproxy.conf6向配置文件中插入以下配置信息,并保存globallog127.0.0.1local0#log127.0.0.1local1 notice#log loghost local0 infomaxconn4096chroot/usr/local/haproxypidfile/usr/data/haproxy/haproxy.piduid99gid99daemon#debug#quietdefaultslogglobalmode tcpoption abortoncloseoption redispatchretries3maxconn2000timeout connect5000timeout client50000timeout server50000listen proxy_statusbind :48066mode tcpbalance roundrobinserver mycat_1192.168.140.128:8066check inter 10sserver mycat_2192.168.140.127:8066check inter 10sfrontend admin_statsbind :7777mode httpstats enableoption httplogmaxconn10stats refresh 30sstats uri/adminstats auth admin:123123 //登陆账户and密码stats hide-versionstats adminif TRUE2、 启动验证1启动HAProxy/usr/local/haproxy/sbin/haproxy -f /usr/local/haproxy/haproxy.conf2查看HAProxy进程ps -ef|grep haproxy3打开浏览器访问如果Mycat主备机均已启动则可以看到如下图4验证负载均衡通过HAProxy访问Mycat在HAProxy主机上执行(192.168.199.174HA的主机地址)[rootmycat05 haproxy-1.5.18]# mysql -umycat -p123456 -h 192.168.199.174 -P 480663 配置 Keepalived1准备好Keepalived安装包传到/opt目录下2解压到/usr/local/srctar -zxvf keepalived-1.4.2.tar.gz -C /usr/local/src3安装依赖插件yum install -y gcc openssl-devel popt-devel4进入解压后的目录进行配置进行编译cd /usr/local/src/keepalived-1.4.2./configure --prefix/usr/local/keepalived5进行编译完成后进行安装make make install6运行前配置cp /usr/local/src/keepalived-1.4.2/keepalived/etc/init.d/keepalived /etc/init.d/mkdir /etc/keepalivedcp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/cp /usr/local/src/keepalived-1.4.2/keepalived/etc/sysconfig/keepalived /etc/sysconfig/cp /usr/local/keepalived/sbin/keepalived /usr/sbin/7修改配置文件vim /etc/keepalived/keepalived.conf#修改内容如下! Configuration File forkeepalivedglobal_defs {notification_email {xlcocoonfoxmail.com}notification_email_from keepalivedshowjoy.comsmtp_server127.0.0.1smtp_connect_timeout30router_id LVS_DEVELvrrp_skip_check_adv_addrvrrp_garp_interval0vrrp_gna_interval0}vrrp_instance VI_1 {#主机配MASTER备机配BACKUPstate MASTER#所在机器网卡interfaceens33virtual_router_id51#数值越大优先级越高priority100advert_int1authentication {auth_type PASSauth_pass1111}virtual_ipaddress {#虚拟IP192.168.199.111} }virtual_server192.168.199.111 48066{delay_loop6lb_algo rrlb_kind NATpersistence_timeout50protocol TCPreal_server192.168.199.174 48066{ # HA的地址(主机)weight1rTCP_CHECK {connect_timeout3retry3delay_before_retry3} }real_server192.168.199.199 48600{#HA地址(备机r)weight1TCP_CHECK {connect_timeout3nb_get_retry3delay_before_retry3}} }8、启动Keepalived同时启动备机上的HAservice keepalived start9、登录验证mysql -umycat -p123456 -h 192.168.199.111 -P 48066192.168.199.111 虚拟ip此时是HA隐藏mycat的ipKeepAlive隐藏HA的ip4 测试高可用1关闭mycat2通过虚拟ip查询数据mysql -umycat -p123456 -h 192.168.199.111 -P 48066mysql select * fromorders;ERROR2013(HY000): Lost connection to MySQL server during querymysql select * fromorders;ERROR2006(HY000): MySQL server has gone awayNo connection. Trying to reconnect...Connection id:2Current database: TESTDB--------------------------------------------| id | order_type | customer_id | amount |--------------------------------------------| 1 | 101 | 100 | 100100.00 || 2 | 101 | 100 | 100300.00 || 6 | 102 | 100 | 100020.00 || 3 | 101 | 101 | 120000.00 || 4 | 101 | 101 | 103000.00 || 5 | 102 | 101 | 100400.00 || 400100 | 102 | 101 | 1000.00 || 400101 | 102 | 101 | 1000.00 |--------------------------------------------8 rows in set (1.46 sec)
