首页 / 数据库 / MySQL / mysql dba系统学习（19） 实现Mysql读操作负载均衡

mysql dba系统学习（19） 实现Mysql读操作负载均衡2014-06-25配置mysql+lvs+keeplived实现Mysql读操作的负载均衡

环境：

test1192.168.46.131master

test2192.168.46.130slave备份test库

test3调度器

1、安装与配置Keepalived

首先在节点test1、test2上安装Keepalived软件，软件安装非常简单。

[root@test1 ]# yum install -y openssl-devel[root@test1 ~]# wgethttp://www.keepalived.org/software/keepalived-1.2.1.tar.gz[root@test1 ~]# tar zxvf keepalived-1.2.1.tar.gz[root@test1 ~]# cd keepalived-1.2.1[root@test1 keepalived-1.2.1]# ./configure --prefix=/usr/local/keepalived[root@test1 keepalived-1.2.1]# make && make install[root@test1 ~]# cp /usr/local/keepalived/etc/sysconfig/keepalived/etc/sysconfig/[root@test1 ~]# cp /usr/local/keepalived/etc/rc.d/init.d/keepalived/etc/init.d/[root@test1 ~]# mkdir/etc/keepalived[root@test1 ~]# cp/usr/local/keepalived/etc/keepalived/keepalived.conf/etc/keepalived/[root@test1 ~]# ln -s/usr/local/keepalived/sbin/keepalived/usr/sbin/[root@test1 ~]# service keepalived startStarting keepalived: [OK]

Keepalived的配置也非常简单，仅仅需要一个配置文件即可完成HAcluster和lvs服务节点监控功能，在通过Keepalived搭建高可用的LVS集群实例中，主、备DirectorServer都需要安装Keepalived软件，安装成功后，默认的配置文件路径为/etc/Keepalived/Keepalived.conf。

一个完整的keepalived配置文件，有三个部分组成，分别是全局定义部分、vrrp实例定义部分以及虚拟服务器定义部分，配置好的文件内容如下：

！ Configuration File for keepalivedglobal_defs {notification_email {root@localhost}notification_email_fromroot@localhostsmtp_server 192.168.46.131smtp_connect_timeout 30router_id LVS_MASTER}vrrp_instance VI_1 {state MASTER//备库为BACKUPinterface eth2 //通过的网卡virtual_router_id 51priority 100//备库为99advert_int 1authentication {auth_type PASSauth_pass 1111}virtual_ipaddress {192.168.46.100}}virtual_server 192.168.46.100 3306 {delay_loop 30lb_algo rrlb_kind DRpersistence_timeout 50protocol TCPreal_server 192.168.46.131 3306 {weight 1MISC_CHECK{misc_path "/etc/keepalived/check_slave.pl 192.168.46.131"misc_dynamic}}real_server 192.168.46.130 3306 {weight 1MISC_CHECK{misc_path "/etc/keepalived/check_slave.pl 192.168.46.130"misc_dynamic}}}}