中小型网站建设教程,flash网站的制作,扁平化网站 源代码,营销型网站建设设计服务本文接上文介绍atlas的安装配置#xff0c;以及借助keepalive软件实现altas的ha#xff0c;避免由于atlas故障#xff0c;导致数据库服务中断的情况出现#xff1a;一#xff1a;环境介绍Atlas主#xff1a;192.168.1.12/# yum -y install openssl openssl-devel# wget h…本文接上文介绍atlas的安装配置以及借助keepalive软件实现altas的ha避免由于atlas故障导致数据库服务中断的情况出现一环境介绍Atlas主192.168.1.12/# yum -y install openssl openssl-devel# wget https://github.com/Qihoo360/Atlas/releases/download/2.1/Atlas-2.1.el6.x86_64.rpm# rpm -ivh Atlas-2.1.el6.x86_64.rpm# cd /usr/local/mysql-proxy/conf/# /usr/local/mysql-proxy/bin/encrypt 123456/iZxz0GRoA# grep -v ^# /usr/local/mysql-proxy/conf/test.cnf |grep -v ^$[mysql-proxy]admin-username adminadmin-password adminproxy-backend-addresses 192.168.1.231:3306proxy-read-only-backend-addresses 192.168.1.227:3306,192.168.1.228:3306pwds root:/iZxz0GRoAdaemon truekeepalive trueevent-threads 8log-level messagelog-path /usr/local/mysql-proxy/logproxy-address 0.0.0.0:1234admin-address 0.0.0.0:2345# /usr/local/mysql-proxy/bin/mysql-proxyd test startOK: MySQL-Proxy of test is started# netstat -ntpl |grep mysql-proxytcp 0 0 0.0.0.0:2345 0.0.0.0:* LISTEN 29643/mysql-proxytcp 0 0 0.0.0.0:1234 0.0.0.0:* LISTEN 29643/mysql-proxy# tail -f /usr/local/mysql-proxy/log/test.log2014-10-29 11:12:11: (message) mysql-proxy 0.8.2 started - instance: test2014-10-29 11:12:11: (message) proxy listening on port 0.0.0.0:12342014-10-29 11:12:11: (message) added read/write backend: 192.168.1.231:33062014-10-29 11:12:11: (message) added read-only backend: 192.168.1.227:33062014-10-29 11:12:11: (message) chassis-unix-daemon.c:138: [angel] we try to keep PID29643 alive2014-10-29 11:12:11: (message) added read-only backend: 192.168.1.228:33062014-10-29 11:12:11: (message) chassis-event-thread.c:235: starting 8 threads# cd /usr/local/src/# wget# tar -zxvpf keepalived-1.2.13.tar.gz# cd keepalived-1.2.13# ./configure --prefix/usr/local/keepalived make make install# cat /usr/local/keepalived/etc/keepalived/keepalived.conf! Configuration File for keepalivedglobal_defs {router_id LVS_DEVEL}vrrp_script Monitor_Atlas {script /usr/local/scripts/monitor_atlas.shinterval 2weight 2}vrrp_instance VI_1{state MASTERinterface eth0virtual_router_id 51mcast_src_ip 192.168.1.12priority 100advert_int 1authentication {auth_type PASSauth_pass password_123}track_script {Monitor_Atlas}virtual_ipaddress {192.168.1.230}}# cat /usr/local/scripts/monitor_atlas.sh#!/bin/bashif [ $(ps -ef |grep mysql-proxy |grep -v grep |wc -l) -eq 0 ];then/usr/local/mysql-proxy/bin/mysql-proxyd test startsleep 5if [ $(ps -ef |grep mysql-proxy |grep -v grep |wc -l) -eq 0 ];thenkillall -9 keepalivedservice network restartfifi1keepalive主配置文件# cat /usr/local/keepalived/etc/keepalived/keepalived.conf! Configuration File for keepalivedglobal_defs {router_id LVS_DEVEL}vrrp_script Monitor_Atlas {script /usr/local/scripts/monitor_atlas.shinterval 2weight 2}vrrp_instance VI_1{state BACKUPinterface eth0virtual_router_id 51mcast_src_ip 192.168.1.81priority 90advert_int 1authentication {auth_type PASSauth_pass password_123}track_script {Monitor_Atlas}virtual_ipaddress {192.168.1.230}}2监控atlas脚本本文原创发布php中文网转载请注明出处感谢您的尊重
