Using keepalived load balancer for the MySQL Cluster

usmangt

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

usmangt

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
        }
    }
}