Linux.com

Home Linux Community Forums Linux System Administration Network Management Using keepalived load balancer for the MySQL Cluster

Using keepalived load balancer for the MySQL Cluster

Link to this post 15 Aug 12

Hello Everyone,

I have a working MySQL cluster which is based on 2 nodes.

Now on my 3rd server i want to use it as a Load balancer for the MySQL cluster.

As, i do not have that much experience in load balancing part so i Google for it and i finally made my configuration file.

Kindly take a look at the attached config file.

And please tell me if i am missing some parameters.

Thanks,
usmangt

Link to this post 15 Aug 12

Since, in the forum the file attachment is not working so i am pasting it in here


global_defs {
router_id OX
}

vrrp_sync_group OX_GROUP {
group {
OX_GOUP
}
}

vrrp_instance OX_VRRP {
state BACKUP
interface eth0
garp_master_delay 10
virtual_router_id 10
priority 101
nopreempt
advert_int 1
authentication {
auth_type PASS # Simple 'PASS' can use
auth_pass example # example password '1234'
}
virtual_ipaddress {
10.10.10.249/24 brd 10.10.10.255 dev eth0 # virtual service ip 10.10.10.249
}
virtual_ipaddress_excluded {
}
}

virtual_server_group OX_HTTP {
10.10.10.249 3306 # virtual ip and port 3306
}

virtual_server group OX_HTTP {
delay_loop 3
lvs_sched rr
lvs_method DR
protocol TCP
virtualhost 10.10.10.249

real_server 10.10.10.187 3306 {
weight 1
inhibit_on_failure
TCP_CHECK {
connect_port 3306
connect_timeout 10
}
}

real_server 10.10.10.189 3306 {
weight 1
inhibit_on_failure
TCP_CHECK {
connect_port 3306
connect_timeout 10
}
}
}

Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board