首页 文章 精选 留言 我的

精选列表

搜索[代理],共10004篇文章
优秀的个人博客,低调大师

Mysql中间件代理 Atlas

本文接上文介绍atlas的安装配置,以及借助keepalive软件实现altas的ha,避免由于atlas故障,导致数据库服务中断的情况出现: 一:环境介绍 Atlas主:192.168.1.12/24 Atlas从:192.168.1.81/24 Atlasvip:192.168.1.230/24 Atlaswrite: master:192.168.1.225/24 Slave1:192.168.1.226/24 Slave2:192.168.1.227/24 管理节点:192.168.1.12/24 Mhavip:192.168.1.231/24 Atlasread: Slave2:192.168.1.227/24 Slave3:192.168.1.228/24 二:安装atlas,12服务器及81服务器执行同样的操作 1 2 3 4 5 6 7 #yum-yinstallopensslopenssl-devel #wgethttps://github.com/Qihoo360/Atlas/releases/download/2.1/Atlas-2.1.el6.x86_64.rpm #rpm-ivhAtlas-2.1.el6.x86_64.rpm #cd/usr/local/mysql-proxy/conf/ #/usr/local/mysql-proxy/bin/encrypt123456 /iZxz+0GRoA= #grep-v'^#'/usr/local/mysql-proxy/conf/test.cnf|grep-v'^$' 1 2 3 4 5 6 7 8 9 10 11 12 13 [mysql-proxy] admin-username=admin admin-password=admin proxy-backend-addresses=192.168.1.231:3306 proxy-read-only-backend-addresses=192.168.1.227:3306,192.168.1.228:3306 pwds=root:/iZxz+0GRoA= daemon=true keepalive=true event-threads=8 log-level=message log-path=/usr/local/mysql-proxy/log proxy-address=0.0.0.0:1234 admin-address=0.0.0.0:2345 #/usr/local/mysql-proxy/bin/mysql-proxydteststart OK:MySQL-Proxyoftestisstarted #netstat-ntpl|grepmysql-proxy tcp000.0.0.0:23450.0.0.0:*LISTEN29643/mysql-proxy tcp000.0.0.0:12340.0.0.0:*LISTEN29643/mysql-proxy #tail-f/usr/local/mysql-proxy/log/test.log 1 2 3 4 5 6 2014-10-2911:12:11:(message)mysql-proxy0.8.2started-instance:test 2014-10-2911:12:11:(message)proxylisteningonport0.0.0.0:1234 2014-10-2911:12:11:(message)addedread/writebackend:192.168.1.231:3306 2014-10-2911:12:11:(message)addedread-onlybackend:192.168.1.227:3306 2014-10-2911:12:11:(message)chassis-unix-daemon.c:138:[angel]wetrytokeepPID=29643alive2014-10-2911:12:11:(message)addedread-onlybackend:192.168.1.228:3306 2014-10-2911:12:11:(message)chassis-event-thread.c:235:starting8threads #/usr/local/mysql/bin/mysql-h192.168.1.12-P1234-uroot-p123456 #/usr/local/mysql/bin/mysql-h192.168.1.12-P2345-uadmin-padmin 三:安装keepalived 此处以12服务器为例,81服务器执行同样的操作 1 2 3 4 5 #cd/usr/local/src/ #wgethttp://www.keepalived.org/software/keepalived-1.2.13.tar.gz #tar-zxvpfkeepalived-1.2.13.tar.gz #cdkeepalived-1.2.13 #./configure--prefix=/usr/local/keepalived&&make&&makeinstall 四:配置12服务器keepalive 1:keepalive主配置文件 #cat/usr/local/keepalived/etc/keepalived/keepalived.conf 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 !ConfigurationFileforkeepalived global_defs{ router_idLVS_DEVEL } vrrp_scriptMonitor_Atlas{ script"/usr/local/scripts/monitor_atlas.sh" interval2 weight2 } vrrp_instanceVI_1{ stateMASTER interfaceeth0 virtual_router_id51 mcast_src_ip192.168.1.12 priority100 advert_int1 authentication{ auth_typePASS auth_passpassword_123 } track_script{ Monitor_Atlas } virtual_ipaddress{ 192.168.1.230 } } 2:监控atlas脚本 #cat/usr/local/scripts/monitor_atlas.sh 1 2 3 4 5 6 7 8 9 #!/bin/bash if[$(ps-ef|grep'mysql-proxy'|grep-v'grep'|wc-l)-eq"0"];then /usr/local/mysql-proxy/bin/mysql-proxydteststart sleep5 if[$(ps-ef|grep'mysql-proxy'|grep-v'grep'|wc-l)-eq"0"];then killall-9keepalived servicenetworkrestart fi fi #chmod+x/usr/local/scripts/monitor_atlas.sh 五:配置81服务器keepalive 1:keepalive主配置文件 #cat/usr/local/keepalived/etc/keepalived/keepalived.conf 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 !ConfigurationFileforkeepalived global_defs{ router_idLVS_DEVEL } vrrp_scriptMonitor_Atlas{ script"/usr/local/scripts/monitor_atlas.sh" interval2 weight2 } vrrp_instanceVI_1{ stateBACKUP interfaceeth0 virtual_router_id51 mcast_src_ip192.168.1.81 priority90 advert_int1 authentication{ auth_typePASS auth_passpassword_123 } track_script{ Monitor_Atlas } virtual_ipaddress{ 192.168.1.230 } } 2:监控atlas脚本 #cat/usr/local/scripts/monitor_atlas.sh 1 2 3 4 5 6 7 8 9 #!/bin/bash if[$(ps-ef|grep'mysql-proxy'|grep-v'grep'|wc-l)-eq"0"];then /usr/local/mysql-proxy/bin/mysql-proxydteststart sleep5 if[$(ps-ef|grep'mysql-proxy'|grep-v'grep'|wc-l)-eq"0"];then killall-9keepalived servicenetworkrestart fi fi #chmod+x/usr/local/scripts/monitor_atlas.sh 六:启动keepalive服务及测试 1:12服务器 #/usr/local/keepalived/sbin/keepalived-D-f/usr/local/keepalived/etc/keepalived/keepalived.conf #tail-f/var/log/messages 2:81服务器 #/usr/local/keepalived/sbin/keepalived-D-f/usr/local/keepalived/etc/keepalived/keepalived.conf #tail-f/var/log/messages 3:连接atlas测试 #/usr/local/mysql/bin/mysql-h192.168.1.230-P1234-uroot-p123456 mysql>selectuser,host,passwordfrommysql.user; #/usr/local/mysql/bin/mysql-h192.168.1.230-P2345-uadmin-padmin mysql>SELECT*FROMbackends; 4:故障测试 12服务器上关闭keepalive服务 81服务器的keepalive会自动接管vip服务 #tail-f/var/log/messages 本文转自斩月博客51CTO博客,原文链接http://blog.51cto.com/ylw6006/1569276如需转载请自行联系原作者 ylw6006

资源下载

更多资源
Mario

Mario

马里奥是站在游戏界顶峰的超人气多面角色。马里奥靠吃蘑菇成长,特征是大鼻子、头戴帽子、身穿背带裤,还留着胡子。与他的双胞胎兄弟路易基一起,长年担任任天堂的招牌角色。

Nacos

Nacos

Nacos /nɑ:kəʊs/ 是 Dynamic Naming and Configuration Service 的首字母简称,一个易于构建 AI Agent 应用的动态服务发现、配置管理和AI智能体管理平台。Nacos 致力于帮助您发现、配置和管理微服务及AI智能体应用。Nacos 提供了一组简单易用的特性集,帮助您快速实现动态服务发现、服务配置、服务元数据、流量管理。Nacos 帮助您更敏捷和容易地构建、交付和管理微服务平台。

Spring

Spring

Spring框架(Spring Framework)是由Rod Johnson于2002年提出的开源Java企业级应用框架,旨在通过使用JavaBean替代传统EJB实现方式降低企业级编程开发的复杂性。该框架基于简单性、可测试性和松耦合性设计理念,提供核心容器、应用上下文、数据访问集成等模块,支持整合Hibernate、Struts等第三方框架,其适用范围不仅限于服务器端开发,绝大多数Java应用均可从中受益。

WebStorm

WebStorm

WebStorm 是jetbrains公司旗下一款JavaScript 开发工具。目前已经被广大中国JS开发者誉为“Web前端开发神器”、“最强大的HTML5编辑器”、“最智能的JavaScript IDE”等。与IntelliJ IDEA同源,继承了IntelliJ IDEA强大的JS部分的功能。

用户登录
用户注册