--192.168.95.11£ºMySQL
server-id=11 #ÈÎÒâ×ÔÈ»Êýn£¬Ö»Òª±£Ö¤Á½Ì¨MySQLÖ÷»ú²»Öظ´¾Í¿ÉÒÔÁË¡£
log-bin=mysql-bin #¿ªÆô¶þ½øÖÆÈÕÖ¾
auto_increment_increment=2 #²½½øÖµauto_imcrement¡£Ò»°ãÓÐn̨Ö÷MySQL¾ÍÌîn
auto_increment_offset=1 #Æðʼֵ¡£Ò»°ãÌîµÚn̨Ö÷MySQL¡£´ËʱΪµÚһ̨Ö÷MySQL
binlog-ignore=mysql #ºöÂÔmysql¿â¡¾ÎÒÒ»°ã¶¼²»Ð´¡¿
binlog-ignore=information_schema #ºöÂÔinformation_schema¿â¡¾ÎÒÒ»°ã¶¼²»Ð´¡¿
replicate-do-db=aa #Ҫͬ²½µÄÊý¾Ý¿â£¬Ä¬ÈÏËùÓпâ
--192.168.95.12£ºMySQL
server-id=12
log-bin=mysql-bin
auto_increment_increment=2
auto_increment_offset=2
replicate-do-db=aa

mysql>GRANT REPLICATION SLAVE ON *.* TO ¡®mysql11¡¯@¡¯192.168.95.11¡¯ IDENTIFIED BY ¡¯mysql11¡¯;
mysql>FLUSH PRIVILEGES;

mysql> show master status;

¸´ÖÆ´úÂë
mysql> change master to
-> master_host='192.168.95.11',
-> master_user='mysql11',
->master_password='mysql11',
->master_log_file='mysql-bin.000097',
-> master_log_pos=107;

mysql> slave start;
mysql> show slave status\G

# tar -zxvf haproxy-1.5.14.tar.gz
# cd haproxy-1.5.14
# make TARGET=linux26 ARCH=x86_64
# make install SBINDIR=/usr/sbin/ MANDIR=/usr/share/man/ DOCDIR=/usr/share/doc/

¸´ÖÆ´úÂë
#!/bin/sh
#
# haproxy
#
# chkconfig: - 85 15
# description: HAProxy is a free, very fast and reliable solution \
# offering high availability, load balancing, and \
# proxying for TCP and HTTP-based applications
# processname: haproxy
# config: /etc/haproxy/haproxy.cfg
# pidfile: /var/run/haproxy.pid

# Source function library.
. /etc/rc.d/init.d/functions

# Source networking configuration.
. /etc/sysconfig/network

# Check that networking is up.
[ "$NETWORKING" = "no" ] && exit 0

exec="/usr/sbin/haproxy"
prog=$(basename $exec)

[ -e /etc/sysconfig/$prog ] && . /etc/sysconfig/$prog

cfgfile=/etc/haproxy/haproxy.cfg
pidfile=/var/run/haproxy.pid
lockfile=/var/lock/subsys/haproxy

check() {
$exec -c -V -f $cfgfile $OPTIONS
}

start() {
$exec -c -q -f $cfgfile $OPTIONS
if [ $? -ne 0 ]; then
echo "Errors in configuration file, check with $prog check."
return 1
fi

echo -n $"Starting $prog: "
# start it up here, usually something like "daemon $exec"
daemon $exec -D -f $cfgfile -p $pidfile $OPTIONS
retval=$?
echo
[ $retval -eq 0 ] && touch $lockfile
return $retval
}

stop() {
echo -n $"Stopping $prog: "
# stop it here, often "killproc $prog"
killproc $prog
retval=$?
echo
[ $retval -eq 0 ] && rm -f $lockfile
return $retval
}

restart() {
$exec -c -q -f $cfgfile $OPTIONS
if [ $? -ne 0 ]; then
echo "Errors in configuration file, check with $prog check."
return 1
fi
stop
start
}

reload() {
$exec -c -q -f $cfgfile $OPTIONS
if [ $? -ne 0 ]; then
echo "Errors in configuration file, check with $prog check."
return 1
fi
echo -n $"Reloading $prog: "
$exec -D -f $cfgfile -p $pidfile $OPTIONS -sf $(cat $pidfile)
retval=$?
echo
return $retval
}

force_reload() {
restart
}

fdr_status() {
status $prog
}

case "$1" in
start|stop|restart|reload)
$1
;;
force-reload)
force_reload
;;
check)
check
;;
status)
fdr_status
;;
condrestart|try-restart)
[ ! -f $lockfile ] || restart
;;
*)
echo $"Usage: $0 {start|stop|status|restart|try-restart|reload|force-reload}"
exit 2
esac

#chmod +x /etc/init.d/haproxy

# mkdir /etc/haproxy
# mkdir /var/lib/haproxy
# useradd -r haproxy #½¨Á¢½Å±¾Æô¶¯Óû§
# vi /etc/haproxy/haproxy.cfg

global

log 127.0.0.1 local2 //ÈÕÖ¾¶¨Ò弶±ð
chroot /var/lib/haproxy //µ±Ç°¹¤×÷Ŀ¼
pidfile /var/run/haproxy.pid //½ø³Ìid
maxconn 4000 //×î´óÁ¬½ÓÊý
user haproxy //ÔËÐиijÌÐòµÄÓû§
group haproxy
daemon //ºǫ́ÐÎʽÔËÐÐ
stats socket /var/lib/haproxy/stats

defaults
mode tcp //haproxyÔËÐÐģʽ£¨http | tcp | health£©
log global
option dontlognull
option redispatch //serverId¶ÔÓ¦µÄ·þÎñÆ÷¹Òµôºó,Ç¿Öƶ¨Ïòµ½ÆäËû½¡¿µµÄ·þÎñÆ÷
retries 3 //Èý´ÎÁ¬½Óʧ°ÜÔò·þÎñÆ÷²»ÓÃ
timeout http-request 10s
timeout queue 1m
timeout connect 10s //Á¬½Ó³¬Ê±
timeout client 1m //¿Í»§¶Ë³¬Ê±
timeout server 1m //·þÎñÆ÷³¬Ê±
timeout http-keep-alive 10s
timeout check 10s //ÐÄÌø¼ì²â
maxconn 600 //×î´óÁ¬½ÓÊý

listen stats //ÅäÖÃhaproxy״̬ҳ£¨ÓÃÀ´²é¿´µÄÒ³Ã棩
mode http
bind :8888
stats enable
stats hide-version //Òþ²Øhaproxy°æ±¾ºÅ
stats uri /haproxyadmin?stats //Ò»»áÓÃÓÚ´ò¿ª×´Ì¬Ò³µÄuri
stats realm Haproxy\ Statistics //ÊäÈëÕË»§ÃÜÂëʱµÄÌáʾÎÄ×Ö
stats auth admin:admin //Óû§Ãû:ÃÜÂë

frontend main
bind 0.0.0.0:3306 //ʹÓÃ3306¶Ë¿Ú¡£¼àÌýÇ°¶Ë¶Ë¿Ú¡¾±íʾÈκÎip·ÃÎÊ3306¶Ë¿Ú¶¼»á½«Êý¾ÝÂÖ·¬×ª·¢µ½mysql·þÎñÆ÷Ⱥ×éÖС¿
default_backend mysql //ºó¶Ë·þÎñÆ÷×éÃû

backend mysql
balance leastconn //ʹÓÃ×îÉÙÁ¬½Ó·½Ê½µ÷¶È
server mysql1 192.168.95.11:3306 check port 3306 maxconn 300
server mysql2 192.168.95.12:3306 check port 3306 maxconn 300

# vi /etc/rsyslog.conf

#service rsyslog restart

# tar -zxvf keepalived-1.2.19.tar.gz
# ./configure --prefix=/usr/local/keepalived --sbindir=/usr/sbin/ --sysconfdir=/etc/ --mandir=/usr/local/share/man/ --with-kernel-dir=/usr/src/kernels/2.6.32-504.el6.x86_64/

# mount /dev/cdrom /home/suifeng2/rom/
# cd rom/
# cd Packages/
# ls |grep openssl

# rpm -ivh openssl-1.0.1e-30.el6.x86_64.rpm

# rpm -ivh libsepol-devel-2.0.41-4.el6.x86_64.rpm

# rpm -ivh pkgconfig-0.23-9.1.el6.x86_64.rpm

# rpm -ivh libselinux-devel-2.0.94-5.8.el6.x86_64.rpm

# rpm -ivh keyutils-libs-devel-1.4-5.el6.x86_64.rpm

# rpm -ivh libcom_err-devel-141.12-21.el6.x86_64.rpm

# rpm -ivh zlib-devel-1.2.3-29.el6.x86_64.rpm

# rpm -ivh openssl-devel-1.0.1e-30.el6.x86_64.rpm

# cd keepalived-1.2.19
# ./configure --prefix=/usr/local/keepalived --sbindir=/usr/sbin/ --sysconfdir=/etc/ --mandir=/usr/local/share/man/ --with-kernel-dir=/usr/src/kernels/2.6.32-504.el6.x86_64/
# make && make install

# chkconfig --add keepalived #Ìí¼Ó¿ª»ú×ÔÆô£¨ÎÒÔÝʱûÌí¼Ó£©
# chkconfig keepalived on

! Configuration File for keepalived
#¼òµ¥µÄÍ·²¿£¬ÕâÀïÖ÷Òª¿ÉÒÔ×öÓʼþ֪ͨ±¨¾¯µÈµÄÉèÖ㬴˴¦¾ÍÔݲ»ÅäÖÃÁË£»
global_defs {
notificationd LVS_DEVEL
}
#Ô¤Ïȶ¨ÒåÒ»¸ö½Å±¾£¬·½±ãºóÃæµ÷Óã¬Ò²¿ÉÒÔ¶¨Òå¶à¸ö£¬·½±ãÑ¡Ôñ£»
vrrp_script chk_haproxy {
script "/etc/keepalived/chk.sh" #¾ßÌå½Å±¾Â·¾¶
interval 2 #½Å±¾Ñ­»·ÔËÐмä¸ô
}
#VRRPÐéÄâ·ÓÉÈßÓàЭÒéÅäÖÃ
vrrp_instance VI_1 { #VI_1 ÊÇ×Ô¶¨ÒåµÄÃû³Æ£»
state BACKUP #MASTER±íʾÊÇһ̨Ö÷É豸£¬BACKUP±íʾΪ±¸ÓÃÉ豸¡¾ÎÒÃÇÕâÀïÒòΪÉèÖÃΪ¿ªÆô²»ÇÀÕ¼£¬ËùÒÔ¶¼ÉèÖÃΪ±¸Óá¿
nopreempt #¿ªÆô²»ÇÀÕ¼
interface eth0 #Ö¸¶¨VIPÐèÒª°ó¶¨µÄÎïÀíÍø¿¨
virtual_router_id 11 #VRIDÐéÄâ·Óɱêʶ£¬Ò²½Ð×ö·Ö×éÃû³Æ£¬¸Ã×éÄÚµÄÉ豸ÐèÒªÏàͬ
priority 130 #¶¨ÒåÕą̂É豸µÄÓÅÏȼ¶ 1-254£»¿ªÆôÁ˲»ÇÀÕ¼£¬ËùÒÔ´Ë´¦ÓÅÏȼ¶±ØÐë¸ßÓÚÁíһ̨

advert_int 1 #Éú´æ¼ì²âʱµÄ×é²¥ÐÅÏ¢·¢Ëͼä¸ô£¬×éÄÚÒ»ÖÂ
authentication { #ÉèÖÃÑéÖ¤ÐÅÏ¢£¬×éÄÚÒ»ÖÂ
auth_type PASS #ÓÐPASS ºÍ AH Á½ÖÖ£¬³£Óà PASS
auth_pass asd #ÃÜÂë
}
virtual_ipaddress {
192.168.95.55 #Ö¸¶¨VIPµØÖ·£¬×éÄÚÒ»Ö£¬¿ÉÒÔÉèÖöà¸öIP
}
track_script { #ʹÓÃÔÚÕâ¸öÓòÖÐʹÓÃÔ¤Ïȶ¨ÒåµÄ½Å±¾£¬ÉÏÃ涨ÒåµÄ
chk_haproxy
}

notify_backup "/etc/init.d/haproxy restart" #±íʾµ±Çл»µ½backup״̬ʱ,ÒªÖ´ÐеĽű¾
notify_fault "/etc/init.d/haproxy stop" #¹ÊÕÏʱִÐеĽű¾
}

# vi /etc/keepalived/chk.sh#!/bin/bash
#
if [ $(ps -C haproxy --no-header | wc -l) -eq 0 ]; then
/etc/init.d/keepalived stop
fi

# chmod +x /etc/keepalived/chk.sh

# service keepalived start

mysql> GRANT ALL ON *.* TO 'jack'@'192.168.95.%' IDENTIFIED BY '321';
mysql> FLUSH PRIVILEGES;

# tcpdump -n -i eth0 host 192.168.95.11 and 192.168.95.14
# tcpdump -n -i eth0 host 192.168.95.12 and 192.168.95.14